[RESOLVED] SQL Database Connection String

[FishGuy]

Hi,
I have the following connection string, I dont think I really need the workstation ID in there? What does it do? When I just take it out the connection string wont work anymore, how should it look without it?

Public ConnectionString = "workstation id=BANTAM;packet size=4096;integrated security=SSPI;data source=DEVSQ" & _
                    "LServer;persist security info=False;initial catalog=Database1"

[vb_dba]

My connection strings resemble the following

Public ConnectionString = "[b]Provider=SQLOLEDB.1[/b];integrated security=SSPI;[b]Server[/b]=DEVSQLServer;" & _
                    "persist security info=False;initial catalog=Database1"

I highlighted the things I'd change.

[FishGuy]

I think yours is for an OLEDB connection though Im wanting to use the vb.net SqlConnection Class

[FishGuy]

OK I found it in an old thread.

Public ConnectionString = "Data Source=DEVSQLServer;Initial Catalog=Database1;Integrated Security=SSPI"

It directed me to this great site-
http://www.connectionstrings.com/