I would test all this with a really simple Access table first, like a single column of strings (varchar) with a few rows. That error message (if it's actually coming from the JDBC driver and not BD) leads me to think that the DSN is actually working, just a little bit. Perhaps the "result set type" refers to some new Access funky column type in your table(s)?
Al [email protected] wrote: > > 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 !! -~----------~----~----~----~------~----~------~--~---
