March 25, 2009 at 3:42 am
Good Morning Everyone,
I am having a small issue with a networked database. I've never dabbled in ODBC connections before so Im running into a bit of a hiccup. I consider myself to be quite knowledgable but this is something thats causing me a little bit of a headache.
Basically the server PC is hosting the database in question and I am connecting 3 other PC's to it. 2 of the PC's in question work correctly and re-establish the connection to the ODBC even after rebooting.
The main PC however (the one that gets the most use out of the connection) disconnects from the ODBC everytime you reboot it and the program using the database then fires back an error. When you go into the ODBC information even without changing it, it reestablishes the connection and works fine until you reboot the PC next.
This isnt that big of a deal while I am here but when I am not, its a problem as the people using the PC's arent exactly literate.
If anyone knows any way to solve this it would be most appreciated.
Kind regards and thanks in advance,
Kris
March 25, 2009 at 3:53 am
totallyhopeless (3/25/2009)
Good Morning Everyone,I am having a small issue with a networked database. I've never dabbled in ODBC connections before so Im running into a bit of a hiccup. I consider myself to be quite knowledgable but this is something thats causing me a little bit of a headache.
Basically the server PC is hosting the database in question and I am connecting 3 other PC's to it. 2 of the PC's in question work correctly and re-establish the connection to the ODBC even after rebooting.
The main PC however (the one that gets the most use out of the connection) disconnects from the ODBC everytime you reboot it and the program using the database then fires back an error. When you go into the ODBC information even without changing it, it reestablishes the connection and works fine until you reboot the PC next.
This isnt that big of a deal while I am here but when I am not, its a problem as the people using the PC's arent exactly literate.
If anyone knows any way to solve this it would be most appreciated.
Kind regards and thanks in advance,
Kris
problem is ODBC drivers, possible re-install the ODBC drivers.
March 25, 2009 at 4:54 am
Reinstalled Drivers....
Tried Changing it to a system DNS....
No joy on either... constantly rebooting to test it isnt fun either, but thats the only time theres any problems.
March 25, 2009 at 5:20 am
Further investigation leads me to believe this is something to do with the network connection to the drive that has the database on.
When I open "My Computer" and access the mapped network drive manually first, there is no issue.
Is it possible that the network drive isnt connecting before the OBDC? The drive is set to reconnect at login and is connecting perfectly, but unless I access the drive manually to refresh the connection it will not let me use the program which requires the database.
Any ideas on how to resolve this?
March 25, 2009 at 5:55 am
Bodged it with a program that just opens my "Z:\" and closes it again at startup. Ideally I'd like a more concrete solution so if anyone has any ideas please feel free to share.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply