G
Guest
Using Visual Studio 2005, VB windows app, trying to add a data source. I
have system DSN's for two separate external databases, 1 MySQL and 1 Oracle.
I have linked to both of these databases via Access successfully for years,
however neither of them works in VB. Here are the errors that I receive when
attempting to connect the Data Sources:
MySQL:
an error occurred while retrieving the information from the database:
ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]Table
'<tablename>.dual' doesn't exist
Oracle:
Failed to call the ODBC driver connection utility.
For this Oracle connection, this error occurs after I have made the
connection and selected a table and hit the finish button. So, it connects
and sees the tables, why won't it finish the process?
I have tried using both the DSN and creating a connect string on the fly,
and both ways give me the same errors.
have system DSN's for two separate external databases, 1 MySQL and 1 Oracle.
I have linked to both of these databases via Access successfully for years,
however neither of them works in VB. Here are the errors that I receive when
attempting to connect the Data Sources:
MySQL:
an error occurred while retrieving the information from the database:
ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]Table
'<tablename>.dual' doesn't exist
Oracle:
Failed to call the ODBC driver connection utility.
For this Oracle connection, this error occurs after I have made the
connection and selected a table and hit the finish button. So, it connects
and sees the tables, why won't it finish the process?
I have tried using both the DSN and creating a connect string on the fly,
and both ways give me the same errors.