Connecting to SQL server in Local machine

[alirezaaali]

Dear All
how can i connect my ASP page to SQL server database in a local machin
i get this error
Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

TESTS FAILED!

[neo_returned]

i think your datasource address is wrong:

Set baglanti=Server.CreateObject("ADODB.Connection")
kitapeviDB.open "Provider=Microsoft.Jet.Oledb.4.0;
Data Source="&Server.mappath("databases\database.mdb")

this is for access is the address is wrong server can not find the database...

[seibor]

Dear All how can i connect my ASP page to SQL server database in a local machin i get this error Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. TESTS FAILED!

code for connection:
Set myconn=Server.CreateObject("ADODB.Connection")
myconn.open "Provider=Microsoft.Jet.Oledb.4.0;
Data Source=Servername;database=dbname"