Lazarus + MAC + MSSQL

[yusufc]

Hello to all Lazarus Forum members,
I am a Delphi programmer and I'm new in Lazarus.

I want to connect a MSSQL SERVER on Windows Server FROM MacBook Pro by using Lazarus.

My lazarus version is : 0.9.28.2
FPC versiyon is : 2.2.4
Zeos Access components are installed.

How can I connect to MSSQL database ?
Which component should I use ?

Thank you for your response, have a nice day.

[michaelthuma]

Afik this is pain under Linux or Apple. Wrong database imho. JDBC works. Microsoft does not ship a client for linux or apple - so what remains somehow is the Sysbase/MSSQL drivers for SQL Server 6.5 - but at least this works somehow.

http://www.versiontracker.com/dyn/moreinfo/macosx/23163
http://koansys.com/tech/setup-freetds-odbc-and-pyodbc-to-connect-to-ms-sql-on-freebsd

Try it via ODBC ... http://www.actualtech.com/products.php

And there are solutions if you integrate the SQLServer connection into Filemaker, however this works then.

Some clarification - ODBC is not a bad idea at all, it works under Linux too and is an open standard (beleive it or not). Some driver families allow the client to talk via TCP directly (no need to install a client software). This approach will come ... so feel free to go this way in case of client server.

I personally do it little different but maybe this is little to much, I use a middleware.

If you find something better please let us know.

[yusufc]

Thank you michaelthuma.
I tried Actual ODBC driver, yes it is working good, but Actual ODBC company wants 29.95 USD for EACH Computer.
I will write a small program for taking some records from SQL server and about 500 users will use this program in our company.
And I must pay USD 14.975 as totaly. This is unacceptable for me.
I think OPEN database connectivity is NOT OPEN

FreeTDS is very comlex for me because I'm new in Mac.

I must find a solution but how ? I'm searching internet since 2 weeks for a solution.

[michaelthuma]

Hallo!

It is an open standard but for sure not free;-). Beside this. I understand you pain. You have 500 Macs? Cool.

If you want to stay with Client Server then you will require at least an ODBC to ODBC bridge (here the client library resides on the serverside) - I only know such things under Linux (OpenAccess).

If you have Oracle DB you can pass connect the SQL Server to the Oracle DB ... (a fried of mine is doing it this way).

Away from this - beside plain socket communication there is maybe a simpler way via a webserver in plain XML (webservice or cgi) - if you just need a few records. --> I know it is not the same.


Mike

[ahmetnurideniz]

you can use firebird for your projecet. it is free, cross platform db. i use it more then 5 year for my Mrp program. Delphi + ibx + Firebird. I have no problem with Firebird.
you can download it from here. Zeos can work whith firebird.
http://www.firebirdsql.org/index.php?op=files&id=engine_213

[michaelthuma]

I think he does not have the choice:-).