Forum > Networking and Web Programming
[Success] with Freespider reading data fromMS SQL via ODBC
tjpren:
All,
I've had great fun and success with Freespider, and have included source code for others, if interested.
Basically, I'm compiling a web page that propmpts the user for a basic search field, and using that search field to return a query from MS SQL 2005. The query result is displayed on a web page. I'm using ODBC for the connection (hence the SQLdb package has to be added to the IDE).
I think FreeSpider is an excellent module, and hope the developer continues with the work in developing it's useability.
I'm using Komposer to develop the HTML code for the page thast displays the data, using the FreeSpider developed Tags.
Interested in any other web projects that others have developed with FreeSpider.
Regards
motaz:
Glad to know that.
I've used FreeSpider for a web service application (Multi-tier as a middle tier), to perform actions in MySQL database. clients are applications that connect to FreeSpider application using HTTP component written in Delphi.
I've rewritten this module using Java Servlet because the team members were using Java. Servlet version performance was very bad and unreliable. I always get database connection error when jobs are too huge in the web service. I couldn't solve this problem (I'm new to Java), and that application was very critical and it was working in a telecom company in core network.
Finally I have returned back FreeSpider version of that application and it works fine in heavy load since then. It work for more than a year and a half, executing millions of requests.
tjpren:
Hi Motaz,
I'm pretty locked in to reading and displaying data from MS SQL. Our work platforms are all MS SQL, so as a result, I have to develop around this.
Till recently, I was working with VB.net, but have become recently converted to Open Pascal via Lazarus.
Modules are a little bit restricted in connection to proprietry systems (ie MS), but I've generally found workarounds - eg ODBC to connect. Have you any experience with MS databases?
Regards
BigChimp:
Tjpren,
Lacak2 has been developing an MSSQL connection component for SQLDB that uses FreeTDS to natively connect to MSSQL (it should also work for Sybase ASE).
You might be interesting in testing that.
See forum post
http://lazarus.freepascal.org/index.php/topic,15135.0.html
(if using Windows, IIRC Lacak2 has a compiled FreeTDS dll somewhere in that thread)
and bug report with latest code:
http://bugs.freepascal.org/view.php?id=17303
tjpren:
Thanks BigChimp,
I'll give it a go. I have to use Windows (7) as our company has standardised on that platform.
However, I'm just needing some clarification -
1. do I need to download and compile FreeTDS, or use the FreeTDS.dll
2. how do I actually use the RC2 files - I've added packages to the IDE lately. Do I paste the files into the SQLdb package directory, and re-add the SQLDIB package, or 3. do I put them directly into the project directory.
Regards
Navigation
[0] Message Index
[#] Next page