>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!