Still on the upgrade to aix 5.3 and 10.1.17 universe, we are using OPENLINK ODBC
If I do "smat -c" I get this:
Configuration data for license number 20009613:
User limit = 85
Expiry date= 1/1/2500
-GCI package is installed.
User limit = 85. Expiry date = 1/1/2500
-UCI package is installed.
User limit = 85. Expiry date = 1/1/2500
-UVCS package is installed.
User limit = 85. Expiry date = 1/1/2500
-UVADM package is installed.
User limit = 85. Expiry date = 1/1/2500
-UVODBC package is installed.
User limit = 85. Expiry date = 1/1/2500
-iPHANTOM package is installed.
User limit = 85. Expiry date = 1/1/2500
When I try to run it in AIX (its fine)
ODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0201
Enter ODBC connect string (? shows list): sql2
Driver: 05.20.1219 OpenLink Generic ODBC Driver (oplodbc.so)
SQL>use travellog
1: SQLExec = [OpenLink][ODBC][SQL Server]Server user 'tlogtest'
is not a valid u
ser in database 'Travellog'. (916) (916) SQLSTATE=HY000
SQL>Q
1: SQLExec = [OpenLink][ODBC][SQL Server]Could not find stored
procedure 'Q'. (2
812) (2812) SQLSTATE=HY000
SQL>quit
In Universe 10.1.14 it isn't
:CONNECT sql2
Enter username for connecting to 'sql2' DBMS [root]: tlogtest
Enter password for tlogtest:
SQLConnect error: Status = -1 SQLState = IM976 Natcode =
-1
[ODBC:-1] Data source name not found, or ODBC is not installed
on the system
:connect
Data Source information from /usr/ibm/uv/uvodbc.config:
Data Source: localuv
DBMS Type: UNIVERSE
Network Type: TCP/IP
Host System: loopback 127.0.0.1
Service Name: uvserver
Data Source: sql2
DBMS Type: ODBC
Data Source: webdb1
DBMS Type: ODBC
This was OK with 10.1.7
Er..................................
Bob Witney
IT Senior
EXPLORE!
Nelson House
55 Victoria Road
Farnborough
Hampshire
GU14 7PA, UK
Tel: 01252 379489
Mob: 07973 451156
www.explore.co.uk
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
