Creating a Connection String to Microsoft Dynamics GP SQL Server

Feb 24, 2014 at 2:22 PM
Hello Folks,
I am new to the SQL Server world came from Oracle world a few months ago.
With that said, I am having trouble building a connection string to our Microsoft Dynamics GP SQL Server Database. I see a 32 bit ODBC connection under the System DSN but not sure how to get this or the native SQLClient to work.
Can anyone give me a few pointers.
Thanks
Gary
Coordinator
Feb 24, 2014 at 8:37 PM
Hi,

Main thing is you will need to match your "connection" with the type of credentials you have to the DB. That will be specific to your environment, there is "trusted" (like windows integrated) and username/password type security. I find the following website pretty helpful:

http://www.connectionstrings.com/sql-server/

Also- there is the Quick Start guide

https://minisqlquery.codeplex.com/wikipage?title=Quickstart&referringTitle=Documentation