DaniWeb Forum Index > Web Development > ASP

Connecting to SQL server in Local machine

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2006

Posts: 1

Reputation: alirezaaali is an unknown quantity at this point

Solved Threads: 0

alirezaaali alirezaaali is offline

Offline

Newbie Poster

Connecting to SQL server in Local machine

Aug 11th, 2006

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!

•

Join Date: Aug 2006

Posts: 2

Reputation: neo_returned is an unknown quantity at this point

Solved Threads: 0

neo_returned neo_returned is offline

Offline

Newbie Poster

Re: Connecting to SQL server in Local machine

Aug 18th, 2006

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...

•

Join Date: Sep 2006

Posts: 4

Reputation: seibor is an unknown quantity at this point

Solved Threads: 0

seibor

Offline

Newbie Poster

Re: Connecting to SQL server in Local machine

Oct 6th, 2006

•

Originally Posted by 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!

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