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.
>
>