Welcome to SynapseDirect Sign in | Join | Help
in Search

SynapseDirect

ODBC Install

Last post 06-26-2008, 7:38 AM by Jason. 20 replies.
Page 1 of 2 (21 items)   1 2 Next >
Sort Posts: Previous Next
  •  09-20-2006, 2:54 PM 667

    ODBC Install

    I am trying to go through the install but have hit a bump. I downloaded the full installer and ran it, it seemed to install with no errors. Attempting to run Synapse EMR Server afterwards yielded the message that it couldn't connect to the database. I checked Firebird, it was installed and the service was running. I checked ODBC system DSN's and there were none so I attempted to add it manually. That's when I found that the Firebird/Interbase drivers weren't loaded. I went and downloaded the Firebird ODBC install and ran it. The driver still didn't show up in odbc. I uninstalled, reinstalled rebooted but it still wont show. I looked in the registry under the ODBC section and everything is there, I checked the files in the system32 folder and they are there. For some reason XP is rejecting these drivers. This is a new machine with XP Pro SP2. I know that this isn't Firebird support but I am looking for some clues.
  •  09-20-2006, 3:28 PM 668 in reply to 667

    Re: ODBC Install

    hmmm. I'll have to think about that one.

    A Firebird Newbie like me installed the ODBC drivers and Firebird without problems.  I did the manual install. I have tried Windows 2000 SP4 - no problems, Windows XP SP2 - no problems.

    Q1: did you try a reboot ? (oops I see you tried that)

    Do these pictures help you ?

    Q2: did you ADD the firebird/interBase driver ?  You have to install it and then ADD it.




    Developer
    Filed under:
  •  09-20-2006, 3:30 PM 669 in reply to 668

    Re: ODBC Install

    You certainly sound thorough and knowledgeable, I'm sure Graham or Nick could help you.

    Did you check this out ?

    http://synapsedirect.com/forums/thread/114.aspx

     

     



    Developer
  •  09-20-2006, 4:47 PM 672 in reply to 667

    Re: ODBC Install

    Anonymous:
    I am trying to go through the install but have hit a bump. I downloaded the full installer and ran it, it seemed to install with no errors. Attempting to run Synapse EMR Server afterwards yielded the message that it couldn't connect to the database. I checked Firebird, it was installed and the service was running.

    This sounds good. 


    I checked ODBC system DSN's and there were none so I attempted to add it manually. That's when I found that the Firebird/Interbase drivers

    The installer doesn't create an entry in the system DSNs .. but the changes I think are made in the registry.  But the fact that the Firebird/Interbase drive is not loaded is not good. 

     

    weren't loaded. I went and downloaded the Firebird ODBC install and ran it. The driver still didn't show up in odbc. I uninstalled, reinstalled rebooted but it still wont show. I looked in the registry under the ODBC section and everything is there, I checked the files in the system32 folder and they are there. For some reason XP is rejecting these drivers. This is a new machine with XP Pro SP2. I know that this isn't Firebird support but I am looking for some clues.

    I've installed under XP Pro SP2 with no problems.

    What I suggest you do is try a manual install. 

    1. Use system restore to roll back to before you ran the installer,
    2. then install Firebird first
    3. install ODBC
    4. create the system DSN next linking to the "blank" remr.fdb database which is placed preferably in it's own directory
    5. and check that it connects
    6. and then run Synapse-server EMR.  It will tell you if it can't connect.

    Let us know how you get on ... 

     

     


    Graham Chiu
    Beta Downloads and Documentation Wiki
    Developer Forum
    Filed under:
  •  09-21-2006, 5:51 AM 675 in reply to 672

    Re: ODBC Install

    Dear Anonymous ( it would be good to have a name here ! )

    Your problem has been reproduced by the team that built the installer ...and they will attempt to find a fix.

    In the meantime, I suggest you do the manual install as mentioned above, and as depicted in the online movies.

    If you need more help ... register, and ask away!
     


    Graham Chiu
    Beta Downloads and Documentation Wiki
    Developer Forum
    Filed under:
  •  09-21-2006, 2:05 PM 678 in reply to 675

    Re: ODBC Install

    We've got a fix on the ODBC System DSN. This was passed last thing this afternoon and will hit this site early tomorrow a.m. Please check back on this thread tomorrow for confirmation of upload.

     Nick.
     


    Nick
  •  09-21-2006, 4:12 PM 679 in reply to 678

    Re: ODBC Install

    Hi Nick,

    Fixed already ?  Nice.

    I suppose it's kinda too bad about the Mega Installer for this chap as he would have BREEZED through the manual install.

    Maybe for the advanced user, the manual install might be more predictable.

    :)

    Although the Mega Installer is really convenient.

    :)

     



    Developer
    Filed under:
  •  09-22-2006, 2:51 AM 683 in reply to 679

    Re: ODBC Install

    We've uploaded a corrected Synapse EMR Server InstallShield package. This now correctly deploys the FireBird ODBC drivers and ODBC settings to the FireBird database. Use this installer for new installations of Synapse EMR Server.

    Nick
  •  01-15-2007, 5:16 PM 2166 in reply to 683

    Re: ODBC Install

    Nick Harrington:
    We've uploaded a corrected Synapse EMR Server InstallShield package. This now correctly deploys the FireBird ODBC drivers and ODBC settings to the FireBird database. Use this installer for new installations of Synapse EMR Server.

     

    I ran the Synapse EMR Server installer and ran into the same problems.

    Now I can't install manually.

    I get this:

     




    Developer
  •  01-15-2007, 6:46 PM 2170 in reply to 2166

    Re: ODBC Install

    If the ODBC installer fails, you can do a manual install.  This basically means dropping the dlls into system32 and altering the registry.

    Here's a capture of my registry changes

     


    Graham Chiu
    Beta Downloads and Documentation Wiki
    Developer Forum
  •  01-27-2007, 10:12 AM 2521 in reply to 683

    Re: ODBC Install

    Anybody know of an firebird ODBC driver for WIndows XP x64?  Tried to install the current one manually, doesn't work.
    Contributing
  •  01-27-2007, 12:19 PM 2524 in reply to 2521

    Re: ODBC Install

    qilin:
    Anybody know of an firebird ODBC driver for WIndows XP x64?  Tried to install the current one manually, doesn't work.

    Not I.

    I dont use 64 bit windows XP for these compatibility reasons. 



    Developer
  •  05-07-2007, 12:07 AM 3625 in reply to 2170

    Re: ODBC Install

    I have been trying to get back up and running for the last week, but I have been having the hardest time.  I am sure there is something elemental I am missing like before when I had forgotten I had started over.  Well this time started out with me remembering that fact and then I received the server too old and was directed to the website downloads, but I kept getting the same message - finally I found the beta download site and was able to at least get somewhere.  Then I got message about odbcjdbc.dll failed with 6 invalid handle.  I kept deleting and redownloading thinking I must have done something wrong.  I have downloaded and reinstalled everything so many times I have lost track.  I searched the forums and came across this thread, but I can't figure out how to drop the dll file into a registry I can't find.  I did check the system32 and found an odbcjdbc.dll file from december.  However, the administrative site says I do not have the firebird driver installed and is not in the registry. 

    I feel really frustrated...help.

  •  10-29-2007, 3:26 AM 4497 in reply to 3625

    Re: ODBC Install

    Just found this message in the to be moderated message list .. no idea why it turned up there.

    I guess you either got it going by now ... or have moved on.  But repeated installing/uninstalling is likely to have caused your problems.  In this situation I would roll the PC back using system restore and do a complete new installation. 


    Graham Chiu
    Beta Downloads and Documentation Wiki
    Developer Forum
  •  05-08-2008, 4:59 AM 5793 in reply to 4497

    Re: ODBC Install

    OK, sorry to re-open this thread, but...

    I am new to Synapse Direct, and have been trying to install the server.  I spent about 4 hours last night and cannot get the ODBC database connection set up correctly.  I have downloaded and installed the Firebird program (but I'm not sure whether to run it as an "application" or a "service" -- tried both ways).  I have downloaded and installed the ODBC driver.  But when I go to the control panel to setup the driver, I find that the ODBC driver already shows up under System DSN tab, and when I try to configure it, it already has the info filled in.  I just changed the line to point to where the database is actually saved.  But when I test the connection, I get a message that it failed everytime.  I have done everything I can think of, including a system restore to back before I started all this.  Oh, and for some reason I could not download the blank database...I could only get the full database.  Not sure if that makes a difference.

     I am running Windows Vista Ultimate on a brand new machine with 4 gigs RAM, Intel Core Duo processor at 2.66 gHz, so I don't think it is a hardware issue.  I'm not a computer tech person so maybe this is just too much for me.  If anyone can help I would really appreciate it.

    Michael Franklin, PA-C

    Concord, NC, USA

Page 1 of 2 (21 items)   1 2 Next >
View as RSS news feed in XML
Try-out the Click to try-out Synapse EMR Express Edition Free Synapse EMR Express Edition Click to try-out Synapse EMR Express Edition · ©2006 SynapseDirect · Terms and Conditions · Privacy Policy · help us keep Synapse EMR Express free for all Doctors

managing your electronic medical records · Unique Visits Dell Computer