End-Of-File in SQL server 2000

[ynnepztem]

Hello, I have been searching the forums for days now and can't find any help. I have a Visual Basic 6 front end with a SQL Server 2000 database. I loop through the records and show each one on the screen until I run out of records. When I run this in development on my PC it works fine. When I run the .EXE on my machine it runs fine. When I run it on another machine I get a "Run-Time 5 Invalid Procedure" error. I am totally stumped. Any help or suggestions would be greatly appriciated. Meanwhile I'll keep searching.

Penny

 

[sunaj]

Hi,

To run your VB programs on other computers you need to make sure that the new computer has all the dll etc. that the program uses. This can be done by creating a setup program and running it on the new computer.
Visual studio comes with a "Package and deployment wizard" that creates a setup program.

,Sunaj

 

[ynnepztem]

I did use the Package and Deployment setup and when the user tried to run it she got some kind of "Windows Registry" error message. I thought about the DLL's too and I downloaded all kind of stuff that I saw recomendations for and kept trying. While making the setup program I got a message saying that MSADO15.dll didn't have any dependency files. I tried making one and no matter what I did it didn't work.

 

[sunaj]

Hrmm, I would check out the "windows registry error" more closely, does it refeer to a missing dll?

Sunaj

 

[ynnepztem]

Thank you for your help. After MUCH searching and reading I stumbled across the problem. Since I new it was at the end of file where the problem was. I looked deeper into the code. I had a simple error message when the last record was read alerting the user that they were finished. I have used this same message many, many times while using ACCESS97 as my database. Now with SQL Server 2000, the message causes the Run-Time 5 error. When I commented the message out and recompiled, it ran like a dream on all PC's.

Thanks again.

Penny