Login To SQL Server Db

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...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.|||Any one to Help...|||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|||This is no way near to what i require.
Still waiting......