Linked table sometimes has all ODBC parameters

R

r m pyle

Sometimes a linked table's Connect parameters look like this:
DSN=Gblware32;AutoStop=yes

But other times they look like this:
DSN=Gblware32;UID=edit;PWD=xxxx;DatabaseName=gblware;DatabaseFile=C:\Gblware\db\gblware.db;START='C:\Gblware\sqlany\dbeng10.exe
-m';Integrated=NO;Description='Globalware32 dsn';Delphi=Yes

In the first instance, the connection parameters are read from the DSN when
the table is opened, and in the 2nd instance the stored (in MSysObjects)
parameters are read. What is it that one does when linking a table to get
one or the other set of parameters?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top