Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ADO.Net

Author  Topic 

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-19 : 08:43:01
Apologies in advance if you can't ask ADO.net questions here, but if you can:
If you run a olecommand/data modifying piece of sql (e.g. INSERT), can you return more precise errors, rather than just "ODBC call failed"? (unlike the more explicit error you get thru the SQL's Query window.

Kristen
Test

22859 Posts

Posted - 2005-08-19 : 08:44:21
Is the "explicit error" available via the Errors collection in ADO?

That's where we get it from (but in .old, rather than .net !!)

Kristen
Go to Top of Page

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-19 : 11:25:40
Thanks, you are right (they're called OLEErrors/SQLErrors now), I was trying to get the errors back using OLEDB provider in ADO.net against SQL Tables, linked to Access mdb - too many layers!
Go to Top of Page
   

- Advertisement -