Forums
This topic is locked
Connection Sql server
Posted 09 Nov 2002 00:00:24
1
has voted
09 Nov 2002 00:00:24 Carsten Hansen posted:
Hi,I am trying to move my site from lokal to my host (internet provider).
My problem is the connection to the sql server at my host.
all my ASP pages has a connection like this
news.ActiveConnection = MM_sql_STRING
is it possible to include "MM_sql_STRING" to this script provided by my host
<%
Set Conn = Server.CreateObject("ADODB.Connection"

Set Conn.Open = ("driver={SQL Server};server=192.1xx.xxx.xx;uid=xxx;pwd=xxxxxx;database=xxxx;"

%>
P.S The connection works if i write
news.ActiveConnection = Conn
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>