>Interstingly AERROR in VFP shoes 2 error rows, the second one (2,3) says:
>
>
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Createfile())
)
>
>I should mention that this server is working perfectly on its LAN and, as I said, works fine for me over the Net if I map I drive in the domain first.
I think I understand: the default protocol is
named pipes, which uses the Windows workstation's name. Since in plain TCP/IP this name does not exist, you can't connect, but once you've mapped a drive, that name becomes available.
Therefore, I see 2 solutions:
1) Use the Network Client Utility (in the SQLServer group of the Start Menu) and change the default protocol to TCP/IP;
2) Use an additional argument in the Connect String. I think it's "
NETWORK=DBMSSOCN", but I'm not sure the argument name is "NETWORK". I have the exact string back home, but since I'm at work right now...
Solution 1 would allow you to check if that's the problem right away!
HTH!
Sylvain Demers