connection string, c# jet 2002 (password/username)

[Keith00]

Hi all,

I have a c# app that uses an access db through this conn string. (All 2002 versions).

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\db1.mdb; User Id=Admin; Password=";

I am stuck on setting a password, I can set it on the db and open it in access using the password. I cant open the db using the same password in the conn string.

What am I doing wrong?
Please help.

 

[Remou]

If you mean a database password, try:

[tt]strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\db1.mdb" _
& ";Jet OLEDBatabase Password=passwordhere;"[/tt]

 

[Keith00]

Thank you, works perfectly!

Keith

 

[maxhugen]

Remou, is it possible to create a connection to an Access db at an FTP site? For example, by specifying:

[tt]Data Source=ftp://myFTPsite.com/myFolder/myDatabase.mdb[/tt]

Also, I'm having a prob declaring a connection:

[tt]Dim con As New ADODB.Connection[/tt]

I expect I'm missing a Reference, but I don't know which to use?



Max Hugen
Australia

 

[JoeAtWork]

Max - you should really start your own thread instead of interjecting into somebody elses.

But as a quick answer, I'm almost certain FTP won't work, it is a protocol for transferring files, and not method to access the contents of files remotely.

The reference to ADO is Microsoft ActivX Data Objects 2.x Library (msado2x.dll) - note 2.x refers to specific version like 2.1.

If you have more questions, start a second thread.