jud
asked on
VB6 User Control and Data Source!
Hi,
I have written a generic user control which validates a user login. It contains database references in the code, i.e. Dim db as database and rs as recordset which is the declarations for the lookup. It then uses search methods to find the user and verify the password.
The problem I am having is when I run it in a separate test project I get a data source dialog asking me for DSN information!
When I run a similar piece of code stand alone in another project it works fine.
Any ideas?
Regards one and all,
Jud.
I have written a generic user control which validates a user login. It contains database references in the code, i.e. Dim db as database and rs as recordset which is the declarations for the lookup. It then uses search methods to find the user and verify the password.
The problem I am having is when I run it in a separate test project I get a data source dialog asking me for DSN information!
When I run a similar piece of code stand alone in another project it works fine.
Any ideas?
Regards one and all,
Jud.
ASKER
yfang, thanks for the reply. the database isn't distributed, I meant stand alone project, not machine. So, when I run code on this database in a standard EXE it works fine, but as soon as I make it into a user control and use it from another project, it comes up with this message.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DSN means Distributed Server Network. It looks like your database is designed as a distributed database. This is why it works fine on a stand alone machine. Please check the design of your database and documentation about distributed database.
Good luck!