Recently I got the task of building a PHP application, that connects to a remote ODBC driver. We got the ODBC driver and set up a test environment.
Since it's my first time working with ODBC drivers, I have no idea what to do, to be able to connect to the driver. I know the code and I was able to connect to the ODBC driver using PHP and a DSN on the local machine. But since I have to connect from a remote machine using a DSN-less connection, I figure it's not that easy anymore.
The ODBC driver is custom (PARKWAY ConnectWare for Micro Focus Files) and we didn't get a documentation for it (only the connection string parameter description, which was helpful, but not enough to solve our problem). Googling didn't help either, we didn't find anything.
Does anyone know what else do you need to be able to remotely connect to an ODBC driver? Logically it makes sense that only the driver is not enough, some kind of server perhaps...
I'd be grateful for any kind of push in the right direction :)
UPDATE:
the PARKWAY support answered me with the connection string and the basic information. My first instinct was right -- to be able to connect to an ODBC driver on a remote machine, I need their server application. I already installed their server evaluation copy and will play with it a little today. The connection string they suggested was:
Driver=PARKWAY ConnectWare for Micro Focus Files;DBQ=D:\MyServerData;Layout=Version3;FileType=Micro Focus;Location=MyServer
I did manage to get a different error when trying to connect this time:
SQL error: Failed to fetch error message
But I suppose this is a code problem.