Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL2K Procedures causing probs.

Author  Topic 

asad12676
Starting Member

1 Post

Posted - 2002-03-08 : 05:51:18
Hello Friends!

i m facing a serious problem.
i developed an application on WinNT 4.0 SP6 with SQL 7 and VB6 SP4. When i migrated this Application to WinW2K with SP2, SQL2K and VB6 SP4, a strange problem occured.

ADO Command object is mapping the first arguement of the stored procedure (@RETURN_VALUE) which is Return Value, with the first input parameter of my Application. this parameter is of type varchar(16)
This error pops up in each and every stored procedure.

so, an error pops up which says "Error converting varchar to numeric". This problem doesn't occur the previous platform.

If anyone has any idea, as how to resolve this problem, do inform me.



Regards.

pothireddy77
Starting Member

3 Posts

Posted - 2002-03-18 : 23:03:27
In Start Menu click Run and type cliconfg and press enter .
You will get one window in that change protocol type to tcp/ip.



Go to Top of Page
   

- Advertisement -