To the group
I am having issues trying to use ODBC with our HP that we upgraded from 969 system to A520 system
This works fine at on our 969 but not when I try to use our new server , the error I get back makes no sense- its saying my connection string is incomplete for ODBC
I have been using .NET ODBC provider for the last 10 years with an issue until I tried on our A520
This is what my connection string looks like for .NET ODBC that works with 969
Driver={ODBCLink/SE-32 Driver ODBC3};UID=#mpeix/24.43.137.98:AMS2000,,an#David,MGR.HS61,PUB
I think it might have something to do with the version of ODBC on our system or our system itself
This is the complete error I get back , our ODBC manual is from 2005 but I don't think it's the right version for whats installed in version 7.0 of mpeix
Problem Processing Data:
ERROR [HY000] [ODBCLN33.DLL] Connection string incomplete but no DRIVER_COMPLETE parameter
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] [ODBCLN33.DLL] Connection string incomplete but no DRIVER_COMPLETE parameter
Driver={ODBCLink/SE-32 Driver ODBC3};UID=#mpeix/24.43.137.98:AMS2000,,an#David,MGR.HS61,PUB
Anyone else know what could be missing from ODBC driver ?
Here is the STDLIST from ODBC job
:JOB ODBCLNSE,MANAGER.SYS,ODBCSE.
Priority = DS; Inpri = 8; Time = UNLIMITED seconds.
Job number = #j11.
FRI, MAR 7, 2014, 1:49 PM.
HP3000 Release: C.75.00 User Version: C.75.00
MPE/iX HP31900 C.45.05 Copyright Hewlett-Packard 1987.
All rights reserved.
STREAMED BY MGR.HS61 (#S5) ON LDEV# 3
STREAM DATE: FRI, MAR 7, 2014, 1:49 PM
:comment ODBCLink (Special Edition) listener process
:setdump
:CONTINUE
:purge odbclog
:comment setvar odbc_debug 5
:odbclnse.ODBCSE server
dbmon.pub.sys (created FRI, SEP 10, 2027):
@(#)HPDBCORE A.G3.45 11/11/03 ALLBASE/SQL
[cid:image001.jpg@01CF3A22.5D0A2A00]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|