Solved: GPConnNet & Dynamics.Globals : SQL Connection

(0) Share

Report

Posted on by chadbruels

1,582

Solution: I had entered the GPConnNet key incorrectly. It had a double quote in it which I did not realize was part of the key.

See screenshot: https://www.screencast.com/t/scFgA0xV

I am failing to create a connection using GPConnNet. I believe it is due to sending GPConnection.Connect() incomplete information on its DsnName parameter.

The example I am working from sends Dynamics.Globals.SqlDataSourceName.Value. I have printed this out to a file for verification and I find that value is RUBIN2014 which is my named SQL instance but without the <server> portion. The full name of the server is R90HGYQV\RUBIN2014. Would you concur with my assessment and how do I get the proper value to send to the Connect() method?

*This post is locked for comments