Connection to Firebird DB (ODBC)

hauzar
hauzar Member Posts: 4
edited 2011-11-20 in SQL General

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. :cry:

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.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Have you tried ADO?

    Waldo's post has a how to in here.

    The connection string can be found here.

    http://www.connectionstrings.com/firebird
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • hauzar
    hauzar Member Posts: 4
    Hello, I really thank you for your reply!

    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
  • hauzar
    hauzar Member Posts: 4
    Provider=Firebird Provider;

    :-)
  • markcomo
    markcomo Member Posts: 1
    you should try JDBC connection atleast one time.Your problem is occur when you are not write a connection string properly.
    Another solution is that, if SQL server cant support, you can connect with access also.
    Commodity tips
  • thu
    thu Member Posts: 6
    [Sorry, read too fast. This answer had already been given.]
  • briancolton1
    briancolton1 Member Posts: 1
    that's great to hear that answer from here finally !
    light relief | muscle warfare

Categories