DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Marathon and Interbase SQL scripts - cannot connect

When you use e.g. Marathon's 'Record Script' function to create a SQL script, then it will put something like the following in the first line of your script:

connect "C:\data\mydb.GDB" username "SYSDBA" password "masterkey";

When you get ready to execute your script, you'll be surprised by an error message that your database login is not defined and you'll get the recommendation to go to your db admin.

The reason is that Marathon (at least in some versions) simply generates faulty code.

The proper syntax is user, not username. Change the line in the beginning to:

connect "C:\data\mydb.GDB" user "SYSDBA" password "masterkey";

Generated 4:00:27 on Dec 14, 2019