Actually, unless your universe is running on unix, make sure your (DSN) login is DOMAIN\username. That often resolves that error.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Wednesday, September 22, 2004 1:18 PM To: [EMAIL PROTECTED] Subject: [U2] UvOdbc 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
