Geek asks and answers

Unable to create data source, "Column" TABLE_CAT "does not apply to table tables

I am trying to add a data source to a visual studio project, but it always gives me an error:

Column 'TABLE_CAT' does not belong to table Tables.

I get the same error in both vs2005 and vs2010. From what I read, this error is caused by ODBC drivers that are not compatible with ODBC 3.0, however according to Sybase, I have an odbc3.0 compatible driver. (I have version 10.10.00.28).

As a note, I can query the database in order. I just can't create a data source.

Here is the error image: this is my error

Thank you for your help.

EDIT:

Here are the steps I took:

  • 1) ODBC Advantage: ( , , , 64-)
  • 2) ODBC (ODBC)
  • 3) VS, () →
  • 4) " "
  • 5) "DataSet"
  • 6) ODBC DataSource, 'myODBC',
  • 7) "Test Connection" →
  • 8) "". .

32- , .Net " " VS. . , , #, .

+5

More articles:


All Articles