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......

Login SQL Server using Integrated Security ! Problem

ok thi is my code for test

SqlConnection conn = new SqlConnection("server=majed13;Integrated Security=SSPI;");
conn.Open();
conn.Close();

connection isOK
the user logged in SQL Server isASPNET USER
i want looged in currentNT USER not ASPNET USER
thanx in advanceIt get the current user, you can use impersonation, and disable anonymous access to the Web. Is this on an Intranet? Do all users have rights to SQL Server? Is there a domain in place?|||Is this on an Intranet?Yes
Do all users have rights to SQL Server?Yes
Is there a domain in place?Yes

the problem in current user it's take the ASPNET not NT USER why ??
|||aspnet is the default iis user. Your best bet is to utilize ASP.NET's impersonation abilities in the web.config.

http://msdn.microsoft.com/library/en-us/vsent7/html/vxconImpersonation.asp?frame=true

that should explain a lot of it for you.

Either that, or utilize a DAL or stop using Integrated Security. :)|||the answer is

<identity impersonate="true" />

thank you

Login problem

Hi all,
I wrote an ISAPI (dll) application to work with a database on my SQL2K. When
I use windows NT integrated security (MyDomain\Username), The application
works properly. But when I use a specific username and password (using a sql
buildin login) I get this error message when adding a new record to the
database.
Internal Application Error
Application uses a value of the wrong type for the current operation
I granted the user to have full access to the database.
Any help would be appreciated.
Thank you,
MehrdadHi
Does the user have all appropriate permissions to insert data into table?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I wrote an ISAPI (dll) application to work with a database on my SQL2K.
When
> I use windows NT integrated security (MyDomain\Username), The application
> works properly. But when I use a specific username and password (using a
sql
> buildin login) I get this error message when adding a new record to the
> database.
> --
> Internal Application Error
> Application uses a value of the wrong type for the current operation
> --
> I granted the user to have full access to the database.
> Any help would be appreciated.
> Thank you,
> Mehrdad
>|||Yes, the user have all the permissions to Insert, Delete, Edit, and Create
the table.
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Hi
> Does the user have all appropriate permissions to insert data into table?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:%23CCQpjtyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> When
application[vbcol=seagreen]
> sql
>|||Hi
Perhaps you try to insert a value that has a different datatype (as error
said). Can you show us the INSERT statement?
"M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
> Yes, the user have all the permissions to Insert, Delete, Edit, and Create
> the table.
> Mehrdad
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O4Zq21tyEHA.3120@.TK2MSFTNGP12.phx.gbl...
table?[vbcol=seagreen]
SQL2K.[vbcol=seagreen]
> application
a[vbcol=seagreen]
the[vbcol=seagreen]
>|||Thank you Uru for your notice to my problem. I asked the administrator to
restart the SQL server. It works now properly.
Thank you,
Mehrdad
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OMn4KduyEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Hi
> Perhaps you try to insert a value that has a different datatype (as error
> said). Can you show us the INSERT statement?
>
>
>
> "M. Noroozi Eghbali" <galaxy@.irandoc.ac.ir> wrote in message
> news:uK$TWauyEHA.352@.TK2MSFTNGP14.phx.gbl...
Create[vbcol=seagreen]
> table?
> SQL2K.
(using[vbcol=seagreen]
> a
> the
>