asp»¹ÊÇÁ¬½Ó²»Éϲ»mssql 2008
connstr = "driver={SQL Server};server=127.0.0.1;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Ìáʾ
Óû§ 'sa' µÇ¼ʧ°Ü¡£
ÎÒÓÃodbc×öÁËÁ½¸öÊý¾ÝÔ´
connstr = "driver={SQL Server};dsn=test;server=127.0.0.1;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Ìáʾ
Óû§ 'sa' µÇ¼ʧ°Ü¡£
Êý¾Ý¿âÔÚ±¾»ú
Êý¾Ý¿âµÄÃû³ÆYSERVER\SQLEXPRESS
ÏëÎÊÏÂÊDz»ÊǵÃÏÈÅäÖÃÒ»¸öODBCÊý¾ÝÔ´£¬»¹ÊÇserverÊÇip+Êý¾Ý¿âÃû³Æ
connstr = "driver={SQL Server};server=127.0.0.1\YSERVER\SQLEXPRESS
;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Á¬½ÓÒ²ÊÇÌáʾ´íÎó
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø
mssql 2008ÅäÖÃÁËÔÊÐíÔ¶³ÌÁ¬½ÓÁËÂð£¿ÅäÖù¤¾ßÖÐtcpipÐÒéÊÇ·ñÆôÓã¬tcpipÐÒéÊôÐÔÖÐÊÇ·ñÆôÓÃÁ˹̶¨¶Ë¿Ú1433?
2008µÄ¿í¿ÚÊÇ1433£¿Â¥ÉϵĴíÁË°É£¿
2000µÄ¶Ë¿Ú²ÅÊÇ1433
2008µÄµÄtcp/ipµÄ¶Ë¿ÚÒªÉèÖÃÁ½¸öip ÎÒ¶¼ÉèÖÃΪ1433
Äã²»ÓÃIPÁ¬½Ó ÓÃLOCALLÁ¬½Ó
Ïà¹ØÎÊ´ð£º
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......
ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£
Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð?
²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ
»¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......