raylight_events wrote:
Now, when i add the Database in the OBD-Admin, it throws an error saying "Could not verify datasource: The result set type is not supported.". As it can't verify the Datasource, i can't use it on the Website ... what ca I do about that?
Quick fix is to add the datasource in the bluedragon.xml file directly and see if that works. Then run some simple queries on a CFML page to make sure you get the results back correctly, because it could be that for some reason Access through the JDBC-ODBC bridge on Linux doesn't return the resultset in such a way that it's recognized as a query object by OpenBD.
That might be a long shot I realize but if you could test that it would be helpful--then if that doesn't work we'd know the real issue is with Access on Linux with OpenBD.
As for the admin, I'll be honest and say I didn't take into account anyone would ever be using an Access database on Linux. But if you're configuring the datasource as an "other" datasource and have the driver configured correctly, in theory it should work.
The tricky part is testing your exact setup. What's the minimal amount of stuff I could set up to test this? Just an Access database with the Sun JDBC-ODBC bridge drivers? I assume the tools you're mentioning are just so you can work with Access on Linux but that they don't have anything to do with creating JDBC connections.
I'll try to give this a shot today and see what happens but if you could configure the datasource manually in bluedragon.xml and run a query or two against your DB to see if that works, that would help a lot. Thanks.
-- Matt Woodward [email protected] http://www.mattwoodward.com/blog Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html
smime.p7s
Description: S/MIME Cryptographic Signature
