Subject: | |
From: | |
Reply To: | |
Date: | Tue, 12 May 1998 12:24:34 PST8PDT |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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.
------
|
|
|