SQL 2000 STORED PROCEDURE WILL NOT RUN IN VB 6.0

Run-time error

Page 1 of 1

0 Replies - 1602 Views - Last Post: 06 May 2008 - 02:52 PM Rate Topic: -----

#1 pasnead  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 06-May 08

SQL 2000 STORED PROCEDURE WILL NOT RUN IN VB 6.0

Post icon  Posted 06 May 2008 - 02:52 PM

My company has recently reimaged my machine and I reinstalled VB 6.0 Pro. When I try to run some of the applications I have developed I get this runtime error: Run-time error '-2147467259 (80004005) Unspecified error.

I have set up the preferences and add-ins just like before and my application will run some SQL 2000 stored procedures it just won't run the ones with VARIABLES. The stored procedures that give this error when being executed in VB run perfect, either using the code or exec stored_procedure, in Query analyzer. Since the application runs some stored procedures and not others I think I must be missing something in the configuration of my machine. I have updated everything I can think of for example:

VBRUN SP 6
Jet 4.0 SP 8
2.0 dot net framework
MDAC 2.7

All this was as before. All of these applications did run before the reimaging. Any ideas?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1