I have migrated the IIS settings over to the new server and all appears to be going well when tested except that I have now lost all DB connectivity to the 3 small Access databases that I have in the server. All permissions and set ups are the same.
Based on past experience, I thought that it had to do with my Jet 4.0 drivers not being up to date, but a check of those against that on the service pack 8 indicates that my versions are the same as those in that Service pack...but to be sure, I downloaded the x64 version of the software and the install says that while the version is valid, it is not for the correct machine type ???? So I downloaded the x86 software, and that also did not work (of course). I then checked my Jet 4.0 drivers on my x86 machine...and they are OLDER than the ones on my x64 machine...I am totally confused and do not understand...
Here is the code that I use to call the databases:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\Star Thrower Website\forum.mdb"
ANY help to figure out why it works in on one server and not the other would be most helpful.....THANKS!
