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