Subject: DAO & SQL Server
Posted By: apoorv_gupta Post Date: 9/18/2003 5:59:53 AM
Set GetCurrentDatabase = Workspaces(0).OpenDatabase("", dbDriverNoPrompt, ro, lcstrConnectionString & ";DSN=FactoryPulse")

Even If I Close down the SQL Server, the above statement does not gives an error. I get Error when i try to execute the OpenRecordset method on this database.
It seems ODBC is going some kind of caching or something. Pls tell me how can i write code that returns error on OpenDatabase statement.



Go to topic 4245

Return to index page 1043
Return to index page 1042
Return to index page 1041
Return to index page 1040
Return to index page 1039
Return to index page 1038
Return to index page 1037
Return to index page 1036
Return to index page 1035
Return to index page 1034