Connecting to an MDB file thru ODBC *without* using DSN 
Author Message
 Connecting to an MDB file thru ODBC *without* using DSN

Hello,
Can someone explain how to connect to an Access MDB file in VC5 using MFC
ODBC *without* using a DSN?

Thanks,
Nadav Kehati
CallManage, Inc.



Fri, 10 Nov 2000 03:00:00 GMT  
 Connecting to an MDB file thru ODBC *without* using DSN

Hi,

odbc;Driver={Microsoft Access Driver (*.mdb)};

should do the trick.

-Priya



Quote:
> Hello,
> Can someone explain how to connect to an Access MDB file in VC5 using MFC
> ODBC *without* using a DSN?

> Thanks,
> Nadav Kehati
> CallManage, Inc.



Fri, 10 Nov 2000 03:00:00 GMT  
 Connecting to an MDB file thru ODBC *without* using DSN

Thanks, this helped, but funny enough works only *without* the "odbc;"
prefix.

Works:
    "DRIVER=Microsoft Access Driver (*.mdb);DBQ=MyFile.mdb"
Don't work:
    "ODBC;DRIVER=Microsoft Access Driver (*.mdb);DBQ=MyFile.mdb"

Priya wrote

Quote:
>odbc;Driver={Microsoft Access Driver (*.mdb)};
>should do the trick.



Sat, 11 Nov 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Connecting to an MDB file thru ODBC *without* using DSN

2. Unable to open ODBC file dsn using OpenEx method

3. Connecting Multiple Databases thru ODBC

4. Connecting to Database without a DSN

5. Problem to create an mdb file using ODBC

6. Problem to create an mdb file using ODBC

7. User DSN vs Sys DSN vs File DSN.

8. Can C# Apps Connect Using a DSN (DataSource)?

9. Using LONG fields thru ODBC API Calls

10. how to register new DSN in ODBC Adminstrator ( using C# )

11. DSN-Less ODBC using text drivers

12. Strange ODBC errors using DAO to access linked tables in Access .MDB

 

 
Powered by phpBB® Forum Software