Thanks for your response.This would be a great idea if the Access
database wasn't a realtime system.It's counting parts used on reels
from our machines on the shop floor and is constantly updated from
multiple sources.
Unless I'm not fully understanding what you're suggesting...
John
[EMAIL PROTECTED] 11/7/2004 8:44:55 PM
John,
You might want to patch it by exporting the Access data to a flat file
and push that into a UniVerse Type 19 where you can parse it. There are
third party tools [AD] including mine www.MtOlympus.us [/AD] that can
help you with the data conversion and parsing. If you need an alternate
ODBC driver, you may want to look at Fusionware. I don't recall if they
have something MS Access specific, but I suspect they do.
- Charles Dicing Up the Data Barouch
John Koch-Northrup wrote:
I've been struggling through this one the last few days - any help
would be GREATLY appreciated.
Platform: Dataflo 5.8.4 on Universe 10.0.10 on Win2000 sp 3
(though
I don't think Dataflo is an issue here...)
Previously working state:
Dataflo screen via the Universe BCI module calls ODBC on the server -
in Data Sources (ODBC) System DSN tab I have a pointer to a Microsoft
Access 2000 file.Screen sends an id to the Access database - a
total
number of parts on a reel is returned from the Access database and
placed into the screen. It's been working nicely for about 6
months.
How it was broken:
The system that stores data in the Access file was upgraded on
Thursday. The Access file is now (I believe) at XP level. The
ODBC
connection is broken.
Attempted fix (that failed):
Research on Microsoft's site led me to believe that upgrading to Jet
4.0 sp 8 and MDAC 2.8 would fix the problem. I found an article
(which
I oddly can't find now...) that stated that Access beyond version
2000
no longer had a specific ODBC driver to connect to it - you now
connected through the Oracle driver. Admittedly - I thought that
was
an odd statement and I'm trying to get back to that article and read
it
through again.
At the moment - I have the server sitting with Jet 4.0 sp 8 and MDAC
2.8 - and cannot connect to the Access file correctly. Anyone run
into
something similar?
Thanks!
John Koch-Northrup
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
--
- Charles Barouch
(718) 762-3884 x 1 - Key Ally Voice Mail
[EMAIL PROTECTED] - Consulting services
[EMAIL PROTECTED] - News
[EMAIL PROTECTED] - U2-Users Moderator
[EMAIL PROTECTED]- Zeus Data Integration
Mount Olympus, Home of Zeus Data Integration
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/