Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
ODBC & Navision Financials
nicholas
Member Posts: 2
I am having a problem connecting to Navision Financials via ODBC. Using the C/ODBC driver I get this error:
ODBC error: [Navision Software a/s][Navision Financials ODBC Driver]ISAM Error
I receive this error when trying to connect to the live database on the server. In the configuration screen for the C/ODBC Driver if I click on the company button I get this error:
S0000 [Navision Software a/s][Navision Financials ODBC Driver]The TCP/IP connection's 'host' is not answering (TCP/IP error ECONNREFUSED).You can see how to make changes in your 'hosts' and 'services' filed in the documentation for the network. Contact your system manager if you need assistance.
I have a backup of the database on my laptop and don't have a problem connecting to this database.
I also find that using the SQL Server driver I can connect but when I do I cannot gain access to all tables. I get the following error on some tables-
ODBC error:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'CMCAustralia' in sysservers. Execute sp_addlinkedserver to add the server to sysservers
and some of the other tables don't have all of their fields listed. Such as the GL Account table which does not list fields such as date filter, balance at date, net change.
Any help with this would be greatly appreciated.
ODBC error: [Navision Software a/s][Navision Financials ODBC Driver]ISAM Error
I receive this error when trying to connect to the live database on the server. In the configuration screen for the C/ODBC Driver if I click on the company button I get this error:
S0000 [Navision Software a/s][Navision Financials ODBC Driver]The TCP/IP connection's 'host' is not answering (TCP/IP error ECONNREFUSED).You can see how to make changes in your 'hosts' and 'services' filed in the documentation for the network. Contact your system manager if you need assistance.
I have a backup of the database on my laptop and don't have a problem connecting to this database.
I also find that using the SQL Server driver I can connect but when I do I cannot gain access to all tables. I get the following error on some tables-
ODBC error:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'CMCAustralia' in sysservers. Execute sp_addlinkedserver to add the server to sysservers
and some of the other tables don't have all of their fields listed. Such as the GL Account table which does not list fields such as date filter, balance at date, net change.
Any help with this would be greatly appreciated.
0
Comments
>>Contact your system manager if you need
Have you set up the odbc driver to use the correct directory and net library ??
>>ODBC error:[Microsoft][ODBC SQL Server Driver][SQL Server]>>Could not find server 'CMCAustralia' in sysservers. Execute >>sp_addlinkedserver to add the server to sysservers
Have you just upgraded tp SP3 ? This happened on my machine when i was using the syntax [Server].[Database].[Owner].[object] in views and stored procedures. To get around it remove the [server]. option
HTH
Bruce
About missing fields: The FlowFields and FlowFilters in Navision are "virtual" fields in SQL database. This means that for Navision these fields exists, but for SQL not. There's a mechanism behind this technology, calling up the sumindex fields from other tables on SQL server through a couple of queries with xp's (extended procedures). Not easy to reproduce without fairly good programming knowledge, although it can be done (we did).
John