Remote ODBC / Using MS Access DB Remotely

[stevesweetland]

Ok. Heres the scenario, i need a solution.

My client has an EPOS system, albeit a rubbish one which runs from a ms access database.

Currently, they have a report which exports current stock, they save this as a csv file, and they are able to upload to our application which parses the data. Not ideal, huh?

ANYWAY.. steering back to the matter at hand.

I want to make this process a whole lot more automated, so im thinking that if i could set up an odbc connection on the server, i would be able to query that database remotely, using one of the odbc libraries.

If this ISNT possible, can you think of another way i might make an access database on a remote windows 2000 server available to a linux webserver?

File transfer isnt an option, the database is somewhere in the region of 600 meg.

[Shrike]

We use Sql Server running on Windows and Debian for PHP. You'll need a couple of binaries to make the connection. UnixODBC to handle the ODBC connection and FreeTDS which implements the SQL dialect.

I have a few problems at the moment - both stored procedures and prepared statements fail on our live environment which is a big pain. Oddly though they work on our test environment, which is UnixODBC version 2.2.4. Hopefully I'll find a reason soon 🙂