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
- 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
Connection to Firebird DB (ODBC)
hauzar
Member Posts: 4
Hello,
I am new to this great forum and the MS Dynamics NAV product but I need to solve one problem. I've tried to find a solution in many forums but I didn't success.
I would like to make a solution for MS Dynamics version 5 or 2009. Generally I need the NAV to connect to a firebird database and obtain some data. A firebird server (and the database) runs without any problems. I have successfully installed the last official Firebird ODBC driver to MS Windows but I don't see that driver in the NAV, so I am not able to use it anyway (not showed in the "Automation Server List"). That's the problem.
But maybe there is another and more elegant solution how to connect to a firebird DB.
Thank you for your replies.
0
Comments
Waldo's post has a how to in here.
The connection string can be found here.
http://www.connectionstrings.com/firebird
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Actually yes. :-)
When I use ADO to connect to a MS SQL server, there is no problem. The connection string looks like this:
ADOConnection.ConnectionString('Provider=sqloledb;Data Source=192.168.1.4;'
+ 'Initial Catalog=CronusNAV5;USER ID=sysdba;Password=passphrase');
ADOConnection.Open;
I was surprised that there is necessary to specify the Provider parameter (not mentioned in connectionstring examples).
So similarly I can put the connection string for Firebird:
ADOConnection.ConnectionString('Provider=???;Data Source=127.0.0.1;'
+ 'Database=C:\database.fdb;User=sysdba;Password=masterkey');
ADOConnection.Open;
But the problem is that I don't know what I should to specify for the Provider parameter. Without this parameter I get an error message
"The call to member Open failed. Microsoft OLE DB Provider for ODBC Drivers returned the following message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."
My temporary solution is that I have specified the DSN Data Source Name (in the ODBC Data Sources Manager) named "FBlocalhost" and now I simply call this connectionstring:
ADOConnection.ConnectionString('FBlocalhost');
ADOConnection.Open;
and the connection is successfully established but this solution is not too elegant. :-/
I don't really know how to solve it.
Peter
:-)
Another solution is that, if SQL server cant support, you can connect with access also.