Re: Connection String to Connect a VB 6 Application to SQL Server 2005

From: behmag@xxxxxxxxx
Date: 26 Sep 2006 20:44:40 -0700

Hi Bob,

thank you for answering me.

I checked the Protocols for MSSQLSERVER using the SQL server
configuration manager
and enabled the pipe names and tcp/ip option.

I did also enabled the IP1 option for the TCP/IP properties and I was
able to connect
using the following connection string

cs =
"Provider=SQLNCLI.1;Server=192.168.1.1;Database=MyDB;UID=sa;PWD=sapwd;"

Thank you for pointing me to the rigth way.

Behring

.

References:
- Connection String to Connect a VB 6 Application to SQL Server 2005
  - From: behmag
- Re: Connection String to Connect a VB 6 Application to SQL Server 2005
  - From: Bob Barrows [MVP]

Prev by Date: Re: Error message-No value given for 1 or more parameters
Next by Date: How to change connection string path at runtime
Previous by thread: Re: Connection String to Connect a VB 6 Application to SQL Server 2005
Next by thread: Query will not pull records in VBA
Index(es):
- Date
- Thread