this is fine for windows as the odbc drivers are a standard part of the os distro. unix requires ( expensive & pita ? ) 3rd party odbc drivers.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jimi DeRouen Sent: Monday, September 26, 2005 01:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Can Universe Play with Access? George, I have successfully done this with Universe on Windows and MS SQL. I would imagine that MS Access is just another ODBC data source that could be accessed from Universe TCL. The relevant documentation would include the Universe Basic SQL Client Interface Guide for your platform and version. Good luck. Jimi DeRouen Systems Analyst ABC-CLIO [EMAIL PROTECTED] 800-368-6868 x150 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Monday, September 26, 2005 9:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Can Universe Play with Access? OK. Here's a question. If I copy an access .mdb database over to our system (unix), Is there a way to issue a SQL statement from TCL that will query the access database? OR How difficult would it be to read the data from the access .mdb file, and populate a UV file for TCL queries? Assume that the UV file would be wiped prior to reading the .mdb and the .mdb is a snapshot of current access database, and not actively being used. We are looking at an application that creates standard access .mdb files but we will need to import that database into our system. George ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/