I'm trying to figure out how to access a Windows database (SQL server) from a Linux server. I'm trying to use Win32::ODBC and I've got a lot of information on how to make a connection, running queries, extracting the data, but the piece that I'm missing is what do you do if your database in NOT local ?? I'm assuming accessing remote databases is something developers do, so I'm a little confused on why I can't find any data about this. Can you provide any information ?
I think I need to use the DBI::Proxy, I just have to make sure the correct modules are loaded on the windows machine
How do I access a MS Windows based database from UNIX/Linux using DBI::Proxy?
On the UNIX/Linux machine install DBI and all the modules to support DBD::Proxy.
On the Windows system install DBI, all the modules for DBD::Proxy, and DBD::ODBC.
Define a system DSN (using ODBC connection manager) to the Windows database.
Using the ODBC Test connection, test the ODBC connection.
I just know much about loading modules on Windows. Any thoughts on that ??