From:	Peter_Monks AT PWU DOT PW-EXTERNAL DOT australia DOT notes DOT pw DOT com
Message-Id:	<199802160034.TAA03951@fern.us.pw.com>
To:	hostmaster AT bemarnet DOT es
cc:	djgpp AT delorie DOT com
Date:	Mon, 16 Feb 98 10:49:27 +1000
Subject:	Re: Internet applications and SQL Server access

In comp.os.msdos.djgpp, Antonio Navarro Navarro wrote:
>Hello all !!

G'day!

>Where can I find libraries and/or documentation for accesing a SQL
>Server (directly or via ODBC) using DJGPP ? 

Microsoft SQL Server can only be accessed by DOS applications using DBLIB.  
AFAIK the DBLIB interface is only available in Microsoft library format, so it 
probably isn't usable from DJGPP.  I also think that the DOS version of DBLIB 
is for 16 bit compilers only (which completely rules out DJGPP).

ODBC, OTOH, is distributed as DLLs, so you might be able to use it by writing 
Win32 applications using RSXNTDJ + DJGPP (the RSX import librarian can be used 
to create library files for each DLL).  The difficulty with this would be in 
obtaining the appropriate header files (not to mention coming to terms with the 
ODBC API! :-).

A third option is to use the command line tool ISQL to pump SQL through to SQL 
Server and then capture the result sets.  This would be quite inefficient, but 
could be made to work quite well (generic parsing functions for result sets and 
error messages etc.).

If you're referring to Sybase SQL Server, you might be able to access it 
through CTLIB (an advanced version of DBLIB that is only available on Sybase).  
I haven't used CTLIB, however, so don't know which platforms are supported.

Good luck with it!

Cheers,
Peter

----------------------------------------------------------------------
Peter Monks                    http://www.geocities.com/yosemite/4455/
pmonks AT iname DOT com
Peter_Monks AT australia DOT notes DOT pw DOT com

- Raw text -