Dynamics User Group - Archived Forums

The forums in this section of DUG are no longer accepting new post, but you can still get lots of value from the old posts here.
Please visit the active forums to comment/post new questions (choose which product you are interested in):


C/ODBC Navision Connection with VB.NET

Hi All, i'm doing a new project on VB.NET linking to navision database.So i was creating a datasource linke to Navision ODBC,when i did <test Connection> it give me first <test of connection is ok>,than i press next so it's now trying to retrieve tables it give this message <An error occured while retrieving the information from the database: Column 'TABLE_CAT' doest not belong to table tables.>then i put cancel than i try again it put this message <An error occured while retrieving the information from the database:
ERROR[S0000][Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]ISAM Error
the driver doesn't support the version of ODBC Behavior that the application requested(see SLSetEnvAttr)>.please if anyone can help so urgent.thx alot
  • C/ODBC doesn't work with the standard system odbc tools in VB.NET what you have to do is reference the adodb tools from VB6 and it will let you connect.
Related