Connecting to SQL server in Local machine

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 397,802 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,445 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 3397 | Replies: 2

•

Join Date: Aug 2006

Posts: 1

Reputation: alirezaaali is an unknown quantity at this point

Rep Power: 0

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

Rep Power: 0

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

Rep Power: 0

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"