Connect From ASP to SQL Server Through ODBC

Hi there,
I'm a new comer to this APS language and hope sombody out there can help me with this
I'm trying to find codes for me to connect from ASP to Sql Server using ODBC.
Can anyone help me
ThanxOriginally posted by michaelfg81
Hi there,

I'm a new comer to this APS language and hope sombody out there can help me with this
I'm trying to find codes for me to connect from ASP to Sql Server using ODBC.
Can anyone help me
Thanx

Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog=database; User ID=username; Password=password"

check this link :
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6442

regards,
Harshal.|||Dear Harshal,

Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog=database; User ID=username; Password=password"

with this script above, isn't it connecting ASP to SQL Server via OLE DB?
Is connecting via OLE DB and ODBC which i have to set in the Administrator Tool for it to work, the same?
Thanx