We are a big user of ODBC connections to TurboImage and have
been using the ALLBASE DLL since day 0.
I am in the process of getting users switched to ODBCLINK/SE(16-bit)
method and have one major outstanding concern.

With the Allbase dll and from a PowerBuilder app(for example)
we could *override* what was in the odbc.ini files.
Therefore our user odbc.ini files could have LastUser statements
with dummy user and accounts like :

     LastUser=#mpeix/delphi:ifas.data.ifas,ws#xxxx/dummy.xxxx

and our connection information would then be embedded in the code such
as :
SQLCA.DBParm =
"Connectstring='DSN=CAP-REQ;UID=#mpeix/delphi:capdbe.pub.ccis,ws" &
   +  "#clientx/passxxxx.ccis'"

Unfortunately, the ODBCLINK/SE product *does not* work this way. It
ignores everything in the ConnectString(except the DSN) and takes all
the login information from the odbc.ini file.

My question is: Is there any way to ignore info in the odbc.ini file
and supply information at runtime.

I have tried the following to no avail as well:

SQLCA.DBParm ="Connectstring='DSN=CAP-REQ'"
SQLCA.Database = "capdbe.pub.ccis"
SQLCA.DBMS = "ODBC"
SQLCA.Lock = "RU"
SQLCA.ServerName = "delphi"

SQLCA.LogID = "clientx.ccis"
SQLCA.LogPASS = "passxxxx"
SQLCA.UserID = "clientx.ccis"
SQLCA.DBPASS = "passxxxx"

Hoping someone can shed some light on this problem.

TIA, Bob Walker.
--=--=--
Bob Walker, Computer Centre  --  [log in to unmask]
Capilano College, North Vancouver, BC, CANADA.
------