Matt,
> 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.
actually those tools enable my Linux system to be able to deal with the
mdb files and make sth. like the System-DSN on Windows machines.
and exactly there seems to be the point.
after several google sessions i found out, that the problem has to do with
the unixODBC thing and the jdbc-odbc driver provided by Sun.
> 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.
i "fine-tuned" the entry in the bluedragon.xml - which turned out to be
somewhat helpful. now the webpage i try to connect with the database
(well... i hate calling Access a dbms^^) yields "The result set type is not
supported".
uhm, i think i should focus on the driver, as these problems often seem to
occur in an java/Linux/Access environment.
> 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.
right ... i also never thought, i'd use Access-files in that environment.
> But if you're configuring the datasource as an "other" datasource and have >
> the driver configured correctly, in theory it should work.
at least almost, had to fill out the following section by hand, to get the
database recognized by the cfml page itself.
<datasource name="someWeirdName">
<displayname>someWeirdName</displayname>
...
<port>5432</port>
...
<databasename>someWeirdName</databasename>
...
</datasource>
The other values were filled out by the administrator correctly.
So... that's it - if i get it somehow done, i'll let you know.
regards,
Hauke
-------- Original Message --------
Subject: [OpenBD] Re: OBD with Access 2003 Database (27-Jan-2009 16:20)
From: Matthew Woodward <[email protected]>
To: [email protected]
> 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.
>
>
> 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
>
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
