A VERY WEIRD PROBLEM - SQL Server Forums

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.

All Forums

Development Tools

Other Development Tools

A VERY WEIRD PROBLEM

Author

Topic

jlara
Starting Member

4 Posts

Posted - 2006-09-05 : 18:13:28

So the thing is this...

I work with am application built with Visual Basic 6.0 and accesing an SQL Server 2000 DB. Permissions for doing several tasks, like reporting, creating letters, etc. are administrated by the DB.

The problem i'm having is that currently my application doesn't allow me or ANY but ONE user to report, or create letters. This user can only do it from his computer, if he logs in to the application with his user/password from a different computer, it doesn't work.

The DB holds the physical location of the reports and letters and the program reads that location in order to load them. I already checked all the files are in the right location, I already checked permissions, etc. If a file is missing, the error reads "FILE IS MISSING" (...DUH...) but if the file is in the right location I get to types of errors: "UNABLE TO LOAD REPORT / LETTER" and "CREATING DATA SOURCE FAILED"...

Anyone has ANY idea of what else I should check or verify, and/or what may be causing the problems..????

THANKS A LOT !!!

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-05 : 20:04:19

I would check that the DSN's (if used) are set up correctly. And check what version of ADO/DAO are installed (preferably the one that's referenced by the app if you can find that out)

Tim