Login To SQL Server Db

[arshadjehan]

HI
I am using CR 8 with vb6 and sql server 2000
I am designing my reports in RDC integrated into VB IDE. I set the Login info in the dialog box which appear to add database, e.g Server = (Local),User ID=sa etc, and this is being done at design time.

My question is that as my app is going to be multiuser, so will it cause any problem on clients machine?

Should I give the login information to RDC at run time and How?

Also can I use the same connection for RDC which is being used by app to connect with the DB on SQL Server?

Waiting for help...

[divined]

I have the same problem. I would like to enter the logon information to the database at runtime. As of now, I`ve no clue as to how to go about.

[arshadjehan]

Any one to Help...

[divined]

ok. I found a solution. Not exactly me but Robdog. I was just pointed to his code :

http://www.vbforums.com/showpost.php?p=1775989&postcount=2

[arshadjehan]

This is no way near to what i require.
Still waiting.......