Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's my newbie questions o' the day:
I'm using ADO to connect to a SQL database. Here's my connection string: cn.Open "Driver={SQL Server};Server=MyIPAddress;Database=DatabaseName;U ID=MyID; PWD=MyPassword" There may be times when the database is not available. Currently it just gives an automation error. Is there a way I can use code to first test for the availability of the database? tod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Handling #NUM! error | Excel Worksheet Functions | |||
MS-Excel and Complex Database Handling? | Excel Discussion (Misc queries) | |||
Error Handling | Excel Programming | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming |