Connection Error to Jet database 
Author Message
 Connection Error to Jet database

I am getting a connection error to a MS Access DB from a VB6 application.
The error message is:-
"Error: -2147217843 Authentication failed."

I have ADO installed as MDAC 2.7. My VB code that produces this error is:-

AccessDB="whatever.MDB"
set conn= new ADODB.connection
conn.connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                                        "Data Source=" & AccessDB &
";Persist Security Info=False;" & _
                                        "User Id=admin;" & _
                                        "Password=;"
conn.connectiontimeout= 30
conn.open

If anyone can point me in the correct direction, I shall be very grateful.

--
Chris Jones

(remove the x's to reach me)



Tue, 07 Sep 2004 23:25:24 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Copying records from jet database to a new jet database

2. How do you close a Jet Database Connection

3. Changing database connection using Jet OLEDB

4. Jet connection string for connecting to a Microsoft Access 2.0 database

5. Very slow database accessing over 128k connection using Jet 3.51

6. Holding open a connection to a Jet database

7. jet engine 91 error on connection

8. VB6 to Access2000 Jet Database Error

9. VB6 to Access 2000 Jet database Error

10. Error when connecting multiple VB apps to Access (JET) database

11. trapping jet database engine errors

12. Jet Database engine error.

 

 
Powered by phpBB® Forum Software