×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

help me ,a problem in ASP

when i use ASP programming, i use the following :

Set conn=Server.CreateObject("ADODB.Connection")
Conn.open "dsn=benix; ;"

because i access the SQL2000 by the way i access the win2000, i don't need userid and pass word for SQL2000

however, when i run the software, it tells me the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/benix/choice.asp, line 14

who call tell me how to do? thanks a lot
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / help me ,a problem in ASP
    when i use ASP programming, i use the following :

    Set conn=Server.CreateObject("ADODB.Connection")
    Conn.open "dsn=benix; ;"

    because i access the SQL2000 by the way i access the win2000, i don't need userid and pass word for SQL2000

    however, when i run the software, it tells me the following error:

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    /benix/choice.asp, line 14

    who call tell me how to do? thanks a lot
    • dsn=benix; Did you define this in ODBC?
      • Yes, I have defined it in ODBC. I have used this DSN in VC++ to create a recordset. can you give me a example for connecting SQL2000 by ASP?