General discussion

  • Creator
    Topic
  • #2079489

    INVISIBLE SYSTEM DSN’S

    Locked

    by nickm172 ·

    I am losing my DSN connections, when I try to create a new SYSTEM DSN everything is fine but when I actually try to use it I always get this error:

    Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’

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

    Its not in my code or in the spelling of the DSN names or anything like that because even working ones that have been in place stopped working after I pulled them up in the ODBC config program in control panel. They were working fine till I did that. and now any that I have looked at the configuration of do not work and I can create new onces but every time I try to use it I get the error above. I’ve installed the latest MDAC, re-installed my SP. Articles in MSKB only refernce spelling errors in code. This is not the case because working ones that have been in place for over a year no longer work.

All Comments

  • Author
    Replies
    • #3773598

      INVISIBLE SYSTEM DSN’S

      by alantucker ·

      In reply to INVISIBLE SYSTEM DSN’S

      Nick,

      You don’t say what type of database you’re connecting to. Can you use a DSN-less connection? Here’s an Access example:

      ‘ Create a connection to our database
      Set cxn = Server.CreateObject(“ADODB.Connection”)
      ‘open connection using a connection string
      cxn.Open “driver={Microsoft Access Driver (*.mdb)};;DBQ=C:\Inetpub\wwwroot\yourdb.mdb”

      Although I haven’t done it with an ODBC driver there are many examples of DSN-less connections on the internet. Even though the path to the db is hardcoded in my case it’s still much less of a headache than creating a dsn.

      • #3774868

        INVISIBLE SYSTEM DSN’S

        by nickm172 ·

        In reply to INVISIBLE SYSTEM DSN’S

        Yes DSN-LESS does work but that doesnt really have any reflection on my problem so goes the name DSN-LESS.
        And I am connecting to access databases.

Viewing 0 reply threads