dayat wrote:
SQLDB's ODBC very busy to finish the problem of me. otherwise there is a
way of is other, how to make and vanish DSN ODBC at windows
On the Control Panel (Win 9x/ME) or Control Panel -> Administrative Tools (Win
XP) there is a 'Data Sources (ODBC)' item. You can create new DSNs here:
- either a User DSN or System DSN, which you can refer to by
TODBCConnection.DatabaseName
- or a File DSN; you can refer to this one by the TODBCConnection.FileDSN
property
You can also manually set the parameters for your connection in a
TODBCConection object. See the property declarations in the source code for an
explanation which property maps to which connection property. In this case you
need to specify TODBCConnection.Driver; the driver names are also listed on the
Control Panel ODBC item.
Note that using TODBCConnection.Params, you can supply arbitrary ODBC
connection parameters, using lines of the form PROPNAME=value.
Example for connecting with MS Access:
Driver = 'Microsoft Access Driver (*.mdb)'
Params = ['DBQ=C:\path\to\my\database.mdb']
I guess Excel uses pretty much the same parameters. You need to look up the
Excel ODBC dirver documentation for details, also on how the spreadsheet is
interpreted as a database.
Reagards,
Bram
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
