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>

Reply to this topic