Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Accessing Navision DB from Perl via ODBC
waverly
Member Posts: 4
Okay, here's my problem. I'm currently running a Navision 2.01b database on an NT 4.0 server and the 2.01b client on a W2k box. I have the Navision ODBC driver installed on the w2k box and I'm using the Perl ODBC module to access the Navision database. My problem with this, is that whenever I query the database (i.e. "SELECT * FROM Item"), I get nothing returned.
Just for kicks, I decided to try and open the NF DB through Access, and it worked fine. I could view all of the Navison tables through Access. Again, for kicks, I decided to setup the Access ODBC driver, and connected to the Access Database that I had just linked tables into from Navision, from Perl. When I queried that DB, it worked fine. Why is it, that I can query an access Database which is linked to the NF DB, but I can't query the NF DB directly? This has perplexed me for the past month and a half. Can anyone help?
Just for kicks, I decided to try and open the NF DB through Access, and it worked fine. I could view all of the Navison tables through Access. Again, for kicks, I decided to setup the Access ODBC driver, and connected to the Access Database that I had just linked tables into from Navision, from Perl. When I queried that DB, it worked fine. Why is it, that I can query an access Database which is linked to the NF DB, but I can't query the NF DB directly? This has perplexed me for the past month and a half. Can anyone help?
0
Comments
I need to select and update dBaseIV files from Navision, I am using an ocx to run SQL commands, but I need to sort out the DSN.
I am attempting to configure a datasource using a Microsoft ODBC driver. From ODBC dBase setup I select directory, no problem, I then select Indexes and I can see a list of the .mdx files, but there is nothing in the 'List Files of type' list and no indexes are listed in the 'Select Unique Record Identifier' window for the .mdx file.
It just doesn't seem to work under Windows 98, but on a p.c. running Windows NT it is showing the unique identifiers!
Any ideas anyone? It's driving me crazy!
As for all the other versions:
driver 3.50.3428.00, core comp. 3.510.3711.0 works on win 95
As for wnodows 98, nothing seems to work.
Fascinating eh?!
Does anybody know whats going on here, because this problem is coming between me and a nifty interface.