Re: Data Source connection failing

[Ralph]

"rick" <ri...@discussions.microsoft.com> wrote in message
news:9606B3AA-BE00-4597...@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/subscriptions/managednewsgroups/list.aspx

[rick]