Weird Access Problem

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Weird Access Problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Weird Access Problem

Page: [1]

Bnugent

Posts: 257
From: Tampa Florida Tampa, FL USA
Status: offline

Weird Access Problem - 6/14/2001 22:02:00

Well I found out today (the hard way) why I need to upgrade to SQL. My site got hit pretty hard today with traffic and it appears access has been distrubted. All my pages that had dbase info now say:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

Any ideas why this happened or am I correct with my hunch. Also, I will try to restore this by using an old version of my site I backed up a day or so ago. Has anyone had this happen to them. If so, what did you do.

------------------
Brian---


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Weird Access Problem - 6/14/2001 22:13:00 Have you tried the OLEDB driver? Im thinking you may be using the old driver with an 2000 format database as well? (in reply to Bnugent)


Bnugent Posts: 257 From: Tampa Florida Tampa, FL USA Status: offline	RE: Weird Access Problem - 6/15/2001 20:36:00 Thanks spooky. Is the driver on the server. Where do I check this. Should I cal my host? ------------------ Brian--- (in reply to Bnugent)

Spooky

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: Weird Access Problem - 6/15/2001 17:23:00

Can you confirm trying to use a 2000 database? Has this changed at all?

By changing driver, I mean to start using an OLEDB connection if possible.

This is the difference:

OLEDB
sDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(DatabaseFolder)

ODBC
sDSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath(DatabaseFolder)

------------------
��k�
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

(in reply to Bnugent)