Visual Basic&database, Connecting to an Access 95 database via an ODBC driver in VB 5.0

Connecting to an Access 95 database via an ODBC driver in VB 5.0

Author	Message
Dean Clow #1 / 3	Connecting to an Access 95 database via an ODBC driver in VB 5.0 I am presently having difficulty connecting to an Access 95 database via an ODBC driver. I have two DSN created; one for a SQL Server database and one for an Access database. I have no problems connecting to the SQL Server database. It's the Access database that has got me in a snag. I figured the code would be similar....but I'm receiving the following run-time error. Error 3423 You can not use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. The connection code I am using is as follows: Set gdb = OpenDatabase("", False, False, "ODBC;DSN;CSAccess;UID=;PWD=;" If anyone knows what I need to do can you please let me know. Thanks, Craig
Fri, 21 Jul 2000 03:00:00 GMT

Craig Hamilto #2 / 3	Connecting to an Access 95 database via an ODBC driver in VB 5.0 I am presently having difficulty connecting to an Access 95 database via an ODBC driver. I have two DSN created; one for a SQL Server database and one for an Access database. I have no problems connecting to the SQL Server database. It's the Access database that has got me in a snag. I figured the code would be similar....but I'm receiving the following run-time error. Error 3423 You can not use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. The connection code I am using is as follows: Set gdb = OpenDatabase("", False, False, "ODBC;DSN;CSAccess;UID=;PWD=;" If anyone knows what I need to do can you please let me know. Thanks, Craig
Fri, 21 Jul 2000 03:00:00 GMT

Jimb #3 / 3	Connecting to an Access 95 database via an ODBC driver in VB 5.0 Quote: >I am presently having difficulty connecting to an Access 95 database via an >ODBC driver. I have two DSN created; one for a SQL Server database and one >for an Access database. >I have no problems connecting to the SQL Server database. It's the Access >database that has got me in a snag. I figured the code would be >similar....but I'm receiving the following run-time error. >Error 3423 >You can not use ODBC to import from, export to, or link an external >Microsoft Jet or ISAM database table to your database. >The connection code I am using is as follows: >Set gdb = OpenDatabase("", False, False, "ODBC;DSN;CSAccess;UID=;PWD=;" At First look should have an "=" after DSN, as DSN=CSAccess; not DSN;CSAccess; - Hide quoted text - - Show quoted text - Quote: >If anyone knows what I need to do can you please let me know. >Thanks, >Craig
Fri, 21 Jul 2000 03:00:00 GMT

Page 1 of 1

[ 3 post ]