Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    May 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data source name not found and no default driver specified

    Hi everyone..

    i need help regarding on that error...

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

    /csdpanel/common/index.asp, line 254

    Write here the line 254

    set dbconn=Server.Createobject("ADODB.Connection")
    dbconn.open CLConn
    set dbt=Server.CreateObject("ADODB.Connection")
    dbt.Open "server=localhost;db=platform_12;driver=MySQL;uid=root;pwd=admin"

    My pleasure of any advise.

  • #2
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,928
    Thanks
    46
    Thanked 203 Times in 202 Posts
    OLEDB connection is different from ADODB connection.
    you call out an ADODB but I presume use an OLE DB connection string... idk, this
    server=localhost;db=platform_12;driver=MySQL;uid=root;pwd=admin
    is not a connection string I recognize, but I almost strictly do ADO (and it is not an ADO connection string)

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,652
    Thanks
    80
    Thanked 4,640 Times in 4,602 Posts
    Yes, that is a valid connection string, according to
    http://www.carlprothman.net/Default....DriverForMySQL

    But it's a really really old driver. It's from the days of MySQL version 2.3 or so (roughly 13 or 14 years ago).

    You'd be much better off installing the MyODBC 5.1 driver, especially if you are working with MySQL version 5 or later.

    (Prothman's examples don't show the 5.1 driver, but the connection string is the same except for the name of the driver itself.)
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •