I need to create a System DSN called MondrianFoodMart that points to /MondrianFoodMart.mdb file. The instructions to do this are very confusing.
More specifically I am trying to do section 2.1 of this confusing website: http://mondrian.pentaho.com/documentation/installation.php
Any help appreciated,
Ted
While in docs they say about JDBC URL to Access db: jdbc:odbc:MondrianFoodMart it may be easier to use such URL in other form:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=MONDRIAN_HOME\demo\access\MondrianFoodMart.mdb
Of course replace MONDRIAN_HOME with real directory name. It may be useful if such URL is part of configuration file. Then creating DNS will not be necessary.
Since the Microsoft ODBC Excel Driver doesn t support ALTER TABLE/DELETE FROM(/UPDATE?) statements, I m using alternative ways of getting the right data in the right place. I still have one problem ...
I m trying to see the SQL statements that are sent from MS Access 2003 to MySQL via ODBC. I ve tried ODBC Tracing, but it s painfully slow, producing very large log files which are very difficult ...
I access the progress DB using ODBC in my C# program, and I need to update some fields,which are array data type. so how can I write my sql statement to do such things? I read some progress ...
I m trying to use an Acces (MDB) database from a CakePHP app. On a Windows machine this works fine. On a Linux machine using Unixodbc this doesn t work at all. The error is as follows: Warning (2): ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I have an ASP.Net application that needs to display an image that is stored in a Filemaker Container field. My query statement looks like: SELECT GetAs(Image, JPG ) FROM UA_Item_Pictures WHERE "...
I have a development project that requires us to be able to support informix data sources via ODBC. I ve downloaded the prebuilt Informix Virtual Appliance from the IBM website and am able see the ...
i am dealing with some legacy access < 2007 "databases". All the tables are linked tables to a SQL Server 2008. While the odbc-links are established the table structure is copied into the mdb-file ...