Hi folks

I've already posted this problem, but the description was not good enough.
So I try again.

In the datasources of the my computer I have created a odbc-datasource named
Test1.

The first test was in Access: So I made File-Import Data, then choosed
odbc-computer sources and selected my source named Test1. After this I was
able to select my table and everything works fine.

In Visual Studio I tried now with the wizard. So the way is the same like in
access, but when vs tries to load the tables following error is shown: "An
error occured while retrieving the information from the database: Column
'TABLE_CAT' does not belong to table Tables.

Whatever this mean, I don't know! I only know that this works in VB6 when I
use ADO with the same connection string, it works on access but It don't
work in Visual Studio .NET

Any Help?

Thanks alot

Nijazi Halimaji

On Tue, 6 Sep 2005 15:03:06 +0200, "Nijazi Halimaji" <(E-Mail Removed)> wrote:

¤ Hi folks
¤
¤ I've already posted this problem, but the description was not good enough.
¤ So I try again.
¤
¤ In the datasources of the my computer I have created a odbc-datasource named
¤ Test1.
¤
¤ The first test was in Access: So I made File-Import Data, then choosed
¤ odbc-computer sources and selected my source named Test1. After this I was
¤ able to select my table and everything works fine.
¤
¤ In Visual Studio I tried now with the wizard. So the way is the same like in
¤ access, but when vs tries to load the tables following error is shown: "An
¤ error occured while retrieving the information from the database: Column
¤ 'TABLE_CAT' does not belong to table Tables.
¤
¤ Whatever this mean, I don't know! I only know that this works in VB6 when I
¤ use ADO with the same connection string, it works on access but It don't
¤ work in Visual Studio .NET
¤

OK, assuming the connection string is OK why don't you try using the DataReader to see if you
encounter the same error.


Paul
~~~~
Microsoft MVP (Visual Basic)