|

»

»

»

unixODBC - Support

AdabasD with unixODBC

View: New views

4 Messages — Rating Filter: Alert me

	AdabasD with unixODBC by Ray Ramsaroop :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hello, I'm trying to configure AdabasD with unixODBC, PHP5 odbcinst.ini: ------------------------- [ODBC] TraceFile = /tmp/sql.log Trace = Yes [AdabasD] Description=AdabasD ODBC Driver Driver=/usr/lib/unixODBC/odbclib.so odbc.ini ---------------------------- [GMARKT] Driver=AdabasD Serverdb=GMARKT Servernode=192.168.1.2 SqlMode=ANSI IsolationLevel=Uncommited TraceFileName=gmarkt.pct testing with "isql -v GMARKT user pswrd" reslts [ISQL]ERROR: Could not SQLConnect /tmp/sql.log ------------------------------------ [ODBC][3523][__handles.c][447] Exit:[SQL_SUCCESS] Environment = 0x8051388 [ODBC][3523][SQLAllocHandle.c][359] Entry: Handle Type = 2 Input Handle = 0x8051388 [ODBC][3523][SQLAllocHandle.c][477] Exit:[SQL_SUCCESS] Output Handle = 0x8051918 [ODBC][3523][SQLConnect.c][3587] Entry: Connection = 0x8051918 Server Name = [GMARKT][length = 6 (SQL_NTS)] User Name = [intranet][length = 8 (SQL_NTS)] Authentication = [******][length = 6 (SQL_NTS)] UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' [ODBC][3523][SQLConnect.c][3955] Exit:[SQL_ERROR] [ODBC][3523][SQLError.c][424] Entry: Connection = 0x8051918 SQLState = 0xbf93068e Native = 0xbf930490 Message Text = 0xbf930499 Buffer Length = 500 Text Len Ptr = 0xbf930496 [ODBC][3523][SQLError.c][461] Exit:[SQL_NO_DATA] [ODBC][3523][SQLError.c][504] Entry: Environment = 0x8051388 SQLState = 0xbf93068e Native = 0xbf930490 Message Text = 0xbf930499 Buffer Length = 500 Text Len Ptr = 0xbf930496 [ODBC][3523][SQLError.c][541] Exit:[SQL_NO_DATA] [ODBC][3523][SQLFreeHandle.c][273] Entry: Handle Type = 2 Input Handle = 0x8051918 [ODBC][3523][SQLFreeHandle.c][324] Exit:[SQL_SUCCESS] [ODBC][3523][SQLFreeHandle.c][206] Entry: Handle Type = 1 Input Handle = 0x8051388 --------------------------------------------- The system is OpenSuse 10.3 hope someone can help Ray Ramsaroop _______________________________________________ unixODBC-support mailing list unixODBC-support@... http://mail.easysoft.com/mailman/listinfo/unixodbc-support
	Re: AdabasD with unixODBC by Nick Gorham :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Ray Ramsaroop wrote: > Hello, > > I'm trying to configure AdabasD with unixODBC, PHP5 > > odbcinst.ini: > ------------------------- > [ODBC] > TraceFile = /tmp/sql.log > Trace = Yes > > [AdabasD] > Description=AdabasD ODBC Driver > Driver=/usr/lib/unixODBC/odbclib.so > > odbc.ini > ---------------------------- > [GMARKT] > Driver=AdabasD > Serverdb=GMARKT > Servernode=192.168.1.2 > SqlMode=ANSI > IsolationLevel=Uncommited > TraceFileName=gmarkt.pct > > testing with "isql -v GMARKT user pswrd" reslts [ISQL]ERROR: Could not > SQLConnect Ok, first thing I would try is using strace to see where it got to, and if it loaded the lib. First check the lib can be loaded. dltest /usr/lib/unixODBC/odbclib.so SQLConnect Then I would try is using strace to see where it got to. strace isql -v dsn 2> sl -- Nick Gorham Easysoft Limited http://www.easysoft.com, http://www.unixODBC.org _______________________________________________ unixODBC-support mailing list unixODBC-support@... http://mail.easysoft.com/mailman/listinfo/unixodbc-support
	AW: AdabasD with unixODBC by Ray Ramsaroop :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hello, dltest /usr/lib/unixODBC/odbclib.so SQLConnect /unixODBC/odbclib.so SQLConnect SUCCESS: Loaded /usr/lib/unixODBC/odbclib.so SUCCESS: Found SQLConnect strace isql -v GMARKT 2> sl [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/unixODBC/odbclib.a' : /usr/lib/unixODBC/odbclib.a: invalid ELF header readelf /usr/lib/unixODBC/odbclib.a -h Displays a long list of information : : ELF Header: Magic: 7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00 Class: ELF32 Data: 2's complement, little endian Version: 1 (current) OS/ABI: UNIX - System V ABI Version: 0 Type: REL (Relocatable file) Machine: Intel 80386 Version: 0x1 Entry point address: 0x0 Start of program headers: 0 (bytes into file) Start of section headers: 660 (bytes into file) Flags: 0x0 Size of this header: 52 (bytes) Size of program headers: 0 (bytes) Number of program headers: 0 Size of section headers: 40 (bytes) Number of section headers: 10 Section header string table index: 7 Ray Ramsaroop > Hello, > > I'm trying to configure AdabasD with unixODBC, PHP5 > > odbcinst.ini: > ------------------------- > [ODBC] > TraceFile = /tmp/sql.log > Trace = Yes > > [AdabasD] > Description=AdabasD ODBC Driver Driver=/usr/lib/unixODBC/odbclib.so > > odbc.ini > ---------------------------- > [GMARKT] > Driver=AdabasD > Serverdb=GMARKT > Servernode=192.168.1.2 > SqlMode=ANSI > IsolationLevel=Uncommited > TraceFileName=gmarkt.pct > > testing with "isql -v GMARKT user pswrd" reslts [ISQL]ERROR: Could not > SQLConnect Ok, first thing I would try is using strace to see where it got to, and if it loaded the lib. First check the lib can be loaded. dltest /usr/lib/unixODBC/odbclib.so SQLConnect Then I would try is using strace to see where it got to. strace isql -v dsn 2> sl -- Nick Gorham Easysoft Limited http://www.easysoft.com, http://www.unixODBC.org _______________________________________________ unixODBC-support mailing list unixODBC-support@... http://mail.easysoft.com/mailman/listinfo/unixodbc-support _______________________________________________ unixODBC-support mailing list unixODBC-support@... http://mail.easysoft.com/mailman/listinfo/unixodbc-support
	Re: AW: AdabasD with unixODBC by Nick Gorham :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Ray Ramsaroop wrote: >Hello, > >dltest /usr/lib/unixODBC/odbclib.so SQLConnect > > /unixODBC/odbclib.so SQLConnect > SUCCESS: Loaded /usr/lib/unixODBC/odbclib.so > SUCCESS: Found SQLConnect > >strace isql -v GMARKT 2> sl > [01000][unixODBC][Driver Manager]Can't open lib >'/usr/lib/unixODBC/odbclib.a' : /usr/lib/unixODBC/odbclib.a: invalid >ELF header > >readelf /usr/lib/unixODBC/odbclib.a -h > Displays a long list of information > > : > Where did the libs come from, you started with a .so but the error indicates a .a Is there any information of interest in the sl file created by strace? Does it show it opening the .so and the trying to open the .a? -- Nick Gorham Easysoft Limited http://www.easysoft.com, http://www.unixODBC.org _______________________________________________ unixODBC-support mailing list unixODBC-support@... http://mail.easysoft.com/mailman/listinfo/unixodbc-support

LightInTheBox - Buy quality products at wholesale price!