General discussion

Locked

Linux Webserver and ODBC connectivity

By mochagal ·
We have a huge relational access database and are the process of upgrading to SQL server.
We just got a Linux server as our web-server
and I recommended NetObjects Fusion as a quick and easy way of getting our web site up.
Now my boss wants our clients to have access to some fields in our database (be able to place their orders and have it captured in our existing database)
I'm not a linux person - can I get ODBC to our SQL server when I upgrade our access database to SQL
HELP

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Linux Webserver and ODBC connectivity

by A.C In reply to Linux Webserver and ODBC ...

short answer. ODBC drivers ? are available.

try
http://www.ivsol.com/vpcgi.htm

Longer answer, ODBC is an API (programming Interface) and as such the ODBC libraries are available for Linux, but it's not quite as simple as setting up an ODBC driver in windows. You can write applications that use the Linux ODBC to access an external database.
Your best options (in no order).
Your requirements sound like you would need to be running the database access from the server side, therefore you will need to do something like a cgi form, now, how this is implemented is the real issue.
Perl is an option, write the cgi scripts in perl and you should be able to get to your SQL database using perl DBI interface routines.
You could also use JDBCto get the connection to the SQL server from your web server (see http://java.sun.com/products/jdbc/download.html for download details, and search on the sun site for other info)
The most obvious (but least acceptable !) option would be to use Fusion to create your database access web pages/forms, set up the ODBC connection etc, and then run with a seperate web server on, say, an NT/2000 box (I assume you will have your SQL server running on NT/2000 anyway, you didn't actually say if you are using MS SQL?) and link your web pages to that. It's a tad messy, not intergrated, and could cause other interesting problems (such as do you want your SQL server to be seen directly from outside?), but has the advantage of getting your system up quickly whilst you could work on a more intergrated (i.e. Linux server based) solution

Collapse -

Linux Webserver and ODBC connectivity

by mochagal In reply to Linux Webserver and ODBC ...

Poster rated this answer

Collapse -

Linux Webserver and ODBC connectivity

by mochagal In reply to Linux Webserver and ODBC ...

This question was closed by the author

Back to Linux Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums