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/

Reply via email to