Cannot open database

All of a sudden we're getting this error when ColdFusion tries to access any of our Access 97 databases: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt. I'm still waiting for word from our sysadmin, but as far I know nothing has changed on the server (regarding the location or permissions of the database).   I've downloaded the database files and used Access to 'repair' them, re- uploaded them, and the problem remains.  I can even query the databases from CF Studio, but not through ColdFusion pages. Does anyone have any suggestions? (Yes I know--ditch Access.  Anything besides that?) Thanks,   Owen ---- Athens County Library Services ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb

Have you tried repairing it? (Tools  /  Database Utilities  /  Compact and Repair) Will Newsgroups: gradwell.lists.cftalk Sent: Saturday, February 09, 2002 8:44 PM Subject: Cannot open database > All of a sudden we're getting this error when ColdFusion tries to access any of > our Access 97 databases: > > ODBC Error Code = S1000 (General error) > > [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It > may not be a database that your application recognizes, or the file may be > corrupt. > > I'm still waiting for word from our sysadmin, but as far I know nothing has > changed on the server (regarding the location or permissions of the database). > I've downloaded the database files and used Access to 'repair' them, re- > uploaded them, and the problem remains.  I can even query the databases from CF > Studio, but not through ColdFusion pages. > > Does anyone have any suggestions? (Yes I know--ditch Access.  Anything besides ----- Excess quoted text cut - see Original Post for more ----- ______________________________________________________________________ Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona

> Have you tried repairing it? (Tools  /  Database Utilities  /  Compact and > Repair) Yes.  If the database file was corrupt, wouldn't I not be able to interact with it through ColdFusion Studio? -- Owen ----- Excess quoted text cut - see Original Post for more ----- be > > corrupt. ______________________________________________________________________ Why Share?   Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc

My suggestion is to remove the db, remove the datasource, replace the db file with a recently "repaired and Compacted' version and recreate the datasource. This has worked for us before. Tony Gruen All of a sudden we're getting this error when ColdFusion tries to access any of our Access 97 databases: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt. I'm still waiting for word from our sysadmin, but as far I know nothing has changed on the server (regarding the location or permissions of the database). I've downloaded the database files and used Access to 'repair' them, re- uploaded them, and the problem remains.  I can even query the databases from CF Studio, but not through ColdFusion pages. Does anyone have any suggestions? (Yes I know--ditch Access.  Anything besides that?) Thanks,   Owen ---- Athens County Library Services ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb

Owen, I've had that problem before where a corrupt record in the database caused the problem.  Chances are (not positive, but highly probable) that the newest entry in the database is the culprit.  Try, in access to delete or edit that entry.  Should fix things for you. Dave > > Have you tried repairing it? (Tools  /  Database Utilities  /  Compact and ----- Excess quoted text cut - see Original Post for more ----- access ----- Excess quoted text cut - see Original Post for more ----- may > be > > > corrupt. > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb

> Chances are (not positive, but highly probable) that the > newest entry in the database is the culprit.  Try, in access > to delete or > edit that entry. Dave, is the corruption visible in the data?  There's a lot of tables in the main database, so it would be a lot of stuff to sift through.  Also: Why would several different database files be inaccessible?  It's highly unlikely that they were all accessed around the same time.   -- Owen ______________________________________________________________________ Why Share?   Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc

Owen, You most likely won't be able to put an eyeball on the corrupt data. Usually non-visible characters are the culprit.  How many tables do you have in your Access database?  I believe that you said you're running Access 97. If that's so, Access 97 was not real well suited for the web.  It could be you've reached some limitations with the engine.  Do you have Access 2000 where you could do a conversion?  Access 2000 is many times more robust for web apps.  It handles simultaneous connections much better, can handle larger tables and more rows - it's just stouter.  Try a conversion if you can.  That might fix it.  Can you talk your mgt. to going to SQL Server? This might be a good time for you to plead your case . . . . Dave ----- Excess quoted text cut - see Original Post for more ----- ______________________________________________________________________ Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona

Well, it turned out all we needed was a reboot.  I wonder if low memory could have been the culprit? > Can you talk your mgt. to going to SQL Server? > This might be a good time for you to plead your case . . . . SQL Server is unlikely.  Conversion to MySQL is probably what will happen. But I guess Access got a reprieve for the dya.     -- Owen ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb

the option to configure in the admin wich forums are accessible by registration - (require registration ? yes/no) This would be a real enhancement ! thanks - will be available soon! I just wanted to get a feel for any additional features anyone might have been waiting for before I release this version. New features and enhancements include: 1) Multi-language support with on-the-fly switching 2) User Albums for images or other files with auto resizing, thumbnailing and file/user/site quotas 3) Ignore user function (doesn't display posts from people on your ignore list) 4) Archive thread function - stores a flat file version of a single thread but still uses current dynamic header/footer/stylesheet 5) CSS Stylesheets! 6) Who's Online (Maybe) 7) Thread Self-Destruct - Deletes after expiration date/time (maybe) I'm sure I'm forgetting something. I promise to get a site up when I release the beta. Any other feature requests? (not too complicated I hope) ;) Tony Schreiber, Senior Partner                  Man and Machine, Limited mailto:dune@technocraft.com                   http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com ______________DigitA Camera Scripts and Tips http://www.linklabexchange.com _____________Miata Link ECU Data Exchange > Why Share? >   Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER >   Instant Activation · $99/Month · Free Setup >   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ______________________________________________________________________ Dedicated Windows 2000 Server   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER   Instant Activation · $99/Month · Free Setup   http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona