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
- 298 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
ODBC connection with distant native database
Tomas
Member Posts: 420
Hi Experts,
Has anyone tried to setup ODBC for Native database, which is located on remote machine (to make it harder, without using Navision Application Server)?
Should you be selecting Local or Server?
If local, should you enter database with full location, for example: \\server\drive\folder\database.fdb?
Or should you use server? Than database field becomes grey, and you cannot browse for database.
What about client? Should we point to local client directory, or to remote servers directory through mapped drive?
Can it be done at all?
Every ideas are welcomed. Thanks.
Has anyone tried to setup ODBC for Native database, which is located on remote machine (to make it harder, without using Navision Application Server)?
Should you be selecting Local or Server?
If local, should you enter database with full location, for example: \\server\drive\folder\database.fdb?
Or should you use server? Than database field becomes grey, and you cannot browse for database.
What about client? Should we point to local client directory, or to remote servers directory through mapped drive?
Can it be done at all?
Every ideas are welcomed. Thanks.
Tomas,
Dynamics NAV Enthusiast
Dynamics NAV Enthusiast
0
Comments
http://www.BiloBeauty.com
http://www.autismspeaks.org
Yes, you are right.
Dynamics NAV Enthusiast
Apparently. If you use navision ODBC (for version 4 and above) you do not have to point to client folder anymore. And as for other details: if you are using server - you need to enter only server name (database field you can leave empty).
And if you are able to select company from a list by clicking on Company button, it means your nodbc is working fine (which was my initial problem).
Dynamics NAV Enthusiast