XMLBulkLoad Works with integrated security, fails with SQL Server security 
Author Message
 XMLBulkLoad Works with integrated security, fails with SQL Server security

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.

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



Mon, 21 Feb 2005 17:11:49 GMT
 XMLBulkLoad Works with integrated security, fails with SQL Server security


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.

Is your SQL Server running in mixed security mode or windows only mode?

--
Bryant



Wed, 23 Feb 2005 02:00:38 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to integrate Access application security with a SQL Server security

2. NT Integrated Security Without SQL Security Manager ?

3. How to connect to SQL Server through ADO (SOL Server uses Integrated Security)

4. Integrated Security & Security Manager

5. Integrated Security & Security Manager

6. Changing from Standard security to Integrated security

7. How to connect to SQL Server through ADO (SOL Server uses Integrated Security)

8. change from integrated security to nt only security

9. COM+ and SQL Server; COM+, SQL Server, and Integrated Security; Integrated Security [Solved :-)]

10. first connect always fails - Integrated security

11. SQL Server 7.0 Integrated security

12. ADO connection to SQL Server 7.0 using integrated security


 
Powered by phpBB® Forum Software