|
can any body tell
me connection string for accessing remote access data base located at my LAN
hello
|
|
|
|
|
If you want to use an Access database located on a different computer, you have to specify the path where you can access it, in the form of "\\somecomputer\somefolder\more\folders\i\guess\thedatabase.mbd".
Also you have to make the file available to the user account that will be used for the program using the database. This is probably only possible if the user account is a domain account, so that the user account can exist on more than one computer.
---
b { font-weight: normal; }
|
|
|
|
|
|
That doesn't help in this case. It has nothing on connecting to an Access database that is not on the same computer.
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: It has nothing on connecting to an Access database that is not on the same computer.
 Sure it does, Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword; is the one from http://www.connectionstrings.com[^] You will need a network share / drive mapped to your computer in order to access the Access db.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
hi
i have some images stored in sql server ,, i want to get those images and store them again in the access data base into oledb object field ,, how to convert image file into that format ,, any idea
thanks in advance
hello
|
|
|
|
|
You don't have to convert anything. The oledb field type in Access is equivalent to the image field type in SQL Server.
---
b { font-weight: normal; }
|
|
|
|
|
I am running a process card that has multi-users. Functionality would be to have an autocomplete box in the "dropdownlist" utility. Despite my attempts I am unable to have a keychange event used in the box.
This is the code I use for a combo box to autocomplete, but as my problem is in a dropdownlist, it does not allow me to use a keypress event.
Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ComboBox1.KeyPress
If Char.IsControl(e.KeyChar) Then Return
With Me.ComboBox1
Dim ToFind As String = .Text.Substring(0, .SelectionStart) & e.KeyChar
Dim Index As Integer = .FindStringExact(ToFind)
If Index = -1 Then Index = .FindString(ToFind)
If Index = -1 Then Return
.SelectedIndex = Index
.SelectionStart = ToFind.Length
.SelectionLength = .Text.Length - .SelectionStart
e.Handled = True
End With
End Sub
Please help with any method used to create a keypress event creator.
Regards,
Nicholas
|
|
|
|
|
Look around on this site, if you haven't already. There are several articles about AutoComplete functionality...
If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa
|
|
|
|
|
Hiya all.
I use advapi32.dll via VB.net to install a service, however I do not seem to think it goes as well as I'd like.
Often when I run the install, everything seems to indicate that it succeedes, but I can't find the service in neither my service list nor registry - although if I use the ServiceController class, I can get a status out on the service.
Similar when I attempt to start or stop the service, the code seems to run fine, but .... alas no service work seems to be done.
Lastly - I am having problems, again similar, with uninstalling - and about 50/50 I either can or can not uninstall (meaning the code runs through fine or not), yet because I can not see my service in the list when installed - I have no visible proof it is uninstalled other then the ServiceController class crashes if I try to get status.
This is the code I am using (VB.NET ... sorry, my company uses that instead of C#  )
<br />
Private Declare Auto Function OpenSCManager Lib "advapi32.dll" (ByVal strMachineName As String, ByVal strServiceControllerDB As String, ByVal intServiceController As Integer) As IntPtr<br />
Private Declare Auto Function CreateService Lib "advapi32.dll" (ByVal SCHANDLE As IntPtr, ByVal strServiceName As String, ByVal strDisplayName As String, _<br />
ByVal intDesiredAccess As Integer, ByVal intServiceType As Integer, ByVal intStartType As Integer, ByVal intErrorControl As Integer, ByVal strServicePath As String, _<br />
ByVal strLoadOrderGroup As String, ByVal intTagId As Integer, ByVal strDependencies As String, ByVal strServiceStartName As String, ByVal strPassword As String) As IntPtr<br />
Private Declare Auto Sub CloseServiceHandle Lib "advapi32.dll" (ByVal SCHANDLE As IntPtr)<br />
Private Declare Auto Function StartService Lib "advapi32.dll" (ByVal SVHANDLE As IntPtr, ByVal intNumServiceArgs As Integer, ByVal strServiceArgVectors As String) As Integer<br />
Private Declare Auto Function OpenService Lib "advapi32.dll" (ByVal SCHANDLE As IntPtr, ByVal strServiceName As String, ByVal intNumServiceArgs As Integer) As IntPtr<br />
Private Declare Auto Function DeleteService Lib "advapi32.dll" (ByVal SVHANDLE As IntPtr) As Integer<br />
Private Declare Auto Function GetLastError Lib "advapi32.dll" () As Integer<br />
Private Declare Function ControlService Lib "advapi32.dll" (ByVal SVHANDLE As IntPtr, ByVal intControl As Integer, ByVal objServiceStatus As SERVICE_STATUS) As Integer<br />
<br />
Friend Function InstallService(ByVal strServicePath As String, ByVal strServiceName As String, ByVal strServiceDisplayName As String) As Boolean<br />
Try<br />
'Get handle to Service Control Manager<br />
Dim SCMHANDLE As IntPtr = OpenSCManager(Nothing, Nothing, SC_MANAGER_CREATE_SERVICE)<br />
If SCMHANDLE.ToInt32 <> 0 Then<br />
'Get Handle to Service<br />
Dim SERVICEHANDLE As IntPtr = CreateService(SCMHANDLE, strServiceName, strServicePath, SERVICE_ALL_ACCESS, SERVICE_WIN32_OWN_PROCESS, SERVICE_AUTO_START, SERVICE_ERROR_NORMAL, strServiceDisplayName, Nothing, 0, Nothing, Nothing, Nothing)<br />
If SERVICEHANDLE.ToInt32 <> 0 Then<br />
If StartService(SERVICEHANDLE, 0, Nothing) <> 0 Then<br />
'Service started, close handler.<br />
CloseServiceHandle(SCMHANDLE)<br />
Return True<br />
Else<br />
'Service could not be started. Service could be running as well ( or installed?)<br />
Return False<br />
End If<br />
Else<br />
'Service handler could not be opened.<br />
End If<br />
Else<br />
'Service Control manager could not be opened.<br />
Return False<br />
End If<br />
Catch ex As Exception<br />
Throw ex<br />
End Try<br />
End Function<br />
<br />
Friend Function Uninstall(ByVal strServiceName As String)<br />
Dim GENERIC_WRITE As Integer = &H40000000<br />
'Get handle to Service Control Manager<br />
Dim SCMHANDLE As IntPtr = OpenSCManager(Nothing, Nothing, GENERIC_WRITE)<br />
'Get Handle to Service<br />
If SCMHANDLE.ToInt32 <> 0 Then<br />
Dim DELETE As Integer = &H10000<br />
Dim SERVICEHANDLE As IntPtr = OpenService(SCMHANDLE, strServiceName, DELETE)<br />
If SERVICEHANDLE.ToInt32 <> 0 Then<br />
If DeleteService(SERVICEHANDLE) <> 0 Then<br />
'Service deleted<br />
CloseServiceHandle(SCMHANDLE)<br />
Return True<br />
Else<br />
'Service could not be deleted<br />
CloseServiceHandle(SCMHANDLE)<br />
Return False<br />
End If<br />
Else<br />
'Service handler could not be opened.<br />
Return False<br />
End If<br />
Else<br />
'Service Control manager could not be opened.<br />
Return False<br />
End If<br />
End Function<br />
<br />
The code is a piecing of stuff I found off the net and some decompiling.
Can anybody advice me as to what I'm doing wrong, or is this method of controlling service installation buggy. I really would preferer such a method as this as I do not really want to call Shell and instalutil
Regards.
|
|
|
|
|
How can I update my database by making changes in changes in my xml file? Could someone reply?
samita
|
|
|
|
|
How does one get the assembly's Namespace Name?
I embedded some SQL scripts in an assembly. The assembly name is "AAI_TK1", it is in the "ArchiveXpress20" namespace.
Dim asm As System.Reflection.[Assembly] = System.Reflection.[Assembly].GetExecutingAssembly()
--> this returns "AAI_TK1" ----> asm.GetName().Name
However the Resource names are prefixed with the namespace
--> "ArchiveXpress20.Script1.SQL" ----> GetManifestResourceNames()
I didn't want to hardcode the namespace. How can you get your namespace?
|
|
|
|
|
Hi,
I recently had the same problem. My solution so far is creating an object OBJ
of a type defined in the same namespace, and then use OBJ.GetType().NameSpace
I too would prefer a simpler solution...
-- modified at 17:10 Thursday 7th December, 2006
Luc Pattyn
|
|
|
|
|
By initializing an 'XmlSerializer' object, you must specify what type of object you will serialize.
Any idea why you must do this by using an 'XmlSerializer' and not when you are using a 'BinaryFormatter' or any other formatter?
-- modified at 7:00 Friday 8th December, 2006
|
|
|
|
|
I have an enterprise template project on VC7 .NET.
When I enter the "Configuration manager" , I see that in Debug configuration one of the projects is not checked in the "Build" column, and thus this project is not compiled when I am building the solution. I check the project in the Build column, close the configuration manager window. The build solution now includes also the project that was not checked. But when I close and reopen the sln, this information is lost and the configuration manager window shows that project as unchecked.
This seems as a bug of the studio . . . ?!!???, is there a way to make my solution configuration to include unchecked project also?
Thanks in advance,
Julia.
|
|
|
|
|
Hi,
I want to encrypt soap username and password.
right now i only authenticate username and password.
in Webservice:
public class Authentication : SoapHeader
{
public string Username;
public string Password;
}
public class Service : System.Web.Services.WebService
{
public Authentication authenticate;
public Service () {}
[WebMethod]
[SoapHeader("authenticate", Required = true)]
public string DataManupulation(string InputXML)
{
// Forming OutputXML
return Ouput XML
}
}
in Client:
I'm creating object and passing SOAP Header,
now i want to pass encrypted SOAP header.
Can any one help me? Its very urgent.
Thanks in advance
Poongodi
|
|
|
|
|
|
Hi all listeners,
I want to receive two files in a orchrestration from differnet
locations(diferetnt sharepoint sites) and want to construct one of it
accordig to the other.
The scenario is:
first locatuion have number of (around 50) files containing "id" and "rank"
field in each file along with other fields.
I want to create a file containing a heading title and one record for each
file from first location listing "id" and "rank" for each file.
I am plannig for a flow for each file at first location, after this file is
received orch. will fech that "Rank" file from 2'nd location and append one
record for the received file from 1st location.
So i need 2 receive shapes and corrosponding ports.
I have defined correlation set for orch. and initialised it ...now its
giving me error:
"""" In a sequetial convoy the ports must be identical. """
"""" But i want tow diiferent ports for differet loccations
""""
What should i do???
And redig the scenario ...if u have some idea to solve it...please share it
with me...
Waiting for reply......
Mahavir.
|
|
|
|
|
Does anyone have conclusive evidence as to wether or not a .NET application can make use of the App Paths registry key? I created a tentative test app and it doesn't seem to find the additional DLLs, but I wanted to get some corroboration.
Thanks,
Scott.
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
Yes, it can be done. Post your code fragment here, and we can see what's not working.
|
|
|
|
|
ednrgc wrote: Post your code fragment here
I would but I don't think the problem is in the code.
I have an application that uses some common DLLs that could potentially be shared by some of our other products. Ideally, we would strong-name these DLLs and put them in the GAC, but (at least right now) I'm not allowed to do that. The next best thing would be to install the shared DLLs to a common folder.
In the installer (InstallShield 12), I create the following registry key:
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\Console.exe
(The name of the app in this case is "Console.exe")
and then create a Path string value with the following data:
C:\Program Files\Company\Product\; C:\Program Files\Common Files\Company
When I try to run Console.exe, I get an error saying that it can't find one of the required components. If I copy the DLLs from the common folder back to the local application folder, everything works properly.
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
I have a problem with VB and graphic. I can generate all the graphics i want but saving is only possible in bitmap.
I need to scale and modify the output of my software with AI or Corel Draw but do not get results. Vectorizing is not an option. I tried various vectorizer lice Corel Trace and the results are not what i expect.
Helmut Ehrhardt (Ghana)
|
|
|
|
|
asestar wrote: I tried various vectorizer lice Corel Trace and the results are not what i expect.
Have you found a solution to the problem?
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
No, i still do not have a clue.
|
|
|
|
|
Hi,
i want to ask can i call a crystal report without reportViewer control. i mean is there any way to call a report directly in some way??
basically i'm using c# express edition which do suports SQL server 2005 but doesnt support crystal reports. so i installed crystal report 10 seperately and begin using it. now in my C# IDE if i go to add Item then crystal report icon doesn't apear. also there is not report viewer control in the the controls area. so i asked this question. if there exists no way then sugest me what should i d0??
hope u'l respond for my satisfaction.
as far as my introduction is concerned i'm a student of BS doing my final project, i'm using .net since 1 year but crystal reports are new for me.
regards
thx in advance!!
regards
shaz jazz
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
