How to Connect to a SQL DB ?

<i><b>Originally posted by : Benny (dungu602@hotmail.com)</b></i><br />Hi, I want to ask how to connect to SQL Database in Win98 with ASP (standalone) ?<br />I want to connect the ASP page to a SQL Database and table which has the same name "Contact".<br /><br />I used the code below but it doesn't work<br /><br />dim strConnect<br />strConnect = "Driver={SQL Server}; Server=BigBoy; Database=Contact.Sql; UID=YourUID; PWD=YourPWD"<br /><br />Can I erase UID and PWD because I don't need them ?<br /><br />Thanks<br /><br />Benny

<i><b>Originally posted by : Jerry Scannell (JScannell1@home.com)</b></i><br /><br /><br /><br />------------<br />Benny at 8/9/2000 2:37:23 AM<br /><br />Hi, I want to ask how to connect to SQL Database in Win98 with ASP (standalone) ?<br />I want to connect the ASP page to a SQL Database and table which has the same name "Contact".<br /><br />I used the code below but it doesn't work<br /><br />dim strConnect<br />strConnect = "Driver={SQL Server}; Server=BigBoy; Database=Contact.Sql; UID=YourUID; PWD=YourPWD"<br /><br />Can I erase UID and PWD because I don't need them ?<br /><br />Thanks<br /><br />Benny<br /><br />Benny, try something like:<br /><br />First, create an ODBC DNS name called SQLDNSNAME that points to your SQL 7 driver.<br /><br />Substitute your DNS name, Databasename, user name and password.<br /><br />strProvider = "Provider=SQLDNSNAME;Data Source=(local);Database=DatabaseName;uid=idname;pw d=password;"<br /><br />Set cn = Server.CreateObject("ADODB.connection")<br /> cn.open strProvider<br /><br />yaddy-yaddy<br />Good Luck<br /><br />