Forums

This topic is locked

Connection Errors with SQL Server

Posted 23 Oct 2003 21:28:49
1
has voted
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?

Reply to this topic