>Hi All:
> I am having difficulty in establishing a connection to Sql Server from my VFP app using TCP/IP. I get an error that said connection failed to Sql Server. I am however, able to establish connection to the sql server through Named Pipe. I am wondering if there is a difference in the TCP/IP code as opposed to the Named Code needed to establish connection. i.e. I used sqlConnect = SqlConnect("DataWareHouse"). If I can connect to the sql server using TCP/IP, do I need to reconfigure the sql server.
>Thanks for your help!!
You can bring up the Server Network Utility (SNU) and configure SS to listen for TCPIP requests. I don't believe SS does this by default. The default is to listen for Named Pipe connections only.
You then need to configure the DSN to connect using TCPIP to the IP port configured in the SNU.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao