none
ODBC Driver Error RRS feed

  • Question

  • Hello.  We just purchased new computers with Windows 7, and have run into many issues with the program called Sportspak, which is housed on our SQL server, running Windows SQL 2003.  We were able to run the program in Administrator Mode, but cannot access some of the features on the program.  The program worked fine in Windows XP.

    The error is:

    [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified.

    This error occurs when we try to access database portions of the program.  Any help or direction would be greatly appreciated.  Thank you

    Dan

    Tuesday, October 19, 2010 4:12 PM

Answers

  • www.connectionstrings.com :)

    Application in question must save its connection string information somewhere, either in registery, ini file, etc...

    Mohit.


    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    • Marked as answer by KJian_ Thursday, October 28, 2010 6:39 AM
    Tuesday, October 19, 2010 6:42 PM

All replies

  • You are most likely missing the system DSN.  If you check out your XP Workstation it works on under ODBC Manager -> System DSN.  It should have an entry in there pointing to your SQL Server/Database.  Make a similar entry on your Windows 7 box.
    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    Tuesday, October 19, 2010 5:26 PM
  • Thank you for the reply.  DSN entries are the same on both machines.
    Tuesday, October 19, 2010 5:48 PM
  • Then I would check your connection strings, either the DNS is not spelled correctly in there; or the drive name is wrong.

    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    Tuesday, October 19, 2010 6:06 PM
  • Might you be able to point my in the direction of a good how-to check connection strings?  I have never done it before.  Thank you for all your assistance.
    Tuesday, October 19, 2010 6:40 PM
  • www.connectionstrings.com :)

    Application in question must save its connection string information somewhere, either in registery, ini file, etc...

    Mohit.


    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    • Marked as answer by KJian_ Thursday, October 28, 2010 6:39 AM
    Tuesday, October 19, 2010 6:42 PM