connection string in (windows authentication mode) vb6

Question

i am using this connection string for server authentication ,

Dim rs As New ADODB.Recordset



strConnectionString = "Provider=SQLOLEDB.1;Persyst Security Info=False;User Id=fileade;Password=fileade;Initial Catalog=Fileade;Data Source=10.237.225.170;Command Properties='Command Time Out=45'"

what will be the connection string in windows authentication??

Persyst Security Info -- should that be Persist rather than Persyst? — onedaywhen
– onedaywhen, Commented Oct 4, 2010 at 18:25

Zephyr · Accepted Answer · 2010-10-04 12:57:48Z

1

Set Integrated Security=True

Here is the complete string:

Provider=SQLOLEDB.1;Integrated Security=True;Initial Catalog=Fileade;Data Source=10.237.225.170;Persyst Security Info=False;Command Properties='Command Time Out=45'"

answered Oct 4, 2010 at 12:57

Zephyr

7,8634 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris McCall · Accepted Answer · 2010-10-04 12:58:54Z

0

strConnectionString = "Provider=SQLOLEDB.1;Persyst Security Info=False;User Id=fileade;Password=fileade;Integrated Security=true;Initial Catalog=Fileade;Data Source=10.237.225.170;Command Properties='Command Time Out=45'"

answered Oct 4, 2010 at 12:58

Chris McCall

10.4k9 gold badges51 silver badges84 bronze badges

Comments

Ejaz Ahmed · Accepted Answer · 2015-11-13 11:57:33Z

0

I usually use Excel to create the connection string for me. Just try to connect to your server with the options you need, and the data connection property will have the connection string.

I think you would have to set Integrated Security to SSPI

Here is a string that worked for me that I modified for your situation:

strConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=Fileade;Data Source=10.237.225.170"

Hope that helps.

answered Nov 13, 2015 at 11:57

Ejaz Ahmed

7389 silver badges15 bronze badges

Collectives™ on Stack Overflow

connection string in (windows authentication mode) vb6

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related