I have successfully connected to an Access database and queried the Access tables with the ODBC below. However, I need to query Sage Timberline tables that I have linked to in the Access database. The linked Timberline tables require a user/password combo once the ODBC connection to the Access database has been established. For example when viewing the database through MS Access, when I double click a linked Timberline table to view it I have to supply my Timberline user name and password. How can I supply this info in my PHP ODBC connection file?
Thanks in advance.
$conn=odbc_connect($dsn,$user,$upasswd ) or die();