PDA

View Full Version : ASP connection conflict



ktaylor
07-26-2005, 12:46 AM
I have created a Membership Directory that is sorted alphabetically using ASP/VBS/Access (although the access was converted to mysql before loading to remote server). It runs perfectly on my local server, but I cannot run when loaded to remote server. Tech support for webhost sent me a "test.asp" w/working connection string, but putting it into the connection include file causes an "empty connection string" error in my asp doc. I don't know how to clear up the conflict.

Working connection code provided by webhost:

<%
connect_string = "Driver={Mysql}; server=localhost; uid=*****; pwd=*******; database=******"
set dbConn = server.createObject("ADODB.connection")
dbConn.open connect_string
mySQL="select * from Directory"
set rstemp=dbConn.execute(mySQL)
response.write name
%>

Section of code that is in conflict:

<%
Dim dirSort
Dim dirSort_numRows

Set dirSort = Server.CreateObject("ADODB.Recordset")
dirSort.ActiveConnection = MM_ccciatest_STRING
dirSort.Source = "SELECT * FROM Directory WHERE Company LIKE '" + Replace(dirSort__MMColParam, "'", "''") + "%' ORDER BY Company ASC"
dirSort.CursorType = 0
dirSort.CursorLocation = 2
dirSort.LockType = 1
dirSort.Open()

dirSort_numRows = 0
%>

error is found in:
dirSort.ActiveConnection = MM_ccciatest_STRING

Any idea how I can merge the working connection into this section of script?

Thanks!

ktaylor
07-26-2005, 03:14 PM
Solved