Re: Database migration strategies

From: Tetsuro Yokoyama 256-6224 <yokoyamt_at_cuug.ab.ca>
Date: Mon, 11 Apr 1994 17:01:27 GMT
Message-ID: <Co3tyF.M0B_at_cuug.ab.ca>


Hi.
I am currently developing a client (MS-Windows)/server <os/2> application. I am using DBLib 4.2.1 for my client and MS-SQLSERVER 4.2.b for my server.

My problem is using a remote stored procedure call <ie. dbrpcinit, dbrpcparam> with SQLCHAR parameters.

I have no problem with getting OUTPUT arguments and returned status from the stored procedure, but when the stored procedure tried to convert a SQLCHAR string into INT4 the SQLSERVER complained saying "can not convert CHAR '123' to INT4 ".

I contacted Microsoft and they said it's fully compatible.

What am I have to make this work? Do I have to use TRANSACT-SQL EXECUTE to do this?

Thanks in advance.   Received on Mon Apr 11 1994 - 19:01:27 CEST

Original text of this message