C program to connect to MS SQL server

wiener · 10-18-2009, 08:22 AM

Hi folks,
I need to write a C client program that communicates with a Microsoft SQL server.
I need help with finding the actual content of the messages that flow between the client and the server, and best - if there is aleady such a code which I can re-use.
Thanks in advance,
Moses.

rylan76 · 10-19-2009, 02:51 AM

Sounds like you need a packet-sniffer?

http://www.ethereal.com/

xeleema · 10-19-2009, 03:39 AM

C? How about PERL? There's a great write up over there on perlmonks.

If you need something that can run on the command line, I could suggest maybe PHP, as well. But for C, I don't know.

Good Luck!

wiener · 10-21-2009, 01:22 PM

Quote:

Originally Posted by xeleema

C? How about PERL? There's a great write up over there on perlmonks.

If you need something that can run on the command line, I could suggest maybe PHP, as well. But for C, I don't know.

Good Luck!

Well, thanks for the reply. Yet, I have to do it in C. I've got the document that describes the protocol of thoe messages that flow bwetween the client and the server, and I'm implementing them as a client software.
The doc is the spec of "Tabular Data Stream Protocol" Version 4.2 by Microsoft.

schneidz · 10-21-2009, 01:56 PM

does mssql allow querying from the command line like mysql ?

i would assume it would be just as easy as implimenting a few system() calls.

xeleema · 10-21-2009, 02:01 PM

I don't think system() would have the facility to do that. It depends on two things;

1. Do you have a MySQL API that you're going through?

2. Are you accessing a local MySQL database, or a remote one?

That being said, I know that you can throw commands at a MySQL DB like this;

Code:

mysql -u username -p -e "create database exampledb"

If you have a really complicated query, you can throw it into a file and run it as needed, too;

Code:

mysql -u username -p exampledb < query.sql

Hope this helps!

wiener · 10-21-2009, 02:04 PM

Quote:

Originally Posted by schneidz

does mssql allow querying from the command line like mysql ?

i would assume it would be just as easy as implimenting a few system() calls.

The messages in MS SQL are binary messages, unlike the so-much-friendly
mySql, so I guess there is no easy way to use the 'system' call.

schneidz · 10-21-2009, 02:13 PM

Quote:

Originally Posted by xeleema

I don't think system() would have the facility to do that. It depends on two things;

1. Do you have a MySQL API that you're going through?

2. Are you accessing a local MySQL database, or a remote one?

That being said, I know that you can throw commands at a MySQL DB like this;

Code:

mysql -u username -p -e "create database exampledb"

If you have a really complicated query, you can throw it into a file and run it as needed, too;

Code:

mysql -u username -p exampledb < query.sql

Hope this helps!

i know this is off-topic but why wouldnt this work:

Code:

#include <stdio.h>
main()
{
 system("mysql -u username -p exampledb < query.sql");
/*/
the original poster already explained why this wouldnt work:
 system("mssql -u username -p exampledb < query.sql");
/*/
}

wiener · 10-21-2009, 02:17 PM

It would work for mysql provided that I have the mysql client program installed on my machine.
Yet, I need to implement a client for Microsoft SQL - which as far as I know, has no line command client program for their DB server.