[RESOLVED] Provider cannot be found

[salsa31]

i added a password to my DB
i am trying to connect with vb
i get error provider cannot be found
why?
this is my code

  Set CN = New ADODB.Connection
    CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0" & "Data Source=" & App.Path & "\HairDesign.mdb" & "Password=035924794"
    CN.Open

[jpbro]

Print your connection string to the Debug window, and you'll see that your provider looks like this:

Microsoft.Jet.OLEDB.4.0Data Source=<YouAppPath>Password=035924794

There is no separation between your key/value pairs, so the connection string can't be parsed properly. You need a semicolon between your provider name and your Data Source key, and between your DB path and your password. E.g.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\HairDesign.mdb;Password=035924794"

[salsa31]

i get this error

[DataMiser]

Do you have the DB open in Access?

[salsa31]

no sir

[jpbro]

Double post...forum going bonkers.

[jpbro]

Do you use Kaspersky antivirus? If so, see these threads:

http://www.vbforums.com/showthread.p...tion-file-quot

http://forum.kaspersky.com/index.php...gopid=2218158&

[goranvuc]

For Access with password protection key is "Database Password", not "Password":

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\HairDesign.mdb;Database Password=035924794"

[goranvuc]

....

[goranvuc]

Do you use Kaspersky antivirus? If so, see these threads:

http://www.vbforums.com/showthread.p...tion-file-quot

http://forum.kaspersky.com/index.php...gopid=2218158&

There was a problem with one Kaspersky update about a month ago, i instantly found that Kaspersky is cause, problem was solved in 24 hr by Kaspersky team with next update, so this is not a reason...

[salsa31]

no antivirus of that kind jpbro

For Access with password protection key is "Database Password", not "Password":

error
could not find installable isam

[DataMiser]

Can you show us the actual string you are using now?

[Nightwalker83]

error
could not find installable isam

You need to change the database type! Which version of Access are you using?

Edit:

If you open the database in Access it should say something such as "database name: Database (Access x file format)". x being the version. Note: this might be different to the version of the software you are running. For the connection string mentioned in the first post needs to be Access 2000 format. I forget which provide and provide version needs to be used for the other versions of Access.

database name = "Whatever your database or table is called".

[gibra]

i added a password to my DB
i am trying to connect with vb
i get error provider cannot be found
why?
this is my code

  Set CN = New ADODB.Connection
    CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0" & "Data Source=" & App.Path & "\HairDesign.mdb" & "Password=035924794"
    CN.Open

Your connection string is wrong.
To open a Access database password protected from VB6.0, you must use Jet OLEDB:Database Password parameter:

Dim sql As String
sql = "Provider=Microsoft.Jet.OLEDB.4.0;" 
sql = sql & "Data Source=" & App.Path & "\HairDesign.mdb;"
sql = sql & "Jet OLEDB:Database Password=035924794"
CN.ConnectionString = sql

[salsa31]

tnk you gibra it is working now