Operating System - HP-UX
1753767 Members
5808 Online
108799 Solutions
New Discussion

ODBCLink/SE DSN-less connection to ALLBASE db

 
Hendrik Gerberding
New Member

ODBCLink/SE DSN-less connection to ALLBASE db

Introduced with version F.00 of the ODBCLink/SE driver DSN-less
connections are promised and should be implemented.

We have ODBCLINK/SE F.00 and ALLBASE/SQL v G3.28 installed but always
fail with error message:

[ODBCLN33.DLL] Connection string incomplete but no DRIVER_COMPLETE
parameter.

What does this mean ?

Our connection string is somewhat like:

DRIVER={ODBCLink/SE-32 Driver
ODBC3};UID=#hpux/:,,an#:;

Did anybody ever succeed using a DSN-less connection to HPUX
ALLBASE/SQL ???

There is a knowledge artice KBRC00007334 holding a DSN-less coonection example to MPEIX. Unfortunately we fail not translate it to ODBCLink/SE-HPUX.

Please help ... thanks,

Hendrik
1 REPLY 1
Hendrik Gerberding
New Member

Re: ODBCLink/SE DSN-less connection to ALLBASE db

HP-Support found THE solution.

The Connection String should be set to somewhat like:

strConnect = "Driver={ODBCLink/SE-32 Driver ODBC3};UID=#hpux/servername:databasepath,,an#login:password;Hostname=servername;"

The undocumented 'Hostname=servername' entry was missing.

Nobody would have expected this entry since the servername is already given (#hpux/...).

Thanks for help,

Hendrik