stemitch2000
Programmer
This is a total long shot. I have got a access database with a website front. It has come to that time when the server that it is on is coming to it tithes, and the system is being migrated to a new server. The system worked "fine" on the old server, but it doesn't work all the time on the new server. Sometimes it does work and it does show the records I am searching for, othertimes it does not. (We think the after 90 seconds or so the varible re-initialiates itself hence it works)
After some initial investigation we think it is falling down when trying to open a connection to the database for the second time. We do get this error
error number -2147467259
error description Unspecified error
Has anyone seen this error and know how to fix it?
Also in the log, we get the following error (when the connection is run the second time).
/msadc/msadcs.dll/advanced datafactory.execute
Please does anyone have any ideas!!
After some initial investigation we think it is falling down when trying to open a connection to the database for the second time. We do get this error
error number -2147467259
error description Unspecified error
Has anyone seen this error and know how to fix it?
Also in the log, we get the following error (when the connection is run the second time).
/msadc/msadcs.dll/advanced datafactory.execute
Please does anyone have any ideas!!