ASPÁ¬½ÓSQL2005³öÏÖÎÊÌâ,Çë¸ßÊÖ°ïæ

<% dim conn
set conn=server.createobject("adodb.connection;)
sql="provide=sqloledb;data source=aaa;uid=aaa;pwd=aaa;initial catalog=aaa"
conn.open sql
%>
ÔËÐкó³öÏÖ´íÎó
´íÎóÀàÐÍ:
microsoft ole db provider for odbc drivers(0x80004005)
[microsoft][odbc Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò


²âÊÔÓõÄSQL·þÎñÆ÷¶ËÔÚ±¾µØ,±£Ö¤¿ªÆôµÄÇé¿öÏÂ,Óû§Ãû,ÃÜÂë,Êý¾Ý¿âÃû¶¼ÕýÈ·,Ϊʲô»á±¨ÕâÑùµÄ´íÎó,Çë¸ßÊÖ°ïæ¿´ÏÂ

---

ʲô°æ±¾µÄSQL 2005?

---

ÊÔÊÔÎÒÕâ¸ö:
VBScript code:

Dim conn,connectionstring
set conn=server.createobject("adodb.connection")
connectionstring="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=JUJUMAO;DATABASE=yt;UID=sa;PWD=sa;"
conn.open connectionstring

---

<% dim conn
set conn=server.createobject("adodb.connection;)
sql="provide=sqloledb;data source=(local);uid=aaa;pwd=aaa;initial catalog=aaa"
conn.open sql
%>
ÕâÑùÊÔÊÔ

---

ÒýÓÃ

<% dim conn
set conn=server.createobject("adodb.connection;)
sql="provide=sqloledb;data source=(local);uid=aaa;pwd=aaa;initial catalog=aaa"
conn.open sql
%>
ÕâÑùÊÔÊÔ

û·¢ÏÖLZµÄdata sourceд´íÁË