Very Computer

Thanks!

Paul

GambaDBServer = ConfigurationSettings.AppSettings("ServerName")

GambaDB = ConfigurationSettings.AppSettings("DatabaseName")

IntSecurity = ConfigurationSettings.AppSettings("IntegratedSecurity")

If IntSecurity = "Y" Then 'Check to see if we are using integrated security

GambaConnString = "provider=SQLOLEDB.1;data source=" & GambaDBServer

GambaConnString = GambaConnString & ";database=" & GambaDB &
";Trusted_Connection=yes"

Else ' If not usinfg integrated security set sql user and password
information

UserName = ConfigurationSettings.AppSettings("UserName")

Password = ConfigurationSettings.AppSettings("Password")

GambaConnString = "provider=SQLOLEDB.1;data source=" & GambaDBServer

GambaConnString = GambaConnString & ";database=" & GambaDB

GambaConnString = GambaConnString & ";uid =" & UserName & ";pwd=" & Password

End If

objBL.ConnectionString = GambaConnString

Quote:> I am running SQLXMLBulk load, but I do not always know wheteher the server
> will be using integrated security or just SQL Security.  I set up a
routine
> to allow for this, but I can not connect with the sql security connection
> string, only with the integrated security.  Has anyone else seen this?  I
am
> running SQLXML3 SP1, the connection string routines are below.

--
Bryant