Bryan Stevenson wrote: > > Bit of a mystery here....error message when tryingt o run a query against > Access: > Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Could not start session > > Things tried: > -reboot server > -compact & repair the database > > Neither fixes it.
I spent quite some time a while back trying to fix a rather vague access error for a client, and it turned out that, although I too tried a compact and repair, the database was in fact still corrupted (if I recall, this happened when the clients connection dropped part way through an FTP transfer, and in the process he managed to overwrite his good copy with the corrupted one, thus replacing the database didn't help). So, if the database isn't /too/ big, take a peek inside and see if anything jumps out (from memory, said database had several entries with something like #error# scattered throughout). Perhaps an easier way to diagnose that would be to copy the database structure, add a few dummy entries and see if that resolves the connection issue. If so, then data corruption is the most likely culprit. Alternatively, you could try removing and recreating the dsn in the CF Administrator. Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
