connection string for ADO.NET using IP...

[adonet]

Can some expert help me write connection string for ADO.NET?
Our company use IP address (eg. 198.166.21.25) and windows authenticatin mode. I check the

http://www.connectionstring.com,

but did not work.

 

[RiverGuy]

Well, connection strings are different depending on different data sources. One connection string doesn't work for everything.

 

[adonet]

More detail:
IP: 198.166.21.25
database: myDB
table: myTBL
UserID: myLogin
Password: myPass
Mode: Windows Authentication

 

[RiverGuy]

You don't say what this is for. SQL Server? Access? DB2? Oracle? MySQL? etc., etc., etc.

 

[TNN]

Sorry to intrude but I have the same question. Documentation is poor in this regard. Maybe my question will help get answer.

Using ADO.net in Visual Studio Prof on my desktop. I have started the MSDE engine as my server. My question is, also, how do you write the connection string and where is the doc in this regard??? The following I obtained from book "Visual Basic.net Database Programming" but don't know how to apply for the MSDE server besides not understanding the syntax. Author is VERY presumptive(Was that a right word?):

strCn = "Server=MyServer;Initial" _
& "Catalog=Northwind;UID=adobook;pwd=xxxx"

TNN, Tom




TOM

http://WWW.TNPAYROLL@AOL.COM

 

[RiverGuy]

Drag a SqlConnection object to your form. Set the connection string property. It will allow you to build one.

 

[adonet]

For local SQL server, there is no problem. Now, I want to move to real SQL server. I do not know how to write connection string. Most sample are for mixed mode and used Server's name.

 

[RiverGuy]

That is why I said to drag a connection object onto your form and build it with the menus. Then you can cut and paste the string and delete the connection. You can modify the string for future use.