ODBC Error in logs

Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
We're getting an error showing up in the Event Viewer:

Event Type: Error
Event Source: COM+
Event Category: SVC
Event ID: 4194
Date: 6/6/2005
Time: 4:45:03 PM
User: N/A
Computer: [COMPUTER NAME]
Description:
The system has called a custom component and that component has failed and
generated an exception. This indicates a problem with the custom component.
Notify the developer of this component that a failure has occurred and
provide them with the information below.
Component Prog ID: 0[ODBC][Env 12d514e8]
Method Name: IDispenserDriver::CreateResource
Process Name: aexsvc.exe
The serious nature of this error has caused the process to terminate.
Exception: C0000005
Address: 0x12EAFFEF
Call Stack:
psqlodbc!SQLGetDiagFieldW + 0x29F

We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
"aexsvc.exe" is part of the Altiris suite of tools.


Thanks,

Del


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: ODBC Error in logs

Del,
this is the same error I have - see my previous post - with my ASPnet app. I
thought it could be a dotnet framework bug (odbc classes), but you're not
using .net are you?

Al.


-----Original Message-----
From: Del Stoliker [mailto:dstoliker@alphagraphics.com]=20
Sent: mercoled=EC 8 giugno 2005 16.41
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ODBC Error in logs

Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
We're getting an error showing up in the Event Viewer:

Event Type: Error
Event Source: COM+
Event Category: SVC
Event ID: 4194
Date: 6/6/2005
Time: 4:45:03 PM
User: N/A
Computer: [COMPUTER NAME]
Description:
The system has called a custom component and that component has failed and
generated an exception. This indicates a problem with the custom component.
Notify the developer of this component that a failure has occurred and
provide them with the information below.
Component Prog ID: 0[ODBC][Env 12d514e8]
Method Name: IDispenserDriver::CreateResource
Process Name: aexsvc.exe
The serious nature of this error has caused the process to terminate.
Exception: C0000005
Address: 0x12EAFFEF
Call Stack:
psqlodbc!SQLGetDiagFieldW + 0x29F

We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
"aexsvc.exe" is part of the Altiris suite of tools.


Thanks,

Del


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: ODBC Error in logs

> Del,
> this is the same error I have - see my previous post - with my ASPnet app.
> I
> thought it could be a dotnet framework bug (odbc classes), but you're not
> using .net are you?
>=20
> Al.

Hi Al,

Actually, yes, the Altiris tools make extensive use ASPNET. I googled
around a bit and noticed that there are people using the mysql odbc drivers
with .net apps having similar problems. So... maybe it is a .net bug -
which I have to admit I'm bummed about. I think the chances of getting this
fixed if it was a problem with the odbc driver are much better than getting
MS to fix something so it works with open source odbc drivers. :(

If you have any other insights on how to get this working I'd sure
appreciate it. I've had to pull this piece out of production since it keeps
crashing our server.

Thanks,

Del


>=20
> -----Original Message-----
> From: Del Stoliker [mailto:dstoliker@alphagraphics.com]
> Sent: mercoled=EC 8 giugno 2005 16.41
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Error in logs
>=20
> Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
> We're getting an error showing up in the Event Viewer:
>=20
> Event Type: Error
> Event Source: COM+
> Event Category: SVC
> Event ID: 4194
> Date: 6/6/2005
> Time: 4:45:03 PM
> User: N/A
> Computer: [COMPUTER NAME]
> Description:
> The system has called a custom component and that component has failed and
> generated an exception. This indicates a problem with the custom
> component.
> Notify the developer of this component that a failure has occurred and
> provide them with the information below.
> Component Prog ID: 0[ODBC][Env 12d514e8]
> Method Name: IDispenserDriver::CreateResource
> Process Name: aexsvc.exe
> The serious nature of this error has caused the process to terminate.
> Exception: C0000005
> Address: 0x12EAFFEF
> Call Stack:
> psqlodbc!SQLGetDiagFieldW + 0x29F
>=20
> We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
> "aexsvc.exe" is part of the Altiris suite of tools.
>=20
>=20
> Thanks,
>=20
> Del
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
> http://www.postgresql.org/docs/faq
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: ODBC Error in logs

Del,
I don't have precious info now: I can tell you I tried using two different
dotnet ODBC classes, the old Microsoft.Data.ODBC (which was to download as a
separate dll, because not part of framework 1.0) and System.Data.ODBC, then
added to framework 1.1. And the error occurs with both.

The strange thing is my app has been running for months on framework 1.0
without this kind of problems; when recompiled on 1.1 I started having these
problems, so that I'll try to go back to 1.0 as soon as I find a pc to test
this (don't want to install the old Visual Studio on my pc, where I'm using
VS 2003, because I'm sure it would break something!).
I'm not sure this could solve, but this should be quicker to test than
trying to modify psqlodbc.
=20
It would be interesting to understand if anybody gets such an error without
using aspnet or dotnet in general, so to exclude or confirm this is a dotnet
problem and not psqlodbc.
Can anybody help?

Bye,
Al.



-----Original Message-----
From: Del Stoliker [mailto:dstoliker@alphagraphics.com]=20
Sent: gioved=EC 9 giugno 2005 17.33
To: Alberto Velo
Cc: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] ODBC Error in logs

> Del,
> this is the same error I have - see my previous post - with my ASPnet app.
> I
> thought it could be a dotnet framework bug (odbc classes), but you're not
> using .net are you?
>=20
> Al.

Hi Al,

Actually, yes, the Altiris tools make extensive use ASPNET. I googled
around a bit and noticed that there are people using the mysql odbc drivers
with .net apps having similar problems. So... maybe it is a .net bug -
which I have to admit I'm bummed about. I think the chances of getting this
fixed if it was a problem with the odbc driver are much better than getting
MS to fix something so it works with open source odbc drivers. :(

If you have any other insights on how to get this working I'd sure
appreciate it. I've had to pull this piece out of production since it keeps
crashing our server.

Thanks,

Del


>=20
> -----Original Message-----
> From: Del Stoliker [mailto:dstoliker@alphagraphics.com]
> Sent: mercoled=EC 8 giugno 2005 16.41
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Error in logs
>=20
> Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
> We're getting an error showing up in the Event Viewer:
>=20
> Event Type: Error
> Event Source: COM+
> Event Category: SVC
> Event ID: 4194
> Date: 6/6/2005
> Time: 4:45:03 PM
> User: N/A
> Computer: [COMPUTER NAME]
> Description:
> The system has called a custom component and that component has failed and
> generated an exception. This indicates a problem with the custom
> component.
> Notify the developer of this component that a failure has occurred and
> provide them with the information below.
> Component Prog ID: 0[ODBC][Env 12d514e8]
> Method Name: IDispenserDriver::CreateResource
> Process Name: aexsvc.exe
> The serious nature of this error has caused the process to terminate.
> Exception: C0000005
> Address: 0x12EAFFEF
> Call Stack:
> psqlodbc!SQLGetDiagFieldW + 0x29F
>=20
> We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
> "aexsvc.exe" is part of the Altiris suite of tools.
>=20
>=20
> Thanks,
>=20
> Del
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
> http://www.postgresql.org/docs/faq
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: ODBC Error in logs

I have similar error message in my Event Viewer. I'm using NHibernate with
postgresql using Npgsql as the data provider. May I know have u found any
solutions for it? Is there a bug in Npgsql?

All help is appreciated! Thanks!

ycy



Alberto Velo wrote:
>=20
> Del,
> this is the same error I have - see my previous post - with my ASPnet app.
> I
> thought it could be a dotnet framework bug (odbc classes), but you're not
> using .net are you?
>=20
> Al.
>=20
>=20
> -----Original Message-----
> From: Del Stoliker [mailto:dstoliker@alphagraphics.com]=20
> Sent: mercoledì 8 giugno 2005 16.41
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Error in logs
>=20
> Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
> We're getting an error showing up in the Event Viewer:
>=20
> Event Type: Error
> Event Source: COM+
> Event Category: SVC
> Event ID: 4194
> Date: 6/6/2005
> Time: 4:45:03 PM
> User: N/A
> Computer: [COMPUTER NAME]
> Description:
> The system has called a custom component and that component has failed and
> generated an exception. This indicates a problem with the custom
> component.
> Notify the developer of this component that a failure has occurred and
> provide them with the information below.
> Component Prog ID: 0[ODBC][Env 12d514e8]
> Method Name: IDispenserDriver::CreateResource
> Process Name: aexsvc.exe
> The serious nature of this error has caused the process to terminate.
> Exception: C0000005
> Address: 0x12EAFFEF
> Call Stack:
> psqlodbc!SQLGetDiagFieldW + 0x29F
>=20
> We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
> "aexsvc.exe" is part of the Altiris suite of tools.
>=20
>=20
> Thanks,
>=20
> Del
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
> http://www.postgresql.org/docs/faq
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>=20
>=20

--=20
View this message in context: http://www.nabble.com/ODBC-Error-in-logs-tf58=
735.html#a7517295
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: ODBC Error in logs

Hi there,

I would like to know about using postgres with NHibernate through npgsql 1.0
as its data provider. Currently I'm developing an apllication in windows
which is using .net framework 2.0. but i've encountered an adhoc application
shut down problem while accessing the postgres. There's no exception caught
in my applcation log, but in postgres log, I found the following error
message:

LOG: XX000: could not receive data from client: No connection could be made
because the target machine actively refused it.

while in the Event Viewer i saw the following Error log:

The system has called a custom component and that component has failed and
generated an exception. This indicates a problem with the custom component.
Notify the developer of this component that a failure has occurred and
provide them with the information below.=20

Component Prog ID: 0[ODBC][Env d6312a0]
Method Name: IDispenserDriver::CreateResourceProcess=20
Name: testApplication.exe
The serious nature of this error has caused the process to
terminate.Exception: C0000005Address: 0x0D77ED4F
Call Stack: psqlodbcw!SQLGetDiagFieldW + 0x29F

Have you encounter any of these problem? Thanks in advance.

regards,
ycy


Alberto Velo wrote:
>=20
> Del,
> this is the same error I have - see my previous post - with my ASPnet app.
> I
> thought it could be a dotnet framework bug (odbc classes), but you're not
> using .net are you?
>=20
> Al.
>=20
>=20
> -----Original Message-----
> From: Del Stoliker [mailto:dstoliker@alphagraphics.com]=20
> Sent: mercoledì 8 giugno 2005 16.41
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Error in logs
>=20
> Hi, I recently installed psqlobbc-08_00_0101 on a Windows 2000 Server box.
> We're getting an error showing up in the Event Viewer:
>=20
> Event Type: Error
> Event Source: COM+
> Event Category: SVC
> Event ID: 4194
> Date: 6/6/2005
> Time: 4:45:03 PM
> User: N/A
> Computer: [COMPUTER NAME]
> Description:
> The system has called a custom component and that component has failed and
> generated an exception. This indicates a problem with the custom
> component.
> Notify the developer of this component that a failure has occurred and
> provide them with the information below.
> Component Prog ID: 0[ODBC][Env 12d514e8]
> Method Name: IDispenserDriver::CreateResource
> Process Name: aexsvc.exe
> The serious nature of this error has caused the process to terminate.
> Exception: C0000005
> Address: 0x12EAFFEF
> Call Stack:
> psqlodbc!SQLGetDiagFieldW + 0x29F
>=20
> We're running PostgreSQL 8.0.1 on a Fedora server. If it matters,
> "aexsvc.exe" is part of the Altiris suite of tools.
>=20
>=20
> Thanks,
>=20
> Del
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>=20
> http://www.postgresql.org/docs/faq
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>=20
>=20

--=20
View this message in context: http://www.nabble.com/ODBC-Error-in-logs-tf58=
735.html#a7517782
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match