Par2: Using Topspeed ODBC with ASP pages 1998-11-17 -- Pratik Patel I've been using TPS-ODBC & ASP on a few sites now.
Works great.
1. Install your TPS-ODBC on the machine which you have ASP
installed. ( I use MS-FrontPage / ASP on Win98 w/ MS-
Personal WebServer for development.)
2. Define your ODBC "System DSN source". If your apps store multiple
file(s) within a single tps file, must use "File"
example:
datasource=MySite.Demo
database=c:\fullpath\Sample.tps\!
3. In your ASP (I use the DatabaseWizard in FrontPage - then modify as
needed)
Use 'DSN=MySite.Demo' to let ASP "point" to the ODBC datasource.
Then I define my query as: "Select * from Products..."
where in the Clarion DCT you have the Products file defined as:
Sample.tps\!Products
4. Make sure you: "Allow scripts and programs to be run" set for the
folder that contains the ASP.
Printed April 29, 2024, 8:30 am This article has been viewed/printed 35111 times. |