Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
C/ODBC Navision Connection with VB.NET
moh_barada
Member Posts: 46
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
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
Best Regards
Mohamad Barada
Independent ERP & CRM Consultant
+961 70 912700
Mohamad Barada
Independent ERP & CRM Consultant
+961 70 912700
0
Comments
Older versions of the Navision ODBC Driver were not fully ODBC Compliant. I don't know all of the intricacies of the different levels of ODBC Compliance...but from what I have gathered the older versions were barely ODBC 1.0 compliant and many advanced SQL functions did not work.
I have not done any testing with the newest ODBC Driver (NODBC) that comes with Navision 4.00, however the documentation indicates that it is much more functional then previous versions.
Hope this helps.
Jeff L.