1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

求助!!!ASP连接MYSQL数据库

Discussion in '后端开发' started by bl220, Apr 8, 2008.

  1. bl220

    bl220 New Member

    Joined:
    Apr 8, 2008
    Messages:
    1
    Likes Received:
    0
    <%
    strconnection="driver={mysql odbc 3.51 driver};server=localhost;uid=bl220;password=000000;database=west_net;stmt=set names bl220"
    set conn = server.createobject("adodb.connection")
    conn.open strconnection
    sql = "select * from user"
    set rs = conn.execute(sql)
    %>
    出现如下错误:
    Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

    [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序

    /const.asp,行 4
    错在哪里呢?该怎么修改?
     
  2. 天寻网络

    天寻网络 New Member

    Joined:
    Apr 9, 2008
    Messages:
    7
    Likes Received:
    0
    ASP要连接MYSQL?搞对还是搞错?

    我只知道 ASP 的连接数据库为 ACC MSSQL
    PHP才是连接MYSQL

    其他数据库的 不知道干什么

    外行 请高手来吧 哈哈
     
  3. ttntt

    ttntt New Member

    Joined:
    Jun 23, 2006
    Messages:
    2
    Likes Received:
    0
    没装 myodbc 怎么能链接的上呢 ?
     
  4. nana001

    nana001 New Member

    Joined:
    May 11, 2008
    Messages:
    18
    Likes Received:
    0
     
  5. wilber

    wilber New Member

    Joined:
    Jun 24, 2008
    Messages:
    12
    Likes Received:
    0
    装MYSQL ODBC链接。
     
  6. wwqqkj

    wwqqkj New Member

    Joined:
    Jun 12, 2008
    Messages:
    50
    Likes Received:
    0
    MYSQL ODBC 哪有下?