SQL Server Connectivity with Navision using Automation Objec

brijleo

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,

kriki

Search for ADO. You will find some topics on that.

Waldo

I know a cool guy who wrote a post about ADO.
You can find it here and also on this forum here.
8)

brijleo

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

This URL should help you out ...
http://www.connectionstrings.com/

garak

sometimes it's the easiest way to "google" ;-)