Unanswered: Trouble with Multiple Sybase Connections
i have a small problem.
I'm trying to connect to multiple sybase databases using "ADO" Vbcode.
But after the firest connection is opened i can't open another one eventhough i closed the connection in my code.
I think that i don't need to close the connection only to change the connection databse location. But i don't know how.
So please, I'm open to any suggestions.
If Connection.Connect_ODBC(Cnn, Datasource, Password, UserId) Then
If Connection.OpenRecordset(Rs, Query,Cn) Then
where i connected to then ODBC there opened a recordset, then i filled in the grid. Then after that i closed the connection.
So if i want to repeat this code another time in my program and open a new Connection to another Datasource, an error occurs since i can't open 2 sybase databases at the same time ( although i disconnected the connection ), the sybase connection window didn't close.
So please what is the way to close the connection completely.