Discussion Locked

Linux Webserver and ODBC connectivity

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 :(

3 replies

by a.c

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

This discussion is closed to new replies.