MSSQL Access under Linux

[Shawn Tayler]

Hi Guys,

I've been trying to find a way to access a database running on a WindBlows
server and MS-SQL.  I plan to port the data into my PostgreSQL database
for reports and archiving.  I am looking for a simple commandline
interactive client, rather like the psql app for Postgres.  I'll be taking
the results of some queries and dumping them to flat files that can be
precessed and loaded into my "Real" database. 

Suggestions as to where to look?  

I've been trying dbtcp but it won't build, example:

shawn at shop:~/dbtcp-0.1.18a$ make
ar cr libs/libdbftp.a socket.o my_error.o protocol.o utils/my_string.o
utils/my_array.o utils/my_bstring.o make -C dbug -e libdbug.a
make[1]: Entering directory `/home/shawn/dbtcp-0.1.18a/dbug'
gcc -O    -c -o dbug.o dbug.c
dbug.c:210: error: conflicting types for 'fprintf'
dbug.c:210: note: a parameter list with an ellipsis can't match an empty
parameter name list declaration dbug.c:210: error: conflicting types for
'fprintf' dbug.c:210: note: a parameter list with an ellipsis can't match
an empty parameter name list declaration dbug.c:213: warning: conflicting
types for built-in function 'malloc' dbug.c:214: warning: conflicting
types for built-in function 'strlen' make[1]: *** [dbug.o] Error 1
make[1]: Leaving directory `/home/shawn/dbtcp-0.1.18a/dbug'
make: *** [dbtcp] Error 2
shawn at shop:~/dbtcp-0.1.18a$                            

Here's the section of code that fails:

IMPORT int atoi ();             /* Convert ascii to integer */
IMPORT VOID exit ();            /* Terminate execution */
IMPORT int fclose ();           /* Close a stream */
IMPORT FILE *fopen ();          /* Open a stream */
IMPORT int fprintf ();          /* Formatted print on file */ <------  HERE
IMPORT int vfprintf ();         /* Varargs form of fprintf */
IMPORT VOID free ();
IMPORT char *malloc ();         /* Allocate memory */
IMPORT int strlen ();

Which looks good as far as I can tell....

Plus it requires a service app to be running on the MS-SQL box,
something I'm not totally comfortable with.  

What wisdom can you bestow oh great list?

Shawn