Retrieving data out of SQL Server with a SQL User

[Stanley]

Hi,

i would like to retrieve data out of a table with a specific sql user in
code. If i do this than i would have to add the sql user hard coded in the
connection string. Is there another way to retrieve data without using the
sql user hard coded? Can i use the data connection perhaps to achieve this?

Thnx,

Stanley

 

[Franck Dauché]

Hi Stanley,

Maybe you could use the current user (Win, AD).
In managed code, the System.Environment class contains some user info.

If you an easy way to do this, you may want to have a look at this:
http://www.infopathdev.com/webstore/detail.aspx?itemid=18

Regards,

Franck Dauché

 

[Sheetal D [MSFT]]

You can use "Data Connection" Wizard to make a connection to the SQL DB. In this case you need not have the user name/password
hardcoded.

Go to Tools --> Data Connections --> Add......for adding a new database connection to the InfoPath form.

Best Regards,
Sheetal D

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: Retrieving data out of SQL Server with a SQL User
thread-index: AcXVjGZRMXiYI/RAQdOFuBDWzXbnXA==
X-WBNR-Posting-Host: 144.44.150.152
From: "=?Utf-8?B?U3RhbmxleQ==?=" <[email protected]>
Subject: Retrieving data out of SQL Server with a SQL User
Date: Thu, 20 Oct 2005 08:39:03 -0700
Lines: 10
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.infopath
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.infopath:18034
X-Tomcat-NG: microsoft.public.infopath

Hi,

i would like to retrieve data out of a table with a specific sql user in
code. If i do this than i would have to add the sql user hard coded in the
connection string. Is there another way to retrieve data without using the
sql user hard coded? Can i use the data connection perhaps to achieve this?

Thnx,

Stanley

 

[Stanley]

Franck,
Thnx for your response, but i don't want to use win authentication because i
don't want to add each user to the database each time to grant them access. I
also don't want to use a domain group because i can't create and add users to
the group myself. This needs to be done by our IS.
I have tried the data connection of infopath. But i don't know how to read
the return data out of the ADODataAdapater. I have created another post for
this already on which you have replied. thnx for that.

Regards,

Stanley

 

[Stanley]

Sheetal, thnx for your response, but i have tried this already and did manage
to run a query, but the problem is that i don't know how to read the reurn
values of the query. See my post with subject "How to use data from an
ADOAdapterObject".

regards,

Stanley