SQL 2000 - how to connect?
We've recently upgraded from sql 7 to sql 2000. Now, my db_execute_query statements are returning a -1. I've tried resetting a data source to use. I've also tried my sql statement in Enterprise Manager and it works. Has anyone had this problem and can point me in the right direction to solve it?
Re: SQL 2000 - how to connect?
OK, I figured out what the problem is with the help of half the development team here. :-) The table I was querying had changed to have a 2000 length field which WinRunner breaks on when it tries to retrieve it. I changed my query to 'select cast(<myfieldname> as varchar(1020))As myfieldname1,substring(<myfieldname>,1021,979)as myfieldname2' which solved the problem.
Thanks for looking,