Over my head

[ucfcarver]

I am working on a project for work involving collecting data and inserting it inot an sql databse.

The data is collected on a remote computer that travel in and out of network coverage. When in the network I need to upload a file to the server.

However it is a little more complicated then just a straight forward upload.

The remote computer is a Linux system(ubunut)
There server is microsoft sql express
the upload needs to be automated when in the network

I can automatically trigger the upload sequence, however i can not figure out how to set up a program between the remote box and the server to handle the file upload. What i have been looking at is using html to upload the file and then a cgi on the server to hand the insertion into the database.

I am new to progamming, linux and sql servers so the answer may not be that complicated but i am unable to figure it out. Any help would be great.

[WingedPanther]

I would just connect directly to the database server and issue the SQL statements to upload the data.

[Jordan]

As WP said above, you should be able to connect directly to the database server and send the file that way.

[ucfcarver]

In a linux system how do I get the sql commands. I have read about what is called an ODBC bridge which seems to be some sort of libraries.

I am not sure the proper method to go about accessing the sql database from the linux environment.

If you could point me in the right direction of some example that would be great.

[WingedPanther]

ODBC bridges are optional, and only apply to the computer you are running the program on, not the server.