VB6 application using SQL Server 2000 migrating db to SQL Server 2
Quote:
> We have an old VB6 application which uses a bunch of SQL Server 2000
> stored
> procedure calls...however we need to at least upgrade our database
> engine...so we are looking at SQL Server 2008 (Express for now thought
> full
> could be an option too).
> The problem we are seeing is that at least some (if not all) stored
> procedure calls from VB6 app to SQL Sever 2008 Express DB are not getting
> done/completed (SS2008 DB is just simply restored from SS2000, and nothing
> else is changed, also stored procedure complete/execute when run from
> SSMS -
> Management Studio tool).
> Please help :(alternative for now is to migrate the app from VB6 to Java -
> which calls and executes stored procedures ok)
There shouldn't be a problem. Post a sample of how you call the stored
procedures.