Re: Cannot open database
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 - Original Message - From: "Owen Leonard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 9:33 PM Subject: RE: Cannot open database > > 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 > __ 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 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
RE: Cannot open database
> 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 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
Re: Cannot open database
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 - Original Message - From: "Owen Leonard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 09, 2002 4:26 PM Subject: Re: Cannot open database > > 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 > > > > 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. > > __ 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 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
RE: Cannot open database
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 09, 2002 12:40 PM To: CF-Talk 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 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 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
Re: Cannot open database
> 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 > > 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. __ 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
Re: Cannot open database
Have you tried repairing it? (Tools / Database Utilities / Compact and Repair) Will - Original Message - From: <[EMAIL PROTECTED]> 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 > that?) > > Thanks, > > Owen > > > Athens County Library Services > __ 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 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