I am having trouble getting rid of ODBC connections, and they keep reappearing.
I opened my database, there were no ODBC connections showing.
I connected 1 source, an access db, then went to connect a table in the database, and get an error message that says I have too many connections. ERROR NUMBER OF SERVER DATABASE CONNECTIONS EXCEEDED I go to drop a connection and find I have 5 listed, and when I try to disconnect them using the menus I get an error message saying syntax is incorrect for the command sdisconnect.
How do I get rid of them
Mark,
Here's how:
CONNECT dbname
SDETACH ALL NOCHECK (that will detach all SATTACHed tables)
SDISC (that will prompt for all DSNs currently SCONNected)
Select each one at a time and delete them accordingly.
That should DISConnect all SCONNected Server Database(s) as well as Detach all SATTACHed table(s).
Have fun!
Very Best R:egards,
Razzak.
