Simple ADO Connect to SQL 2012
I want to connect to a localhost SQLEXPRESS 2012 Database through the use of a script. I have spent far too long trying to accomplish what I would figure to be a simple task. I actually got the conne...
Forum Discussion
I connect to SQL a lot from script. Works fine.
Your connection string looks the same as mine, apart form the last parameter. I use the computer name. Which I pull from an environment variable at runtime. In C# Script:
var OWS = Sys["OleObject"]("WScript.Shell");
var CompName = OWS.ExpandEnvironmentStrings("%COMPUTERNAME%")
My final parameter in the connection string is
+ ";Data Source=" + CompName;
Mine have always been on the local machine thus far, but I believe you need the IP or hostname of the remote machine (and it needs to be configured to allow remote connections to the DB I think).
I agree with Colin - I connect to a remote DB and my connection string looks the same - but I use an ip address at the end of the string.
