I have uploaded a survey to the server. Activeperl is installed and the DBD-ODBC and DBI packages have been installed. I created a regular odbc connection to the database using the ip and port and was able to connect successfully.
When I open the admin page I get the following error.
time= Tue Jul 15 10:43:17 2014 | SSIWebVersion= 8_3_2 | ErrorNum= 199 | msg= Failed to connect to the database. | Server Error: DBI connect('Driver={SQL Server};Server=1234.456.78.90;Database=dbname;uid=uname;pwd=password;port=12345','',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) [state was 01000 now 01S00]
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (SQL-01S00) at C:/inetpub/wwwroot/pexper/cgi-bin/authlib8_3_2.pl line 17.
| params= hid_studyname=>Pexper, hid_pagenum=>0, IP= ::1 , client= Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
Ive modified the error so real IP's and login info isnt displayed. The server where the database resides has a named instance where the survey database will be.
Sorry but this is the first survey Ive tried to configure so any tips would be helpful.
Thanks
Bill