Connecting to SQLServer 2012
Hi, I'm trying to connct to SQLServer data base but failed my basic script is something like this Conn= Sys.OleObject("ADODB.Connection") ; Conn.string = "MyString"; Conn....
Forum Discussion
nishnatha herath
You can use a alternative way but its machine and environment dependant.
You can create DSN (data source Name) by following below steps
1- Strart >> Control Panel >> Administrative Tool >> Data Source(ODBC) -Double click>> Add >> Select SQL Server >> Name - Enter Name >> Description - Enter Description >> Server - Enter Server IP address >> Next >> Select With SQL Server authentication using a login ID and Password >> Enter Login ID and Password >> Next
You can use a alternative way but its machine and environment dependant.
You can create DSN (data source Name) by following below steps
1- Strart >> Control Panel >> Administrative Tool >> Data Source(ODBC) -Double click>> Add >> Select SQL Server >> Name - Enter Name >> Description - Enter Description >> Server - Enter Server IP address >> Next >> Select With SQL Server authentication using a login ID and Password >> Enter Login ID and Password >> Next
