Member Avatar for 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!

  • 3 Contributors
  • 2 Replies
  • 137 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by seibor
Member Avatar for 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...

Member Avatar for 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"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.