ODBC Error Locking Table

ODBC Error Locking Table

Post by Chris Foste » Sat, 09 Jan 1999 04:00:00

I was using a Microsoft Access ODBC connection to serve an on-line database.
I decided to upgrade it to SQL 6.5 and I ma having some trouble. Sometimes
people get the pages fine but other times people either get a blank web page
or the error listed below:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BatDB'.

header.asp, line 38

So it works, but it doesn't work. ggrrr. All I did to my ASP was change the
ODBC DSN souyrce to the source that pointed to the SQL server. The source
obviously works since sometimes you get the data... but something has got to
be wrong. Is the source being locked by 1 connection? so the 2nd connection
gets the error?

I'm really lost nhere. Its hard to troubleshoot when the problem only
occures once in a while.

Any help is greatly appreciated.


1. Drop table error - table locked

I am creating a temporary table, doing a crosstable query on the temp table,
assigning it to a data source which is bound to a flex grid.  When I unload
the form, I want to delete the temporary table; however, I get the error
that the table can't be locked because it is being used by another process.
I tried closing the recordset and resetting the data source to nothing but
still no go.  What am I missing?  The code is something like this:

sub form_load()
    db.execute ("Select * INTO tblTemp ....")
    set rs = db.openrecordset("Transform.....from tblTemp .....")
    set Data1.Recordset = rs    ' MSFlexgrid is bound to data1
end sub

sub form_unload()
' next three lines added to try to close the connection to tblTemp
    data1.recordsource = ""
    db.execute ("Drop table tblTemp")
end sub


2. DATETIME Format in Updategrams

3. Table is locked, workstation coughs, table stays locked.

4. Summary by Quarters?

5. ASP error with ODBC Access base and linked table with ODBC Mysql

6. Unable to process cube - help please...

7. Exclusive Table Lock in ODBC to SQL7?

8. Error with TStringList.LoadFromFile and nulls

9. ODBC lock's complete table

10. strange row locks on Access2000 table linked via ODBC

11. ODBC & Locking tables

12. ODBC locks complete table

13. ODBC - dBase table exclusively locked...(IE5?)