I don't have any experience with PHP so can't help you there. As long as your PHP client can perform a similar capability in terms of the OpenQuery command then you may get this working. Whilst my requirement is different to your's ultimately it's the QAD server config and ODBC setup that's key. I believe it is important that the bit versions of the OS/Database and the ODBC drivers match but haven't confirmed this yet. This was ultimately the datasource for my SSRS report. Create standard T-SQL query using the view in point 3 as the data source.Create a view which uses the OpenQuery syntax to extract data from QAD (in my case this was created in the ReportServer database) via the linked server.Create a Linked Server in SQL Server via the ODBC DSN.Create the ODBC System DSN on the client machine (in my case a Windows Server 2008 R2 machine running SQL Server 2008 R2 with SSRS) with the additional database references as per the article.Create the oesql.properties config file as per the article relevant to the primary and custom databases.I have tested this on Progress 10.1c (this method is only supported in 10.1b+). I needed to connect to QAD from Microsoft SSRS to create reports against the QAD data - I needed to create some reports that the standard QAD report designer could not handle. I have tested this and it works well although my setup is slightly different. I had a similar requirement - I wanted to create a join between a table in the primary QAD database and a custom table in our custom database.
Quick Guide To Setting Up MultiDatabase ODBC Connectivity Not sure if you've already found a solution to this but there is a Progress article on how to do this.
0 kommentar(er)
