Re: Step by Step with Oracle on HPUX

2009/2/4 Michael Warchut <[email protected]>
>
> So I have a fully functional FreeTDS and Unixodbc layer.  I am trying to get
> it all to work with DG4ODBC.  However I think I am missing a config setting
> somewhere but can't seem to figure it out..  Here is the error I am getting
> in the trace log.
>
>
>
> [ODBC][29414][1233726264.003674][SQLDriverConnectW.c][286]
>
>                Entry:
>
>                        Connection = 60000000002bc2a0
>
>                        Window Hdl = 0000000000000000
>
>                        Str In = [S=OMRS;I=aPDc2nx][length = 32]
>
>                        Str Out = 60000000002b9288
>
>                        Str Out Max = 1024
>
>                        Str Out Ptr = 9fffffffffffdb74
>
>                        Completion = 0
>
>                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
> 'UCS-2BE'
>
>
>
> [ODBC][29414][1233726264.028412][SQLDriverConnectW.c][777]
>
>                Exit:[SQL_ERROR]
>
> [ODBC][29414][1233726264.028520][SQLGetDiagRecW.c][491]
>
>                Entry:
>
>                        Connection = 60000000002bc2a0
>
>                        Rec Number = 1
>
>                        SQLState = 9fffffffffffd930
>
>                        Native = 9fffffffffffd924
>
>                        Message Text = 9fffffffffffd950
>
>                        Buffer Length = 510
>
>                        Text Len Ptr = 9fffffffffffd920
>
> [ODBC][29414][1233726264.028589][SQLGetDiagRecW.c][533]
>
>                Exit:[SQL_SUCCESS]
>
>                        SQLState = IM007
>
>                        Native = 9fffffffffffd924 -> 0
>
>                        Message Text = [[unixODBC][FreeTDS][SQL Server]Could
> not find UID parameter]
>
> [ODBC][29414][1233726264.028617][SQLGetDiagRecW.c][491]
>
>                Entry:
>
>                        Connection = 60000000002bc2a0
>
>                        Rec Number = 2
>
>                        SQLState = 9fffffffffffd930
>
>                        Native = 9fffffffffffd924
>
>                        Message Text = 9fffffffffffd950
>
>                        Buffer Length = 510
>
>                        Text Len Ptr = 9fffffffffffd920
>
> [ODBC][29414][1233726264.028642][SQLGetDiagRecW.c][533]
>
>                Exit:[SQL_NO_DATA]
>
>
>
>
>
> This makes me think I need to set a username in the odbc.ini file somehow
> right?
>

http://www.freetds.org/userguide/odbcconnattr.htm

freddy77