×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

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?