Open ODBC Connection

[richmiester]

Hi all... I'm looking for the code to open a passworded ODBC connection. I have a series of queries scripted and my problem is that when each query finishes the connection is closed then the password box pops up before the next one can run. Any ideas? The connection has its own alias.

 

[rmcmorris]

You can add the password to the connect string:

DSN=data_source_name[;attribute=value[;attribute=value]...]
DSN=PARADOX TABLES;DB=C:\ODBC\EMP;PW=ABC,DEF,GHI

Where PW is Password and DB is the directory to the tables.

Regan

 

[SercoSteve]

I use the following code to connect to an Open Link Generic 32 BIT ODBC Server without the password dialog box being displayed. I can then query that server without problems.

var
AliasInfo DynArray[] String
endVar

AliasInfo["SERVER NAME"] = ""
AliasInfo["USER NAME"] = ""
AliasInfo["OPEN MODE"] = "READ ONLY"
AliasInfo["PASSWORD"] = ""

if NOT addAlias("LIVE", "OpenLink Generic 32 Bit Driver", AliasInfo) then
return
endIf

setAliasPassword ("LIVE", " &quot

The <space> for the password seems to be important, if you just put &quot;&quot; the dialog box appears.

Hope that is of help

Steve