Thread: Problem using ODBC from .NET framework
Apologies for re-posting... I fat-fingered the odbc list address :-/ Hi all. I having an issue with the 8.01.01.02 ODBC driver that is installed via the 8.1.x Windows installer. Whenever there is an error on the connection (eg: trying to execute a sql statement that has a syntax error as an example) the System.Data.OdbcConnection object throws an exception - which is entirely expected. However, the error message returned is "The connection is dead". I have to go into the postgresql log files to try and locate the actual error. The same code used to work (meaning it returned the text of the postgresql error message in the exception) for me with 8.0.x so I'm kind of at a loss as to what has changed that would cause this behavior. Anyone have any ideas whats going on or how I can get back to the 8.0.x behavior? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
> Hi all. I having an issue with the 8.01.01.02 ODBC driver that is > installed via the 8.1.x Windows installer. ... > Anyone have any ideas whats going on or how I can get back to the 8.0.x > behavior? There is newer 08.01 psqlODBC version. Please try the 08.01.0200 version. We provide a lot of changes (including error reporting). Feel free to re-post the message if 08.01.0200 is still boken. I'll appreciate if you include mylog output (from 08.01.0200 driver). Regards, Luf
--- Ludek Finstrle <luf@pzkagis.cz> wrote: > > Hi all. I having an issue with the 8.01.01.02 ODBC driver that is > > installed via the 8.1.x Windows installer. > > ... > > > Anyone have any ideas whats going on or how I can get back to the > 8.0.x > > behavior? > > There is newer 08.01 psqlODBC version. Please try the 08.01.0200 > version. > We provide a lot of changes (including error reporting). > > Feel free to re-post the message if 08.01.0200 is still boken. I'll > appreciate if you include mylog output (from 08.01.0200 driver). > > Regards, > > Luf > Thanks. I'll try the new version out and let you know. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--- Ludek Finstrle <luf@pzkagis.cz> wrote: > Feel free to re-post the message if 08.01.0200 is still boken. I'll > appreciate if you include mylog output (from 08.01.0200 driver). > Using 08.01.0200, I'm still receiving the same error. However, I've managed to narrow the case when it happens down a bit. I only receive the "The connection is dead" error when an error occurs after I've explicitly defined a transaction via ADO.Net's OdbcConnection.BeginTransaction() function. I'd be happy to send you a small C# test case in if you wish. Regards, Shelby Cain __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
> > Feel free to re-post the message if 08.01.0200 is still boken. I'll > > appreciate if you include mylog output (from 08.01.0200 driver). > > Using 08.01.0200, I'm still receiving the same error. However, I've > managed to narrow the case when it happens down a bit. I only receive > the "The connection is dead" error when an error occurs after I've > explicitly defined a transaction via ADO.Net's > OdbcConnection.BeginTransaction() function. Interesting. I see no such call in ODBC. > I'd be happy to send you a small C# test case in if you wish. It would be the shortest way for me. Thanks, Luf
--- Ludek Finstrle <luf@pzkagis.cz> wrote: > > I'd be happy to send you a small C# test case in if you wish. > > It would be the shortest way for me. > Sent offlist. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com