Newbie Question: MSSQL & TCP/IP

Hi, my question is, I need to access a MSSQL database with VB. But the database is remotely located in a web server.

Would it be as easy as to have connection string and an username/password? please some sample.

Thanks.

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Thanx, Optikal....

* "190.190.200.100" can be replaced with a server name, right?
* "1433" is a port ID, right?
* What exactly does the "Network Library" parameter?

And finally :rolleyes: .... I'm not experienced in MSSQL. Where in that connection string is included the database name? the server could have more than one.

Thanx again.

Catalog is the database name.