Connection fields

[cs3mw]

Hi I usually work on a standard ISS server and use the following connection string to connect to a mssql database:

<%
DIM objConn
dim mydb

Set objConn = Server.CreateObject("ADODB.Connection")

mydb = "PROVIDER=MSDASQL;DRIVER={SQL Server};" &_
"SERVER=SRV-OE;DATABASE=oldboysdatabase;UID=SEC\OEadmin;PWD=oeadminpa$$w0rd;"

objConn.open mydb



%>

Apoligies for the lack of code format the clients computer disables the pop ups!!!

This usually works however I am about to install this on a clients server and unfortunately my connection field is not working. Does anyone know how I would go about fnding the details that should be in the provider and the driver?

Kind regards

[yamaharuss]

Please explain "my connection field is not working"

You may also want to keep your passwords out of public view.

[cs3mw]

Im getting a HTTP 500 Internal Server error meaning that it is unable to make a connection. The website is to be hosted on a clients intranet and unfortunately no one has the necessary data connections and Im just wondering if anyone has any experience of how to obtain these details?

[yamaharuss]

There's no way we can help with vague comments like "not working" and "unable to make connection"

You need to configure either your server or browser (or both) to show you exactly what the 500 error is. That will not only tell you the error but the line of code causing the error.

It could be anything from a typo to a bad username to a bad servername

[chrismartz]

My guess is that your clients server doesn't know what server "SRV-OE" is. That seems like a DNS entry you would have internally on your network. Do you have an ip or is SRV-OE the name of the sql server instance?