Connection StringII
-
I try to connect to a password secured database, with oledbdataadapter and I use the following connection string : @"Provider=Microsoft.Jet.OLEDB.4.0;User ID = admin;Password=""123"";Data Source=F:\Mehdi\C#\Source Code\Filing System Manager\Sample.mdb;" then I get the following error : --------------------------- Microsoft Data Link Error --------------------------- Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user. --------------------------- OK --------------------------- I would really apreciate an advise on this case :( thanks Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
-
I try to connect to a password secured database, with oledbdataadapter and I use the following connection string : @"Provider=Microsoft.Jet.OLEDB.4.0;User ID = admin;Password=""123"";Data Source=F:\Mehdi\C#\Source Code\Filing System Manager\Sample.mdb;" then I get the following error : --------------------------- Microsoft Data Link Error --------------------------- Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user. --------------------------- OK --------------------------- I would really apreciate an advise on this case :( thanks Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
I was receiving the same error when I was looking at this for you the first time. I came up with the following solution (As stated in MSDN). Change the following registry key to point to your .mdw security file. \HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\SystemDB I thought it was a bit of a hack, but I found enough documentation (in MSDN) that kept repeating it, so I tried it, and it works... There has to be a better way... Regards
-
I try to connect to a password secured database, with oledbdataadapter and I use the following connection string : @"Provider=Microsoft.Jet.OLEDB.4.0;User ID = admin;Password=""123"";Data Source=F:\Mehdi\C#\Source Code\Filing System Manager\Sample.mdb;" then I get the following error : --------------------------- Microsoft Data Link Error --------------------------- Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user. --------------------------- OK --------------------------- I would really apreciate an advise on this case :( thanks Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
Just found the better way... string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Peon;Password=PeonPassword;Data Source=C:\MyPath\SomeDatabase.mdb;Jet OLEDB:System database=C:\MyPath\MySecurityDatabase.mdw"; Regards
-
Just found the better way... string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Peon;Password=PeonPassword;Data Source=C:\MyPath\SomeDatabase.mdb;Jet OLEDB:System database=C:\MyPath\MySecurityDatabase.mdw"; Regards
Thank you Neil,Now I'm not at place to check it but I'll do it as soos as possible. :) Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
-
Thank you Neil,Now I'm not at place to check it but I'll do it as soos as possible. :) Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
Hi neil, Thanks for the help, it solved my problem.. well almost !!! Now I get this error message (It's because of the username and password of the mdb file, ichecked it ) with the right username and password it gives the same thing ! --------------------------- --------------------------- Index #0 Message: Not a valid account name or password. Native: -124585838 Source: Microsoft JET Database Engine SQL: 3029 --------------------------- OK --------------------------- It's really getting on my nerves :(( I wonder if u could solve this problem, too. thanks Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
-
Hi neil, Thanks for the help, it solved my problem.. well almost !!! Now I get this error message (It's because of the username and password of the mdb file, ichecked it ) with the right username and password it gives the same thing ! --------------------------- --------------------------- Index #0 Message: Not a valid account name or password. Native: -124585838 Source: Microsoft JET Database Engine SQL: 3029 --------------------------- OK --------------------------- It's really getting on my nerves :(( I wonder if u could solve this problem, too. thanks Mazy "The path you tread is narrow and the drop is shear and very high, The ravens all are watching from a vantage point near by, Apprehension creeping like a choo-train uo your spine, Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
My passwords work :-D, Sorry... I did notice your connection string had quotes (in the root of this thread) around the password, get rid of those... Regards