开发者

Is there a connection method for DB2 to use "TrustedConnection"

I am from a MSSQL Server background and tried to search to see if there w开发者_如何学Cas a way to perform a trusted connection in DB2 similar to how you do that in MSSQL? I basically do not want to have a user name and password in the connection string and have the "runas" user have that information.

Thank you for any help!

UPDATED .NET with the IBM.Data.DB2 provider


You didn't specify your platform/language, so here are a few ideas.

If you're using Java and Direct connect, the IBM documentation on this can be found here. If it can be done, this is the place to look.

OR for any language that can use ODBC (including .NET. VB6, VBSCRIPT, etc) you can set it up via ODBC, and have the username/password there.

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/r0021682.htm

And finally, in case these don't work because they don't apply to you, and you're using .NET, if the problem is that you don't want the username and password to be readable in the config file, you can always store part or all of the connection string in the registry to make it more difficult, as described here: http://support.microsoft.com/kb/891028

Hopefully one of these options will work for you.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜