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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
ODBC error 3423
TED@DESCO
Member Posts: 2
I am running Navision Financials on a C/SIDE database with version 2.01 objects, 2.5 executables and v2.5 C/ODBC. I have an Access97 database that is ODBC linked to the Production Order Routing Line table in Navision as part of a time/labor gathering program. We have 5 locations throughout the country and I am trying to have all locations use this same program via Citrix metaframe. The problem I have run into is that each user who opens the Access database uses a license.
Instead of having 10 copies of this database running (each open copy takes a license), I decided to try creating an Access97 database as an intermediate step which would be linked to the production order routing line table in Navision and then ODBC linking this table to the Labor program in the existing Access97 database. I have no problem creating the C/ODBC link from Navision to the intermediate database that I want to share, but when I go to ODBC link this intermediate Access database to the existing Labor database I get Error 3423 which states:
"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. (Error 3423)You are attempting to link, import data from, or export data to either an external Microsoft Jet table or an external ISAM database table (for example, dBASE, FoxPro, Paradox, or Btrieve), but you've selected <SQL Database> as the data source. You must select the appropriate data source for the data you're attempting to link."
Does anyone have any ideas how to solve this problem or can you suggest another way to accomplish my goal of having multiple locations able to share an ODBC linked Access97 application while only using 1 license?
Thanks in advance for your help.
Ted Krueger
Instead of having 10 copies of this database running (each open copy takes a license), I decided to try creating an Access97 database as an intermediate step which would be linked to the production order routing line table in Navision and then ODBC linking this table to the Labor program in the existing Access97 database. I have no problem creating the C/ODBC link from Navision to the intermediate database that I want to share, but when I go to ODBC link this intermediate Access database to the existing Labor database I get Error 3423 which states:
"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. (Error 3423)You are attempting to link, import data from, or export data to either an external Microsoft Jet table or an external ISAM database table (for example, dBASE, FoxPro, Paradox, or Btrieve), but you've selected <SQL Database> as the data source. You must select the appropriate data source for the data you're attempting to link."
Does anyone have any ideas how to solve this problem or can you suggest another way to accomplish my goal of having multiple locations able to share an ODBC linked Access97 application while only using 1 license?
Thanks in advance for your help.
Ted Krueger
0