Forums
This topic is locked
Connection Errors with SQL Server
23 Oct 2003 21:28:49 Jay Thes posted:
I am trying to connect request and display records from a database but am having problems with the connection in Dreamweaver. I can connect to the database on my desktop, but when uploaded to the testing server, it does not work.The following is the connection:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_fellowship_STRING
MM_fellowship_STRING = "dsn=fellowship;uid=jcrab;pwd=janna;"
%>
The error I am getting refers to the line: internships.ActiveConnection = MM_fellowship_STRING and says:
Error Type:
ADODB.Recordset.1 (0x80004005)
SQLState: IM001 Native Error Code: 0 [DataDirect][ODBC lib] Driver does not support this function
/interns.asp, line 8
Any suggestions as to what the problem might be?