Accessing SQL Server 2000 from QNX using HTTP

I would like to be able to access a SQL Server 2000 database from a QNX box
on the same network. Id eally i wiould like to do this by sending a HTTP
call to the SQL Server 2000 Database as this would allow me to execute SQL
queries on the database from the QNX box using only the SQL equivalent Text
string. What I am wondering is, is there a simple way to do this under QNX?
I mean Voyager must be able to do this so the libraries must exist. So I
guess need to know what libraries and what calls are appropriate to this
task. Any suggestion would be most welcome.

Is there something special (other than normal web surfing capabilities)
required on the client side? That is, does voyager need to submit some type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the browser
connecting to the server, the server presenting some type of page, perhaps a
form, and then the browser submitting that page to the server after which
the server replies with some other web page. In this case, all the work is
done by the server which only presents standard html pages and accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <cpicking@monduran.com> wrote in message
news:ae3mrn$51u$1@inn.qnx.com

I would like to be able to access a SQL Server 2000 database from a QNX
box
on the same network. Id eally i wiould like to do this by sending a HTTP
call to the SQL Server 2000 Database as this would allow me to execute SQL
queries on the database from the QNX box using only the SQL equivalent
Text
string. What I am wondering is, is there a simple way to do this under
QNX?
I mean Voyager must be able to do this so the libraries must exist. So I
guess need to know what libraries and what calls are appropriate to this
task. Any suggestion would be most welcome.

The only thing you may be missing is that I want to do this from within a c
program without ever displaying a web page on a client browser. I need to
send a http post request, I don’t need to display the reply. This should all
happen as a background process.

“Kris Warkentin” <kewarken@qnx.com> wrote in message
news:ae4t65$4d2$1@nntp.qnx.com

Is there something special (other than normal web surfing capabilities)
required on the client side? That is, does voyager need to submit some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the browser
connecting to the server, the server presenting some type of page, perhaps
a
form, and then the browser submitting that page to the server after which
the server replies with some other web page. In this case, all the work
is
done by the server which only presents standard html pages and accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database from a QNX
box
on the same network. Id eally i wiould like to do this by sending a HTTP
call to the SQL Server 2000 Database as this would allow me to execute
SQL
queries on the database from the QNX box using only the SQL equivalent
Text
string. What I am wondering is, is there a simple way to do this under
QNX?
I mean Voyager must be able to do this so the libraries must exist. So I
guess need to know what libraries and what calls are appropriate to this
task. Any suggestion would be most welcome.
\

We don’t ship anything like that per se but, on the other hand, the http
protocol is not horribly complicated. You probably could put together
something simple that just opens the port and sends the header and request.

I took a look on quick look on freshmeat and found this project which may be
useful.
http-tiny:
http://freshmeat.net/projects/http-tiny/?topic_id=90%2C809

There’s also the w3c reference implementation of a client library called
libwww at http://www.w3.org/Library/.

cheers,

Kris

“Colin Picking” <cpicking@monduran.com> wrote in message
news:ae60vr$sus$2@inn.qnx.com

The only thing you may be missing is that I want to do this from within a
c
program without ever displaying a web page on a client browser. I need to
send a http post request, I don’t need to display the reply. This should
all
happen as a background process.

“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae4t65$4d2$> 1@nntp.qnx.com> …
Is there something special (other than normal web surfing capabilities)
required on the client side? That is, does voyager need to submit some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the browser
connecting to the server, the server presenting some type of page,
perhaps
a
form, and then the browser submitting that page to the server after
which
the server replies with some other web page. In this case, all the work
is
done by the server which only presents standard html pages and accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database from a
QNX
box
on the same network. Id eally i wiould like to do this by sending a
HTTP
call to the SQL Server 2000 Database as this would allow me to execute
SQL
queries on the database from the QNX box using only the SQL equivalent
Text
string. What I am wondering is, is there a simple way to do this under
QNX?
I mean Voyager must be able to do this so the libraries must exist. So
I
guess need to know what libraries and what calls are appropriate to
this
task. Any suggestion would be most welcome.


\

Isn’t libcurl (http://curl.haxx.se/libcurl/) supposed to do that?


Jens
“Kris Warkentin” <kewarken@qnx.com> wrote in message
news:ae7ucp$fmt$1@nntp.qnx.com

We don’t ship anything like that per se but, on the other hand, the http
protocol is not horribly complicated. You probably could put together
something simple that just opens the port and sends the header and
request.

I took a look on quick look on freshmeat and found this project which may
be
useful.
http-tiny:
http://freshmeat.net/projects/http-tiny/?topic_id=90%2C809

There’s also the w3c reference implementation of a client library called
libwww at > http://www.w3.org/Library/> .

cheers,

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae60vr$sus$> 2@inn.qnx.com> …
The only thing you may be missing is that I want to do this from within
a
c
program without ever displaying a web page on a client browser. I need
to
send a http post request, I don’t need to display the reply. This should
all
happen as a background process.

“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae4t65$4d2$> 1@nntp.qnx.com> …
Is there something special (other than normal web surfing
capabilities)
required on the client side? That is, does voyager need to submit
some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the
browser
connecting to the server, the server presenting some type of page,
perhaps
a
form, and then the browser submitting that page to the server after
which
the server replies with some other web page. In this case, all the
work
is
done by the server which only presents standard html pages and accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database from a
QNX
box
on the same network. Id eally i wiould like to do this by sending a
HTTP
call to the SQL Server 2000 Database as this would allow me to
execute
SQL
queries on the database from the QNX box using only the SQL
equivalent
Text
string. What I am wondering is, is there a simple way to do this
under
QNX?
I mean Voyager must be able to do this so the libraries must exist.
So
I
guess need to know what libraries and what calls are appropriate to
this
task. Any suggestion would be most welcome.




\

I initially thought of libcurl but someone told me that it was only for
uploading and downloading files to and from various URL’s. Judging from the
website, it’s a real swiss army knife though. Might even be overkill for
his app.

Kris

“Jens H Jorgensen” <jhj@remove-nospam-videk.com> wrote in message
news:ae81ev$fpk$1@inn.qnx.com

Isn’t libcurl (> http://curl.haxx.se/libcurl/> ) supposed to do that?


Jens
“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae7ucp$fmt$> 1@nntp.qnx.com> …
We don’t ship anything like that per se but, on the other hand, the http
protocol is not horribly complicated. You probably could put together
something simple that just opens the port and sends the header and
request.

I took a look on quick look on freshmeat and found this project which
may
be
useful.
http-tiny:
http://freshmeat.net/projects/http-tiny/?topic_id=90%2C809

There’s also the w3c reference implementation of a client library called
libwww at > http://www.w3.org/Library/> .

cheers,

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae60vr$sus$> 2@inn.qnx.com> …
The only thing you may be missing is that I want to do this from
within
a
c
program without ever displaying a web page on a client browser. I need
to
send a http post request, I don’t need to display the reply. This
should
all
happen as a background process.

“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae4t65$4d2$> 1@nntp.qnx.com> …
Is there something special (other than normal web surfing
capabilities)
required on the client side? That is, does voyager need to submit
some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the
browser
connecting to the server, the server presenting some type of page,
perhaps
a
form, and then the browser submitting that page to the server after
which
the server replies with some other web page. In this case, all the
work
is
done by the server which only presents standard html pages and
accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database from
a
QNX
box
on the same network. Id eally i wiould like to do this by sending
a
HTTP
call to the SQL Server 2000 Database as this would allow me to
execute
SQL
queries on the database from the QNX box using only the SQL
equivalent
Text
string. What I am wondering is, is there a simple way to do this
under
QNX?
I mean Voyager must be able to do this so the libraries must
exist.
So
I
guess need to know what libraries and what calls are appropriate
to
this
task. Any suggestion would be most welcome.






\

Especially interesting is their page with links to libraries which provide
similar functionality.
http://curl.haxx.se/libcurl/competitors.html

Kris

“Kris Warkentin” <kewarken@qnx.com> wrote in message
news:ae851r$kqo$1@nntp.qnx.com

I initially thought of libcurl but someone told me that it was only for
uploading and downloading files to and from various URL’s. Judging from
the
website, it’s a real swiss army knife though. Might even be overkill for
his app.

Kris

“Jens H Jorgensen” <> jhj@remove-nospam-videk.com> > wrote in message
news:ae81ev$fpk$> 1@inn.qnx.com> …
Isn’t libcurl (> http://curl.haxx.se/libcurl/> ) supposed to do that?


Jens
“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae7ucp$fmt$> 1@nntp.qnx.com> …
We don’t ship anything like that per se but, on the other hand, the
http
protocol is not horribly complicated. You probably could put together
something simple that just opens the port and sends the header and
request.

I took a look on quick look on freshmeat and found this project which
may
be
useful.
http-tiny:
http://freshmeat.net/projects/http-tiny/?topic_id=90%2C809

There’s also the w3c reference implementation of a client library
called
libwww at > http://www.w3.org/Library/> .

cheers,

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae60vr$sus$> 2@inn.qnx.com> …
The only thing you may be missing is that I want to do this from
within
a
c
program without ever displaying a web page on a client browser. I
need
to
send a http post request, I don’t need to display the reply. This
should
all
happen as a background process.

“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae4t65$4d2$> 1@nntp.qnx.com> …
Is there something special (other than normal web surfing
capabilities)
required on the client side? That is, does voyager need to submit
some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the
browser
connecting to the server, the server presenting some type of page,
perhaps
a
form, and then the browser submitting that page to the server
after
which
the server replies with some other web page. In this case, all
the
work
is
done by the server which only presents standard html pages and
accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database
from
a
QNX
box
on the same network. Id eally i wiould like to do this by
sending
a
HTTP
call to the SQL Server 2000 Database as this would allow me to
execute
SQL
queries on the database from the QNX box using only the SQL
equivalent
Text
string. What I am wondering is, is there a simple way to do this
under
QNX?
I mean Voyager must be able to do this so the libraries must
exist.
So
I
guess need to know what libraries and what calls are appropriate
to
this
task. Any suggestion would be most welcome.








\

Thanks for your reply Jens,

Yes libcurl IS supposed to do that and in fact that is the solution I
eventually came up with as well.

“Jens H Jorgensen” <jhj@remove-nospam-videk.com> wrote in message
news:ae81ev$fpk$1@inn.qnx.com

Isn’t libcurl (> http://curl.haxx.se/libcurl/> ) supposed to do that?


Jens
“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae7ucp$fmt$> 1@nntp.qnx.com> …
We don’t ship anything like that per se but, on the other hand, the http
protocol is not horribly complicated. You probably could put together
something simple that just opens the port and sends the header and
request.

I took a look on quick look on freshmeat and found this project which
may
be
useful.
http-tiny:
http://freshmeat.net/projects/http-tiny/?topic_id=90%2C809

There’s also the w3c reference implementation of a client library called
libwww at > http://www.w3.org/Library/> .

cheers,

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae60vr$sus$> 2@inn.qnx.com> …
The only thing you may be missing is that I want to do this from
within
a
c
program without ever displaying a web page on a client browser. I need
to
send a http post request, I don’t need to display the reply. This
should
all
happen as a background process.

“Kris Warkentin” <> kewarken@qnx.com> > wrote in message
news:ae4t65$4d2$> 1@nntp.qnx.com> …
Is there something special (other than normal web surfing
capabilities)
required on the client side? That is, does voyager need to submit
some
type
of special request outside of what it would usually do?

What I picture in this type of application is normally just the
browser
connecting to the server, the server presenting some type of page,
perhaps
a
form, and then the browser submitting that page to the server after
which
the server replies with some other web page. In this case, all the
work
is
done by the server which only presents standard html pages and
accepts
http/cgi type requests.

Or am I missing some subtlety?

Kris

“Colin Picking” <> cpicking@monduran.com> > wrote in message
news:ae3mrn$51u$> 1@inn.qnx.com> …
I would like to be able to access a SQL Server 2000 database from
a
QNX
box
on the same network. Id eally i wiould like to do this by sending
a
HTTP
call to the SQL Server 2000 Database as this would allow me to
execute
SQL
queries on the database from the QNX box using only the SQL
equivalent
Text
string. What I am wondering is, is there a simple way to do this
under
QNX?
I mean Voyager must be able to do this so the libraries must
exist.
So
I
guess need to know what libraries and what calls are appropriate
to
this
task. Any suggestion would be most welcome.






\