Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2002-02

SQL Server

7 messages · 5 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Maximo

Hi, there!

Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit?

Tks in advance,

Paulo Maximo

_________________________________________________________ Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Michael Van Canneyt
to Maximo
Maximo wrote
Hi, there! Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit?

If someone can send the MS SQL C Header files, we can translate them and make a unit.

Michael.

Marco van de Voort
to Michael Van Canneyt
Show quoted text 8 lines
On Thu, 14 Feb 2002, Maximo wrote: > Hi, there! > > Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit? If someone can send the MS SQL C Header files, we can translate them and make a unit.

I've just downloaded the platform SDK, and it contains those afaik.

The platform SDK is downloadable from Microsoft, but requires IE5+ and a new MSI installer version. So I downloaded it at work :-)

(It is a 15 * 26 MB download, which expands to 800 MB, which will be 1 Gb due to clustersizes)

Fernando Lozano

Hi there,

Show quoted text 6 lines
> > Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit? > > If someone can send the MS SQL C Header files, we can translate them and > make a unit. I've just downloaded the platform SDK, and it contains those afaik.

Why not using the FreeTDS stuff so you can make a Unit that can be released under the GPL, be provided on binary format with binary distros, and work on Linux and FreeBSD also?

See www.freetds.org

[]s, Fernando Lozano

Marco van de Voort
to Fernando Lozano
Show quoted text 10 lines
> > > Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit? > > > > If someone can send the MS SQL C Header files, we can translate them and > > make a unit. > > I've just downloaded the platform SDK, and it contains those afaik. Why not using the FreeTDS stuff so you can make a Unit that can be released under the GPL, be provided on binary format with binary distros, and work on Linux and FreeBSD also? See www.freetds.org

Free databases can compete with the commercial ones in some applications, but not all. If the write to read ratio increases, performance of e.g. MySQL and PostGreSQL detiorates, at least without additional painful tuning.

Firebird (the interbase spinoff) appears to be in between.

Therefore I didn't question his choice of database, but only tried to be helpful to get MSSQL running, as I don't know the performance issues with his application.

Fernando Lozano
to Marco van de Voort

Hi Marco,

Show quoted text 9 lines
> > > > Is there a way to use FPC to connect/query to a MS SQL Server as MySQL unit? > > Why not using the FreeTDS stuff so you can make a Unit that can be released under the GPL, be provided on binary format with binary distros, and work on Linux and FreeBSD also? > > See www.freetds.org Free databases can compete with the commercial ones in some applications, but not all. If the write to read ratio increases, performance of e.g. MySQL and PostGreSQL detiorates, at least without additional painful tuning.

FreeTDS is *not* a database. It is a C *client API*, including ODBC and JDBC drivers, for Sybase Adaptative Server and Microsoft SQL Server. One that can be used on systems other than Win32. It is compatible with the C APIs from Sybase and Microsoft.

I used FreeTDS for some projects that need data on MS SQL Server 7 and 2000 from a Linux box.

IMHO it's better for Free Pascal to support FreeTDS than the Microsoft Plataform SDK, because you won't have license and compatibility issues. The programmer won't loose anything, except for the hidden bugs ;-)

[]s, Fernando Lozano