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.
| 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 |
 |
|
|
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! |
 |
|
|
|
|
|