newbie who hasn't much of a clue!

[weezie]

Hi I trying to rebrand an already built site, and work out what's happening with the code change bits of functionality on the way, trouble is I've never worked with ASP or databases before, I have already come to a stumbling block, I keep getting this error message I have changed the connection strings to the database.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/SiteFunctions.asp, line 800


Can anyone give me any guidence?

[peachy]

What is your connection string?

[weezie]

Hi,
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_yourad_STRING
MM_yourad_STRING = "dsn=DSNyouradAccess;"
%>

[peachy]

First does the database you are connecting to use a DSN connection?
What type of database are you connecting to?

I've not been working with ASP long but for the SQL database I'm using here is what the connection string is:

strConnection = "DSN=(DSN name);UID=(User ID);PWD=(password)"
set objConn = server.CreateObject("ADODB.Connection")
objConn.connectionstring = strConnection

also a DSN-less connection:

cst= "Provider=SQLOLEDB;Data Source=(IP Address);" & _
"Initial Catalog=(Name of database);Network=DBMSSOCN;" & _
"User Id=(user ID);Password=(password)"
set objConn=CreateObject("ADODB.Connection")
objConn.open cst

Good Luck!
:)