` Using Topspeed ODBC with ASP pages (Pratik Patel ) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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.


Today is November 21, 2024, 7:57 am
This article has been viewed 35208 times.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: