Connect via an IP address using sqloledb

Connection string

This Microsoft OLE DB Provider for SQL Server connection string can be used for connections to SQL Server 2000 and SQL Server 7.0.

Provider=sqloledb;Data Source=,1433;Network Library=DBMSSOCN;
Initial Catalog
User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server. Read more in the article How to define which network protocol to use.