I'm having a problem getting my odbc connection to UV working.
I know many of you have already overcome this problem so I'm looking for
some help in getting this going on my end.
Here is what we have:
UV 10.0.10
W2K (UV Server)
W2K (Client)
Wintegrate 4.2.1
Client side odbc driver = IBM Universe ODBC Driver 3.07.02.1130 File =
FASTPA32.DLL Date = 06/19/2002
100 user license for UVODBC
My ultimate goal is to query UV tables from Sql Server, but as a
"simple" test I thought I would try using Excel.
I used the existing user dsn for "UV/ODBC Sales Sample". I changed the
server connection information to reflect my system obviously.
Here is my problem:
I can ping my server without a problem, the moment I click the "Test"
button I get the following error:
UniVerse ODBC configuration test failed.
[IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE Facility: LINKERR
- TCP error
The odbc documentation, yes I actually read the documentation, states
the following for Error id 110:
TCP error.
Other error messages (including strange character sequences) typically
indicate that the port number in the Link Parameters field in the
configu-ration
file is incorrectly specified; you have connected to a service other
than
the rexec daemon (UNIX).
Use UniVerse ODBC Config to check the port number of the rexec or
autostart
daemon or service (typically 512).
Retry the connection. If this fails, reboot your PC and try again. If
this fails,
check to see if the host and its TCP/IP inetd, rexec, or autostart
daemon are
running.
Error ID: 110, Severity: SEVERE, Facility: LINKERR
My odbc config says 512, so I'm not really sure where the problem could
be.
I even turned on the trace in the odbc configuration editor, I see the
error, but I have no idea what it means. Here's the trace:
If someone could enlighten me I would greatly appreciate it.
thx,
rudy
e uvodbc_config 6c8-7f0 ENTER SQLAllocEnv
HENV * 0142FBFC
e uvodbc_config 6c8-7f0 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x0142FBFC ( 0x00911540)
e uvodbc_config 6c8-7f0 ENTER SQLAllocConnect
HENV 00911540
HDBC * 0142FBF8
e uvodbc_config 6c8-7f0 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC * 0x0142FBF8 ( 0x009115e8)
e uvodbc_config 6c8-7f0 ENTER SQLDriverConnectW
HDBC 009115E8
HWND 000604BC
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
e uvodbc_config 6c8-7f0 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 009115E8
HWND 000604BC
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110
Severity: SEVERE Facility: LINKERR - TCP error (10054)
e uvodbc_config 6c8-7f0 ENTER SQLErrorW
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04
WCHAR * 0x0142F7B8
SWORD 511
SWORD * 0x0142FC00
e uvodbc_config 6c8-7f0 EXIT SQLErrorW with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04 (10054)
WCHAR * 0x0142F7B8 [ 84]
"[IBM][UVODBC][0301892]Error ID: 110 Sever"
SWORD 511
SWORD * 0x0142FC00 (84)
e uvodbc_config 6c8-7f0 ENTER SQLFreeConnect
HDBC 009115E8
e uvodbc_config 6c8-7f0 EXIT SQLFreeConnect with return code 0
(SQL_SUCCESS)
HDBC 009115E8
e uvodbc_config 6c8-7f0 ENTER SQLFreeEnv
HENV 00911540
e uvodbc_config 6c8-7f0 EXIT SQLFreeEnv with return code 0
(SQL_SUCCESS)
HENV 00911540
ODBC Sales Samp 768-7b8 ENTER SQLAllocEnv
HENV * 0142FBFC
ODBC Sales Samp 768-7b8 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x0142FBFC ( 0x00911540)
ODBC Sales Samp 768-7b8 ENTER SQLAllocConnect
HENV 00911540
HDBC * 0142FBF8
ODBC Sales Samp 768-7b8 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC * 0x0142FBF8 ( 0x009115e8)
ODBC Sales Samp 768-7b8 ENTER SQLDriverConnectW
HDBC 009115E8
HWND 000D041C
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
ODBC Sales Samp 768-7b8 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 009115E8
HWND 000D041C
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110
Severity: SEVERE Facility: LINKERR - TCP error (10054)
ODBC Sales Samp 768-7b8 ENTER SQLErrorW
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04
WCHAR * 0x0142F7B8
SWORD 511
SWORD * 0x0142FC00
ODBC Sales Samp 768-7b8 EXIT SQLErrorW with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04 (10054)
WCHAR * 0x0142F7B8 [ 84]
"[IBM][UVODBC][0301892]Error ID: 110 Sever"
SWORD 511
SWORD * 0x0142FC00 (84)
ODBC Sales Samp 768-7b8 ENTER SQLFreeConnect
HDBC 009115E8
ODBC Sales Samp 768-7b8 EXIT SQLFreeConnect with return code 0
(SQL_SUCCESS)
HDBC 009115E8
ODBC Sales Samp 768-7b8 ENTER SQLFreeEnv
HENV 00911540
ODBC Sales Samp 768-7b8 EXIT SQLFreeEnv with return code 0
(SQL_SUCCESS)
HENV 00911540
ODBC Sales Samp 7ac-748 ENTER SQLAllocEnv
HENV * 0142FBFC
ODBC Sales Samp 7ac-748 EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x0142FBFC ( 0x00911540)
ODBC Sales Samp 7ac-748 ENTER SQLAllocConnect
HENV 00911540
HDBC * 0142FBF8
ODBC Sales Samp 7ac-748 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC * 0x0142FBF8 ( 0x009115e8)
ODBC Sales Samp 7ac-748 ENTER SQLDriverConnectW
HDBC 009115E8
HWND 00080536
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
ODBC Sales Samp 7ac-748 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 009115E8
HWND 00080536
WCHAR * 0x00237310 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x00237310
SWORD 8
SWORD * 0x00000000
UWORD 3
<SQL_DRIVER_COMPLETE_REQUIRED>
DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110
Severity: SEVERE Facility: LINKERR - TCP error (10054)
ODBC Sales Samp 7ac-748 ENTER SQLErrorW
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04
WCHAR * 0x0142F7B8
SWORD 511
SWORD * 0x0142FC00
ODBC Sales Samp 7ac-748 EXIT SQLErrorW with return code 0
(SQL_SUCCESS)
HENV 00911540
HDBC 009115E8
HSTMT 00000000
WCHAR * 0x0142FBB8 (NYI)
SDWORD * 0x0142FC04 (10054)
WCHAR * 0x0142F7B8 [ 84]
"[IBM][UVODBC][0301892]Error ID: 110 Sever"
SWORD 511
SWORD * 0x0142FC00 (84)
ODBC Sales Samp 7ac-748 ENTER SQLFreeConnect
HDBC 009115E8
ODBC Sales Samp 7ac-748 EXIT SQLFreeConnect with return code 0
(SQL_SUCCESS)
HDBC 009115E8
ODBC Sales Samp 7ac-748 ENTER SQLFreeEnv
HENV 00911540
ODBC Sales Samp 7ac-748 EXIT SQLFreeEnv with return code 0
(SQL_SUCCESS)
HENV 00911540
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
