Catastrophic Failure [Win 2003 And SqlServer 2005 64 Bits]

[rodgarcialima]

Hi folks,

We are testing our app with Windows Server 2003 64 bits and Sql Server 2005 64 bits and we got "Catastrophic Failure" error when we're trying to execute some procedures on my server through sockets connection. The procedure on our app server calls a Stored Procedure on Sql Server. This app has been working for many years on Windows and Sql Server 32 bits and we believe that the problem is dbexpress driver.

We need some help because our customers are making us crazy.

Cheers

Further Info:
-Delphi 7
-dbExpress driver for SQL Server 4.25.0.8
-MS SqlServer 2005 64 Bits
-MS Windows 2003 64 Bits

[Dimon]

We are investigating this problem. Please supply us the following information:
- do you run your application on same machine where SQL Server 2005 64 bits is running, or on Windows 32 bits;
- what provider do you use in the connection;
- does the error arise on connection establishment or on executing a query;
- does the error arise on executing a stored procedure or on executing other queries too.

[rodgarcialima]

We are investigating this problem. Please supply us the following information:
- do you run your application on same machine where SQL Server 2005 64 bits is running, or on Windows 32 bits;
- what provider do you use in the connection;
- does the error arise on connection establishment or on executing a query;
- does the error arise on executing a stored procedure or on executing other queries too.

- do you run your application on same machine where SQL Server 2005 64 bits is running, or on Windows 32 bits;
A: The server runs on same machine where SQL Server 2005 64 bits is running, but the client runs on Windows 32 bits. Only the server connects to database and executes a Stored procedures.

- what provider do you use in the connection;
A: TCRSQLConnection

- does the error arise on connection establishment or on executing a query;
A: None

- does the error arise on executing a stored procedure or on executing other queries too.
A: On executing a Stored procedure only.

[Dimon]

Please send me a complete sample at dmitryg*devart*com to demonstrate the problem, including script to create a stored procedure and tables.