Connecting to Access using ODBC 
Author Message
 Connecting to Access using ODBC

Hi,
Could someone please help! I'm trying to Open  an Access 2.0 database
in VB 3.0 using ODBC. Here is what I do:

Set MyDB = OpenDatabase("DataSource1", False, False, "ODBC;DSN=DataSource1
                                              ;UID=Admin;PWD=""""")

I have tried omitting the 'UID and PWD' in the connect string but
I get an error #3000 "Reserved Error(), there is no message for this error".

I have the comp layer installed. I can Open the database without
ODBC, I.e. just by specifing the Access database filename. However,
I HAVE to use ODBC for what I'm doing.

Please help!

THanks,
Haresh




Tue, 19 Oct 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Access Hang when connecting to another MDB filr using access ODBC

2. connect to the MS Access database without using the ODBC driver for MS Access

3. Using ODBC-direkt in Access who is connected to SQL-Server

4. Connecting to a remote DB using ODBC from Access

5. Error connecting Access to SQL-server using ODBC

6. Connecting to Access 97 using ODBC -How?

7. Cannot connect to an Access DSN using ODBC!

8. Cannot connect to an Access DSN using ODBC

9. Cannot connect to an Access DSN using ODBC

10. Connecting to Oracle using ODBC/Access

11. using ODBC connect string in Access (DAO) to SQLServer

12. using ODBC connect string in Access (DAO) to SQLServer


 
Powered by phpBB® Forum Software