Search the web
Sign In
New User? Sign Up
SimpleORM
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Works with Access?   Message List  
Reply | Forward Message #1534 of 1851 |
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





Tue Nov 20, 2007 12:20 am

jeabraham
Offline Offline
Send Email Send Email

Forward
Message #1534 of 1851 |
Expand Messages Author Sort by Date

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...
jeabraham
Offline Send Email
Nov 20, 2007
12:20 am

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 ...
Anthony & Melissa Ber...
berglas@...
Send Email
Nov 21, 2007
1:33 am

I have a need to copy a record in a database, and then modify the original and the copy. I make a new record using ParcelORM newOne = (ParcelORM)...
John Abraham
jeabraham
Offline Send Email
Nov 23, 2007
4:09 pm

Looks good to me. Best to avoid detaching. Note how easy it was to write the copying code. Sorry for not responding earlier, I missed it. Anthony ... EMail:...
Anthony & Melissa Ber...
berglas@...
Send Email
Dec 16, 2007
4:18 am

SimpleORM seems to work fine with Microsoft Access via JDBC:ODBC if you manually set the driver to SQLServer. Should this be added to the documentation? ...
John Abraham
jeabraham
Offline Send Email
Nov 23, 2007
4:13 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help