hi,
my vbscript has a routine that opens a remote access database for querying records from a table.
One or two application(s) at other PCs do open the same remote database table for own purposes.
my routine looks like this code:
con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\remote server\...\myDB.mdb"
set objc = createObject("ADODB.Connection")
objc.open con
dbqry="select ..."
set rs = objc.execute(dbqry)
go through the records, then
objc.close
set rs = nothing
set objc = nothing
after like several hundreds (it varies) times of continuous open/close i get these:
at the "objc.open con" line , i get error:
Error Description: Unrecognized database format '\\remote server\...\myDB.mdb'
Error number: - 2147467259
Error Source: Microsoft JET Database Engine
at the execute line I get:
Error Description: Operation is not allowed when the object is closed.
my vbscript has a routine that opens a remote access database for querying records from a table.
One or two application(s) at other PCs do open the same remote database table for own purposes.
my routine looks like this code:
con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\remote server\...\myDB.mdb"
set objc = createObject("ADODB.Connection")
objc.open con
dbqry="select ..."
set rs = objc.execute(dbqry)
go through the records, then
objc.close
set rs = nothing
set objc = nothing
after like several hundreds (it varies) times of continuous open/close i get these:
at the "objc.open con" line , i get error:
Error Description: Unrecognized database format '\\remote server\...\myDB.mdb'
Error number: - 2147467259
Error Source: Microsoft JET Database Engine
at the execute line I get:
Error Description: Operation is not allowed when the object is closed.