Re: Works with Access?

SimpleORM uses pretty standard SQL, and the drivers that customize it 
for databases are fairly straight forward to adapt.  But have not tried Access.

Anthony

At 10:20 AM 20-11-07, jeabraham wrote:

>Hi, I'm just starting to use SimpleORM and I think it will work for me.
>
>One thing, though, is that although much of my work is with MySQL, SQL
>Server, or PostgreSQL, I also do some work with MSAccess or even
>(gasp!) a JDBC:ODBC connection to MSExcel!
>
>Does the SQLServer driver work with MSAccess? Does the generic driver
>work with MSAccess? Anyone done this?
>
>If the existing drivers don't work, maybe I can write one for Access.
>It doesn't look like the driver-specific code is very long.
>
>(Making it work with the Microsoft JET driver to Excel might be a lot
>harder. Reading from Excel via JDBC:ODBC is easy, but writing back is
>sometimes hard. And Excel likes to pretend the table names have
>dollar signs in them. But if I can make it work with Access I'll
>probably be happy for now.)
>
>--
>John Abraham
>
>

EMail: [email protected]

+61 7 3369 4065 (Australian Eastern Standard Time)

If the model seems correct only because the numbers look right,
then why build the model in the first place?


 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[email protected] 
    mailto:[email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/