Forums

This topic is locked

Connection String failure on remote server

Posted 28 Nov 2001 14:46:28
1
has voted
28 Nov 2001 14:46:28 Q Qwerty posted:
On my localhost my site runs perfectly. When I tried to upload it to my hosting provider I constantly get error messages when trying to open the homepage. Messages like driver not found etc. and when trying some tweaking 'End of statement'' expected. I've tried I lot of things, but nothing seems to work. I contacted my hosting provider, but there somewhat late with their reply. Ok, the problem seems to be the connection. My homepage contains the following start:

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Ads.asp" -->
<%
set rsProdukten = Server.CreateObject("ADODB.Recordset"
rsProdukten.ActiveConnection = MM_Ads_STRING
rsProdukten.Source = "SELECT * FROM Produkten WHERE Dutch = -1 ORDER BY EntryDate DESC"
rsProdukten.CursorType = 0
rsProdukten.CursorLocation = 2
rsProdukten.LockType = 3
rsProdukten.Open()
rsProdukten_numRows = 0
%>
<%
set Ads = Server.CreateObject("ADODB.Recordset"
Ads.ActiveConnection = MM_Ads_STRING
Ads.Source = "SELECT * FROM Admanager WHERE adID = 2"
Ads.CursorType = 0
Ads.CursorLocation = 2
Ads.LockType = 3
Ads.Open()
Ads_numRows = 0
%>
<%
set rsBunners = Server.CreateObject("ADODB.Recordset"
rsBunners.ActiveConnection = MM_Ads_STRING
rsBunners.Source = "SELECT * FROM AdmanagerSmall WHERE adID = 3"
rsBunners.CursorType = 0
rsBunners.CursorLocation = 2
rsBunners.LockType = 3
rsBunners.Open()
rsBunners_numRows = 0
%>

Three recordsets in there. I've tried a lot of different connection strings but they don't seem to work. Note that my hosting provider supports ASP, Access db, SQL and much more, so that's not the problem. I hope someone can help me out because this problem is killing me, it's really important. Thanks everyone for their reply.

Rein

Replies

Replied 28 Nov 2001 16:12:25
28 Nov 2001 16:12:25 Joel Martinez replied:
well, if you are trying to use a DSN, then the host would have to configure that on the server for you.

Have you tried using a DSN-less connection string?

Here's a good article on connection strings
www.basic-ultradev.com/articles/ADOConnections/

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Reply to this topic