>>>>I want to access a foxpro database over tcp ip
>>>>How can help me.
>>>
>>>You will need to use ODBC. You will need to define the datasource in the ODBC Manager. If VFP you will open a database and create a connection using that data source. The rest will be the creation of remote views. This technique is similar to accessing Oracle tables using TCP/IP, ODBC, and SQL*Net. I have an article on this in the KB (red dice).
>>
>>Thanks for your reply,
>>
>>If i use ODBC. I use the function SQLCONNECT()
>>How can i connect over TCPI.
>>I am affraid i have no access to KB
>>Can you provide me a small example
>>
>>Kind regards,
>
>In the ODBC Administrator, you will need to define a VFP DataSource. The datasource will be the VFP DBC name or table(s). When you are defining the path to the VFP DBC or Tables, the server and path will need to be in your "network neighborhood" if you are browsing to select the location. If you know the entire server/path statement, you can type it in.
>
>Then in VFP you can use the View Designer (New, Remote View) to design your views. In the DBC you will have to create a new connection using the datasource you defined in the ODBC Administrator. This is the OOP way to do it (recommended -- less hassle, let VFP do it for you).
>
>If you want to use SQLConnect:
>
>lnHandle=sqlconnect(Parm1,"","",Parm4)
>
>I use the DataSource name I created in the ODBC Admin for both Parm1 and Parm4. The second and third parameters in SQLConnect are a UserId and password to the server you are connecting to. If left blank, and a UserID and password are required to authenticate to the server, a login screen will pop up automatically. I recommend leaving them blank to offer greater flexibility.
>
>use SQLExec(lnHandle,"Select fieldlist from remotetable where fieldN = something etc") to issue queries against the tables in the remote datasource.
>
>Finally,
>
>=SQLDisconnect(lnHandle)
>
>to disconnect from the dtasource.

Thanks for you reply

But when i am trying to access my computer over InterNet (from home). The computer is not available in the network neighborhood.
If i try on IP address \\193.66.248.75\database\mydatabase.dbf it does not work
We are using a NT Server as InterNet server.