Re: Newbie need your help,thanks

["bubble" <bubble@bubble.d2g.com>]

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 16776 bytes --]

Thank you,
It's useful and work now!

"Steve" <nospam_steved94@comcast.net> �b�l��
news:HBu%c.130085$9d6.38147@attbi_s54 �����g...
> I'm not sure how to set things up in GPS, but from the command line I
think
> you need to pass an argument to the linker.  Something like:
>
>   gnatmake myfile -largs -lodbc32
>
> Consider this an educated guess.
>
> Steve
> (The Duck)
>
> "bubble" <bubble@bubble.d2g.com> wrote in message
> news:chk79e$7fk$1@netnews.hinet.net...
> > I use GPS 1.4 and this is my project source code.
> >
> >
> > project T is
> >    for Languages use ("Ada");
> >    for Source_Dirs use (".");
> >    for Object_Dir use "obj";
> >    for Main use ("test.adb");
> >    package Naming is
> >       for Specification_Suffix ("gesql") use ".gpq";
> >       for Specification_Suffix ("sql") use ".sql";
> >    end Naming;
> >
> >    package Linker is
> >       for Default_Switches ("ada") use ("-g");
> >    end Linker;
> >
> >    package Binder is
> >       for Default_Switches ("ada") use ("-static");
> >    end Binder;
> >
> >    package Compiler is
> >       for Default_Switches ("ada") use ("-g");
> >       for Default_Switches ("c") use ("");
> >       for Default_Switches ("c++") use ("");
> >       for Default_Switches ("Ada") use ("-gnatN", "-funroll-loops",
"-g");
> >    end Compiler;
> >
> >    package Builder is
> >        for Default_Switches ("Ada") use ("-g",
> > "-gnatQ","-IC:\GNADE\win32-include");
> >    end Builder;
> > end T;
> >
> >
> >
> >
> >
> > and I got the error message..   ~~>___<~~~
> >
> > gnatmake -d -Pc:\ada\t.gpr c:\ada\test.adb
> > gcc -c -g -gnatQ -IC:\GNADE\win32-include -o
> > c:\ada\obj\test.o -gnatN -funroll-loops -g -gnatA c:\ada\.\test.adb
> > gnatbind -aOC:\GNADE\win32-include -static -x test.ali
> > gnatlink -g -g -o c:\ada\obj\test.exe test.ali
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sql_error_message':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:199: undefined reference to
> > `SQLGetDiagRec@32'
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:213: undefined reference to
> > `SQLGetDiagField@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlallochandle':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:279: undefined reference to
> > `SQLAllocHandle@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlallochandle$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:286: undefined reference to
> > `SQLAllocHandle@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfreehandle':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:311: undefined reference to
> > `SQLFreeHandle@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfreehandle$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:317: undefined reference to
> > `SQLFreeHandle@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfreestmt':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:334: undefined reference to
> > `SQLFreeStmt@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlconnect':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:366: undefined reference to
> > `SQLConnect@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlconnect$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:380: undefined reference to
> > `SQLConnect@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldisconnect':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:420: undefined reference to
> > `SQLDisconnect@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldisconnect$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:424: undefined reference to
> > `SQLDisconnect@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlgettypeinfo':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:443: undefined reference to
> > `SQLGetTypeInfo@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlgettypeinfo$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:449: undefined reference to
> > `SQLGetTypeInfo@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldatasources':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:484: undefined reference to
> > `SQLDataSources@32'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldrivers$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:578: undefined reference to
> > `SQLDrivers@32'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindcol':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:655: undefined reference to
> > `SQLBindCol@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindcol$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:669: undefined reference to
> > `SQLBindCol@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindcol$3':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:690: undefined reference to
> > `SQLBindCol@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindparameter':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1174: undefined reference to
> > `SQLBindParameter@40'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindparameter$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1196: undefined reference to
> > `SQLBindParameter@40'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbindparameter$3':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1220: undefined reference to
> > `SQLBindParameter@40'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldescribeparam':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1279: undefined reference to
> > `SQLDescribeParam@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcancel':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1325: undefined reference to
> > `SQLCancel@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcancel$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1329: undefined reference to
> > `SQLCancel@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlclosecursor':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1341: undefined reference to
> > `SQLCloseCursor@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlclosecursor$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1345: undefined reference to
> > `SQLCloseCursor@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprepare':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1360: undefined reference to
> > `SQLPrepare@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprepare$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1368: undefined reference to
> > `SQLPrepare@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlexecute':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1399: undefined reference to
> > `SQLExecute@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlexecute$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1403: undefined reference to
> > `SQLExecute@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfetch':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1415: undefined reference to
> > `SQLFetch@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfetch$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1419: undefined reference to
> > `SQLFetch@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfetchscroll':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1437: undefined reference to
> > `SQLFetchScroll@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlfetchscroll$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1443: undefined reference to
> > `SQLFetchScroll@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlgetcursorname':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1465: undefined reference to
> > `SQLGetCursorName@16'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlsetcursorname':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1539: undefined reference to
> > `SQLSetCursorName@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlsetcursorname$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1547: undefined reference to
> > `SQLSetCursorName@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlexecdirect':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1583: undefined reference to
> > `SQLExecDirect@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlexecdirect$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1590: undefined reference to
> > `SQLExecDirect@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlendtran':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1626: undefined reference to
> > `SQLEndTran@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlendtran$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1633: undefined reference to
> > `SQLEndTran@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcommit':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1633: undefined reference to
> > `SQLEndTran@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlrollback':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1633: undefined reference to
> > `SQLEndTran@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlnumparams':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1665: undefined reference to
> > `SQLNumParams@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlnumparams$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1670: undefined reference to
> > `SQLNumParams@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlnumresultcols':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1687: undefined reference to
> > `SQLNumResultCols@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlnumresultcols$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1694: undefined reference to
> > `SQLNumResultCols@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlrowcount':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1712: undefined reference to
> > `SQLRowCount@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlrowcount$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1717: undefined reference to
> > `SQLRowCount@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlgetdata':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1743: undefined reference to
> > `SQLGetData@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlgetdata$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1757: undefined reference to
> > `SQLGetData@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlputdata':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1780: undefined reference to
> > `SQLPutData@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlputdata$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1786: undefined reference to
> > `SQLPutData@12'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlparamdata':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1804: undefined reference to
> > `SQLParamData@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlparamdata$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1809: undefined reference to
> > `SQLParamData@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcopydesc':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1826: undefined reference to
> > `SQLCopyDesc@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcopydesc$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1831: undefined reference to
> > `SQLCopyDesc@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlstatistics':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1860: undefined reference to
> > `SQLStatistics@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlstatistics$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1880: undefined reference to
> > `SQLStatistics@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqltables':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1946: undefined reference to
> > `SQLTables@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqltables$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:1963: undefined reference to
> > `SQLTables@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprocedures':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2021: undefined reference to
> > `SQLProcedures@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprocedures$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2035: undefined reference to
> > `SQLProcedures@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprocedurecolumns':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2096: undefined reference to
> > `SQLProcedureColumns@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprocedurecolumns$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2114: undefined reference to
> > `SQLProcedureColumns@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqltableprivileges':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2174: undefined reference to
> > `SQLTablePrivileges@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqltableprivileges$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2189: undefined reference to
> > `SQLTablePrivileges@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcolumnprivileges':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2247: undefined reference to
> > `SQLColumnPrivileges@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcolumnprivileges$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2265: undefined reference to
> > `SQLColumnPrivileges@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlspecialcolumns':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2329: undefined reference to
> > `SQLSpecialColumns@40'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlspecialcolumns$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2349: undefined reference to
> > `SQLSpecialColumns@40'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprimarykeys':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2412: undefined reference to
> > `SQLPrimaryKeys@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlprimarykeys$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2427: undefined reference to
> > `SQLPrimaryKeys@28'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlforeignkeys':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2487: undefined reference to
> > `SQLForeignKeys@52'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlforeignkeys$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2510: undefined reference to
> > `SQLForeignKeys@52'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldescribecol':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2596: undefined reference to
> > `SQLDescribeCol@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcolumns':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2719: undefined reference to
> > `SQLColumns@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlcolumns$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2735: undefined reference to
> > `SQLColumns@36'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlnativesql':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2796: undefined reference to
> > `SQLNativeSql@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbulkoperations':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2870: undefined reference to
> > `SQLBulkOperations@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbulkoperations$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2876: undefined reference to
> > `SQLBulkOperations@8'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlmoreresults':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2890: undefined reference to
> > `SQLMoreResults@4'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlsetpos':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2906: undefined reference to
> > `SQLSetPos@16'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlsetpos$2':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2914: undefined reference to
> > `SQLSetPos@16'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqlbrowseconnect':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:2944: undefined reference to
> > `SQLBrowseConnect@24'
> > ./gnu-db-sqlcli.o: In function `gnu__db__sqlcli__sqldriverconnect':
> > c:/gnade/win32-include/gnu-db-sqlcli.adb:3036: undefined reference to
> > `SQLDriverConnect@32'
> > gnatlink: cannot call C:\GNAT\bin\gcc.exe
> > gnatmake: *** link failed.
> >
> > process exited with status 4
> >
> >
> >
> >
> >
> >
> > "bubble" <bubble@bubble.d2g.com> �b�l��
> news:chk00d$cu8$1@netnews.hinet.net
> > �����g...
> > > dear all
> > > I am a newbie to Ada from Java.
> > > I'm interesting ada and have some questions.
> > >
> > > one of them confused to me is...
> > > I get some ada library,such as GNAde.
> > > I install it and try to wirte some example to test..
> > > and I don't know how to compiling my example with libray.
> > > accroding to GNat User Guide
> > > could you tell me how to do.
> > > thanks.
> > >
> > >
> > > your friend,bubble.
> > >
> > >
> >
> >
>
>