The parameters in a DSN or File DSN can always be combined with additional parameters in the connection string, for example to specify a password. Back in Delphi, that practice was legit. The project now compiles with no errors in both Windows and Linux, with some anticipated minor issues caused by lost properties which I must still translate. The LoginPrompt boolean property is not implemented yet. Please refer to the documentation of the specific driver to learn more about available parameters and their names. Board index All times are UTC.

Uploader: Mok
Date Added: 19 November 2010
File Size: 25.4 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 45448
Price: Free* [*Free Regsitration Required]

I choice my Database Baza. Compatible with all Interbase versions.

You don’t need Zeos. Unfortunately I don’t understand the GUID and interfaces parts very odbcxonnection, so I don’t know how the delphi independent conversion should be done now. I just couldn’t believe it was so easy Personal tools Create account Log in.

Who is online Users browsing this forum: The parameters for connecting to an ODBC data source are described in a connection string. You can use a hostname instead of. Fields [ 0 ].

I just stripped everything from it which is not blocking compilation. Additionally you may check this mysql odbc connection guide.

Lazarus (Pascal) How to connect to SQL Server using ODBC or TMSSQLConnection? – Stack Overflow

All other parameters are driver dependent. Free ; end ; except on E: I established odvcconnection appropriate connection string to connect to a local ACCESS database file and it even connected with no errors at all! By setting up a DSN the connection details can be verified to work within the manager dialog, and then the named DSN is all that is needed to use the connection later.


It would be just great to have ado odbcconnectipn in Zeos, because I don’t like the data-aware components included in Lazarus, which are, at least today, quite slow and buggy. Compatible with Firebird versions 3, 2. Works on all Lazarus versions.

Before going to the details of this wrapper, you must first have a basic understanding of how an ODBC data source is identified. Create nil ; query: Sometimes with an “Invalid Pointer Operation”.

ODBC connection

The use of Parameters is recommended to avoid SQL injection vulnerabilities. Sorry for the extension of the post, and thanks again for answering and, of course, your great work here. The odbcsqldyn unit, and hence odbcconnwill search for a file called libodbc. I can do the first but due the size it will take a whilebut I don’t know much about db components, so can’t try to build something equivalent for borland ADO db components.

Params TStrings set using. So, I decided to try to use this oledb unit under Lazarus, but I achieved partial success only and now I’m stuck. That comes real handy if I need to create on lazqrus fly new customer records, work orders, invoices, and so on when I am outside the office. EOF do begin S: The LoginPrompt boolean property is not implemented yet.


Zeoslib Portal

I mean, does this specify the native codepage selected in the DBM, set the one which will be used in the presentation layer, both, or none?

In this case the SQL statement isn’t built with values directly, but a named placeholder is used instead – and then the parameter is specified separately. I’ll update to SVN tomorrow and see if the latest patch concerning codepage issues helps and, of course, you’ll be the first to know if such thing comes to happen. Codepage issues are usually tricky, but in Lazarus they can become a painful nightmare, specially when coding a cross-platform app