I have an ASP.NET app that connects to AS2005. I would like to use a
connection string with a User Id similar to the way I would connect to
SQLServer, but I haven't been able to make this work.

The only way the app currently works for me is if I use impersonation,
but I'd rather not do this right now.

I've seen examples for connection strings that look like:
DataSource=myASserver;Catalog=myDB;Provider=msolap .3;User
Id=myId;Password=myPW;

but I haven't got it to work. Is this possible?

TIA,
Jim

The User Id option only works if you are using a http connection.
Otherwise AS2005 always uses Windows authentication.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1150463415.880342.257390 (AT) h76g2000cwa (DOT) googlegroups.com>,
jhcorey (AT) yahoo (DOT) com says...

You should try the "Role=Role Name" property in the connection string. So
the connection is made with an "admin" like user, but he get the "Rolae
name" applyed to the conn.

-Radu


<jhcorey (AT) yahoo (DOT) com> wrote