ASP connection string to SQL Server 2005

HEELLLPPPPP

I need to change from sql server 2000 to sql server 2005

PROBLEM

i need a set of steps to connect to the sql 2005 in ASP web page
i have made an ODBC connection to the server, like for sql2000 but no good.

server name = damir

Urgent Please

Regards


GILE

 

I have given up on SQL Server 2005

BLOODY BILLY

MYSQL is the way to stick with


REGARDS

 

Set objDBConn = Server.CreateObject("ADODB.Connection")

objDBConn.ConnectionString="driver={SQL Server};" _
& "server=myserver;" _
& "uid=mywebuser;" _
& "pwd="verysecretindeed;"

objDBConn.Open
objDBConn.DefaultDatabase = "mydatabase"

 

<%
dim strSQL
set Global_DBConnection=Server.CreateObject("ADODB.Connection")
DSN="Driver={SQL Server};Server=[B]000.000.000.000[/B];Database=[B]DATABASENAME[/B];UID=[B]USERNAME[/B];PWD=[B]PASSWORD[/B]"
Global_DBConnection.Open(DSN)
%>

Code (markup):

change the words in BOLD with the ones you need