Link to home
Start Free TrialLog in
Avatar of pharries
pharries

asked on

"Medical manager" for Unix exporting records to Access or SQL

I need to be able to query the database of this medical program. It runs on a Unix server. i have no idea what kind of database it is. Anyone had any experience exporting records to windows programs for use in Access or SQl. I will need o be able to do this at least daily and preferably dynamically.
thanks
Avatar of jadedata
jadedata
Flag of United States of America image

Hey pharries!

Even Unix/Linus machines have file name extensions.  What do we have on these files

regards
Jack
Avatar of hamidovt
hamidovt

it does not matter what kind of database is it and on which operating system it run, almost 99% of all databases support ODBC connection. Just ask what database it is, and afterwads just check how to connect to it via ODBC. Afterwards you can query whatever you want.

In your case, most probably it will be Oracle. In that case install oracle client, ask what is username/password and DSN and create an entry in your ODBC. Afterwards you can use it from wherever you want, Access, VB, Delphy...
Avatar of pharries

ASKER

The extensions are .dme andd .dmx
I have seen references elsewher o9n the web to Protrader database.
I have been unable to find an ODBC driver.
Thanks
there has to be way to connect via ODBC!!!

find out what database it is for sure and check if they have a website, manual, or something where you can find how to connect via ODBC. 99.99% of databases support ODBC!!!
ASKER CERTIFIED SOLUTION
Avatar of jadedata
jadedata
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
some databases require to install client for ODBC drivers,
I am almost sure there is ODBC driver
Reports in medical manager seem to be to scren or printer only
Anyone know anything on this score?
I know from my providers that there are facilities to output data to files.  Reference tables can be csv'd out, so my presumption is that any of the data tables could be csv'd out somehow.
OK  I will have to check again. it may be an option my locatio does not have
10/23/2003 10:22AM EDT comment clenches this.  
Medical Manager would take a very dim view of any connections to the data files in their systems.
Medical Manager provide file-out function to extract data from their systems.

point jadedata
Assuming your're on ver 9 or ver 10 - it's pretty easy to do.  It uses CTree - so the usual windows stuff won't work.  If your site has rpg or dml (report generator or data merge) - a script can be done to do this.  When I was a med mgr dealer - we wrote many of these scripts.