Unanswered: VB 6 app connecting to SQL Server 2000
The application connects to SQL Server 2000 db, fetches data through 2 selects, and puts it in a text file.
The VB (.vbp) works alright for connecting to the sql server 2000 database, howver, once I make exe and try to run it, the exe doesnt do ANYTHING. not a single log, error message( captured in txt files) through error handling is written.
In the code, I am using rdoconnection. I did not need to add any references for the code (vbp) to work
Should I be adding any references so that the exe runs?