You should actually just be able to use the original string you have. Most
of the parameters have multiple valid names.
Also, if you plan to use the SqlClient provider, do not pass the provider
type, as that always uses the sql server provider.
Integrated Seuciryt = SSPI, means to use integrated security to connect to
the database as opposed to a username/password. That means it will try to
connect as the ASPNET user, if you are running this via asp.net. So if the
ASPNET account doesn't have rights to access the sql server, this will fail.
"Steven K" <sk****@troop.com> wrote in message
news:OY**************@TK2MSFTNGP09.phx.gbl...
Hello,
I am trying to convert my connection string from ASP to ASP .Net. This is
my understanding:
ASP
"Provider=SQLOLEDB;Server=MyServer;Database=MyData base;uid=MyUser;pwd=MyPswd "
ASP.Net
"Provider=SQLOLEDB;Data Source=MyServer;Initial
Catalog=MyDatabase;Integrated Security=SSPI;"
Is this the mapping?
ASP ASP.Net
-------- ---------------
Server Data Source
Database Initial Catalog
uid ?
pwd ?
Also, what is Integrated Security=SSPI?
--
Thanks in advance,
Steven