Newbie Question: MSSQL & TCP/IP

Alvein
12-18-2003, 05:09 PM
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.

Optikal
12-18-2003, 06:05 PM
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Alvein
12-18-2003, 07:11 PM
"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.

reboot
12-18-2003, 07:43 PM
Catalog is the database name.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum