Member Avatar for webDev04

i decided to switch over to ms access (thinking it would be easier) from mssql but i am having the same problem that i had with ms sql: "SQL Server does not exist or access denied"
i have put the ms access db into the web server from the web hosting company which i am using.
my db name is: evcsDb.mdb
its in the www/bin/ directory
this is what my code looks like:

dim pathDB as string = Server.MapPath("bin\evcsdb.mdb")
dim connString as string = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & pathDB & ";User id=Admin;"

Dim loginConn As OleDb.OleDbConnection
loginConn = New OleDb.OleDbConnection(connString)

loginConn.Open()
please help!

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by amitlokare
Member Avatar for amitlokare

Hi
Try this code and put database in same directory as tht of asp page

curDir = Server.MapPath("calender.mdb")
Set Conn=server.createobject("adodb.connection")
Conn.Open "DBQ="&curDir&";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;"

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.