Data Source connection failing

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 a Data Source:

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.

Now, 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.

"rick" <rick@discussions.microsoft.com> wrote in message
news:9606B3AA-BE00-4597-A66E-DACAE1F2BBEB@microsoft.com...
> 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 a Data Source:
>
> 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.
>
> Now, 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.
>

Wrong newsgroup. You will have better success in VB.Net group.
You may want to provide code so they can see what you're doing in VB.

You can find a complete list of managed (dotNet) newsgroups here:
http://msdn.microsoft.com/subscripti...oups/list.aspx