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.
| Author |
Topic |
|
paulymac
Starting Member
3 Posts |
 Posted - 2004-12-08 : 12:25:47
|
| Hi,I have upgraded a database to SQL 2000 from SQL7. I have a VB 6.0 application developed by a 3rd party (i.e. no source code) that uses this database. The app uses ADODB for ODBC conncetivity.My problem is that when the app calls the following stored procedureexec dp_repCrestSearch N'01 Jan 2001', N'01 Jan 2003', '0307295', 'OAT02KOB1859%', -1 this works fine in the existing SQL7 database, however, nothing is returned when I run it SQL2000I turned on SQL Profiler and found that the following was occurring when the SP was executedexec dp_repCrestSearch N'01 Jan 2001All the other parameters have been dropped. I used a network analyser to see what was in the packet sent from the workstation to the Server and all the data was correct.I would appreciate it if anybody could provide some insight to this.Thanks in advance |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-08 : 12:31:57
|
| how did you do the upgrade..I've seen some bugs with the wizard...Brett8-) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-08 : 20:44:44
|
| have you double checked the sp concerned? can it still accept the other parameters?--------------------keeping it simple... |
|
|
|
paulymac
Starting Member
3 Posts |
Posted - 2004-12-09 : 04:28:25
|
| I didn't use the wizard I detached the database in SQL7 and then attached it in SQL2000 as recommended by Microsoft.Using Query Analyser I can run the stored procedure with all the parameters and get back the correct resultset. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-09 : 09:21:48
|
quote:
Originally posted by paulymac
I detached the database in SQL7 and then attached it in SQL2000 as recommended by Microsoft.
Got a link for that reccomendation?Does anything work?Did you get any kind of error?Brett8-) |
|
|
|
paulymac
Starting Member
3 Posts |
|
|
|
|
|
Upgrade to 2000 Issue -Stored Procedure not workin