Web Server Connection to SQL Server

[jurgen]

Hey,

Can someone tell me how I can fix this :

We have a Linux Server installed as our Proxy, Mail and Webserver, a SQL Server 7 database on an Windows 2000 Advanced Server, and on our Clients Access 2000 ADP Application.

Now we want to connect over the internet to that database, which language can we use, so that the apache webserver can handle al request to go towards the database and retrieve data en write data in the database.

We would like to stay using linux for this in stead of IIS

I hope you'll understand me, if not let me know

Thanx very much
Regards

Jurgen

 

[rycamor]

It really has nothing to do with Apache, unless you wan't dynamic web pages generated from your database. Other than that, as long as you map an external IP address to your internal Win2K server, and pass the right TCP/IP port for ODBC, then any ODBC-aware application can connect to it (any further clarifications, anyone?). If you only have one external IP, that might be a bit of a problem, though.

Basically, as long as it appears to your client's Access 2000 application that there is an address and a database where they can connect via ODBC, then it's possible, and it doesn't matter which server it routes through, since the server is just passing data packets.

I unfortunately don't have much experience with ODBC, so I can't help you in detail here. I believe it's necessary to set up your SQL server to accept connections via TCP/IP and not Named Pipes.

 

[pollux0]

what is the procedure to connect php/apache on linux to a microsoft SQL Server DB on another machine, ODBC? what RPM pachages(pref. non-GUI) have this function. I have experience using microsoft odbc on advance server

thanks