I use the dbexpsda.dll version 2.50.4.0, that I use it till now with the Delphi 7.Now I migrate the same application from Delphi 7 to 2006 SP2 and I do not needed to change anything on this part in code.
Now I receive, sometimes, the error :
OLE DB error on code 80004005h
What I think, this is related to connection and command timeout, but till now with the same SQL server (2000 ent sp 4) I do not have that problem.
So, only because I compile the app (Win 32 based one - in fact a windows service) in 2006 to bring that incompatibility ?
Somebody can help me ? It is a known problem with old versions of dll's?
I have this one from 2 or 3 years.
Thank you !
dbexpsda.dll SQL Ole db error
see also the microsoft reported message
Event Type: Error
Event Source: ZorroServer.exe
Event Category: None
Event ID: 0
Date: 14-03-07
Time: 12:58:55
User: N/A
Computer: ZOW01AS002
Description:
The description for Event ID ( 0 ) in Source ( ZorroServer.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Access violation at address 0125D42F in module 'dbexpsda.dll'. Read of address 01F318D8.
Event Source: ZorroServer.exe
Event Category: None
Event ID: 0
Date: 14-03-07
Time: 12:58:55
User: N/A
Computer: ZOW01AS002
Description:
The description for Event ID ( 0 ) in Source ( ZorroServer.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Access violation at address 0125D42F in module 'dbexpsda.dll'. Read of address 01F318D8.
We couldn't reproduce the problem.
Please send us (evgeniym*crlab*com) a complete small test project to reproduce the problem; include definition of your own database objects; don't use third party components.
Also supply us the following information
- Exact version of DbxSda. You can see it in ReadMe.html
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.
Please send us (evgeniym*crlab*com) a complete small test project to reproduce the problem; include definition of your own database objects; don't use third party components.
Also supply us the following information
- Exact version of DbxSda. You can see it in ReadMe.html
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.
Please I need urgent help !!!!
Thank you for reaction.Please tell me :
1. I need to update the version of dbexpsda.dll version 2.50.4.0 to last one ?
2. If I download the last trial version, is fully functional? I can used in the deployment environment (to be sure if this is a solution and to buy after that)?
I run an win32 service as an multi threading application server.
The server is SQL server 2000 sp1...I will update this evening to sp4.
Please see below the error in debugging mode.It is happening occasionally...let's say 2 or 3 times per day....so is strange !
LAST error
Event Type: Error
Event Source: ZorroServer.exe
Event Category: None
Event ID: 0
Date: 15-03-07
Time: 11:46:06
User: N/A
Computer: ZOW01AS002
Description:
The description for Event ID ( 0 ) in Source ( ZorroServer.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [b]TOLEDBCommand.Destroy - interfaces not released (2) (D:\Projects\Delphi\Sdac\Source\OLEDBAccess.pas, line 2481).[/b]
1. I need to update the version of dbexpsda.dll version 2.50.4.0 to last one ?
2. If I download the last trial version, is fully functional? I can used in the deployment environment (to be sure if this is a solution and to buy after that)?
I run an win32 service as an multi threading application server.
The server is SQL server 2000 sp1...I will update this evening to sp4.
Please see below the error in debugging mode.It is happening occasionally...let's say 2 or 3 times per day....so is strange !
LAST error
Event Type: Error
Event Source: ZorroServer.exe
Event Category: None
Event ID: 0
Date: 15-03-07
Time: 11:46:06
User: N/A
Computer: ZOW01AS002
Description:
The description for Event ID ( 0 ) in Source ( ZorroServer.exe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [b]TOLEDBCommand.Destroy - interfaces not released (2) (D:\Projects\Delphi\Sdac\Source\OLEDBAccess.pas, line 2481).[/b]
You do not have to upgrade to DbxSda 3, just download the latest available for you DbxSda from our site.
DbxSda 3 Trial is fully functional and it would be good if you try to reproduce the problem using this version.
Most possible reason of this problem is that one instance of TSQLConnection, TSQLDataSet, or TSQLQuery component is used in different threads simultaneously.
DbxSda 3 Trial is fully functional and it would be good if you try to reproduce the problem using this version.
Most possible reason of this problem is that one instance of TSQLConnection, TSQLDataSet, or TSQLQuery component is used in different threads simultaneously.
thank you!
I will try to see if this can be the problem.