web application thru VFP 3

[PeriyurParthi]

hi all
iam new to this concept, i have a database in a specific ip address, i need to access it from 3 different places, lot of replies will be more helpful
thanks
parthi

 

[RedLion]

There are two ways to go, while using both to gether is the best way to go.

1.
Use remote views, what means:
- Make an ODBC connection (from the control panel ODBC) to your SQL server (you can use the IP-address from the SQL server).
- In VFP make a new Remote View, by using your ODBC connection made earlier.
- When you make a remote view, don't forget to set the primary key other wise you can't update your remote data!

2.
Use SQL pass-through technology, what means:
- Make an ODBC connection (from the control panel ODBC) to your SQL server (you can use the IP-address from the SQL server).
- Use the command SQLCONNECT()
- Use the commands:
SQLCANCEL( )
SQLCOLUMNS( )
SQLCOMMIT( )
SQLCONNECT( )
SQLDISCONNECT( ) SQLEXEC( )
SQLGETPROP( )
SQLMORERESULTS( )
SQLPREPARE( )
SQLROLLBACK( )
SQLSETPROP( )
SQLSTRINGCONNECT( )
SQLTABLES( )
- and end with the command SQLDISCONNECT()

Look for the VFP help and the tek-tips threads for background information.


Charl

 

[wgcs]

You still haven't explained what your grand scheme is: What do you need to do with data on the internet?

The answer to that question dictates what we will suggest you try...