SQL Server Connectivity with Navision using Automation Objec

brijleo
brijleo Member Posts: 70
edited 2008-08-21 in NAV/Navision Classic Client
Hi,

I want to connect Navision with SQL Server using automation object.

I have a scenario where another application ABC is running with SQL server backend. I need to connect navision with ABC SQL database to extract data from particular tables within ABC database to navision database.
Hence, I want to connect this ABC SQL server using automation object.
Please suggest how should we do it.

It would be nice if somebody can provide a sample code for the same.

Thanks,

Comments

  • kriki
    kriki Member, Moderator Posts: 9,132
    Search for ADO. You will find some topics on that.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Waldo
    Waldo Member Posts: 3,412
    I know a cool guy who wrote a post about ADO.
    You can find it here and also on this forum here.
    8)

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • brijleo
    brijleo Member Posts: 70
    Hi,

    Please suggest what should be the connection string?

    We have SQL Server 2005 as a Navision backend database and another application also having SQL Server 2005 as database. What should be the exact connection string in navisin to connect to external SQL database?

    Thanks for your valuable inputs.

    Regards,
  • Waldo
    Waldo Member Posts: 3,412
    This URL should help you out ...
    http://www.connectionstrings.com/

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • garak
    garak Member Posts: 3,263
    sometimes it's the easiest way to "google" ;-)
    Do you make it right, it works too!

Categories