Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-10-22
14
Medium Priority
?
1,763 Views
Last Modified: 2013-12-03
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
0
Comment
Question by:pharries
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 3
  • +1
14 Comments
 
LVL 32

Expert Comment

by:jadedata
ID: 9603875
Hey pharries!

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

regards
Jack
0
 
LVL 4

Expert Comment

by:hamidovt
ID: 9605254
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...
0
 

Author Comment

by:pharries
ID: 9606863
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
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 4

Expert Comment

by:hamidovt
ID: 9606935
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!!!
0
 
LVL 32

Accepted Solution

by:
jadedata earned 2000 total points
ID: 9606942
I was afraid of that,.... those are proprietary data files for the Medical Manager Software.  I don't think you're going to be finding an ODBC driver for this one.  

This is a commercial application that you can void the warranty on, or worse yet violate the "Rights To Use" agreement with Medical Manager.  I would think this through VERY carefully before going any further.  Medical Manager software has reports from which you can virtually export all the related data fields in the major (non-system) tables.  You NEED to use these as your first attempt or you could find your company's "Right to Use" the software has been rescinded.  Can you say "Up the creek without a paddle???"
0
 
LVL 4

Expert Comment

by:hamidovt
ID: 9606944
some databases require to install client for ODBC drivers,
I am almost sure there is ODBC driver
0
 

Author Comment

by:pharries
ID: 9610712
Reports in medical manager seem to be to scren or printer only
Anyone know anything on this score?
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9610795
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.
0
 

Author Comment

by:pharries
ID: 9611976
OK  I will have to check again. it may be an option my locatio does not have
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10907689
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
0
 

Expert Comment

by:ComputerDoug
ID: 25715518
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.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question