944,036 Members | Top Members by Rank

Web Development > ASP > Connecting to SQL server in Local machine
Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 6099
  • ASP RSS
Permalink
Aug 11th, 2006
0

Connecting to SQL server in Local machine

Expand Post »
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!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
alirezaaali is offline Offline
1 posts
since Aug 2006
Permalink
Aug 18th, 2006
0

Re: Connecting to SQL server in Local machine

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...
Reputation Points: 10
Solved Threads: 0
Newbie Poster
neo_returned is offline Offline
2 posts
since Aug 2006
Permalink
Oct 6th, 2006
0

Re: Connecting to SQL server in Local machine

Click to Expand / Collapse  Quote 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"
Reputation Points: 10
Solved Threads: 0
Newbie Poster
seibor is offline Offline
4 posts
since Sep 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: submitting varified data
Next Thread in ASP Forum Timeline: asp-crystal report printing to lineprinter





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC