Message
From
15/03/2010 15:07:18
To
15/03/2010 14:59:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01454635
Message ID:
01454639
Views:
41
>Hi
>
>Is there any way that I can error trap the SQL error code if my connection string fails? Obviously the connection ID will be -1, but if the SQL Server source itself doesn't exist (or the service is turned off), I get a generic ODBC error: can this ODBC error be trapped?
>
>Regards
What are you getting in aerror (all element items)? Anything useful?
>
>Is there any way that I can error trap the SQL error code if my connection string fails? Obviously the connection ID will be -1, but if the SQL Server source itself doesn't exist (or the service is turned off), I get a generic ODBC error: can this ODBC error be trapped?
>
>Regards
What are you getting in aerror (all element items)? Anything useful?