aspÓësqlserverÊý¾Ý¿âÁ¬½ÓÎÊÌâ
aspÎÞ·¨ºÍsqlserverÁ¬½Ó ´íÎóÌáʾ
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server ²»´æÔÚ»ò¾Ü¾ø·ÃÎÊ¡£
¼ÇµÃÒÔǰ°²×°sqlserverµÄʱºò »áÌáʾ ÊäÈëÓû§ÃûºÍÃÜÂë Õâ´Î°²×°ºÃÏñÊÇÖ±½Ó°²×°ÁË
Èç¹ûÖ±½ÓÓÃsa Óû§µÇ½ ÊÇ¿ÉÒ﵀ µ«ÔÚasp³ÌÐòÖÐÈ´²»ÐÐ Á¬½Ó´úÂëûÓÐÎÊÌâµÄ ÔÚ±ðµÄ»úÆ÷ÉÏÐÐ
Ó¦¸ÃÔõôÑù°ÑsaÕâ¸öÓû§ ºÍµ¼ÈëµÄÊý¾Ý¿â¹ØÁªÆðÀ´ ÈÃasp³ÌÐò¿ÉÒÔ·ÃÎÊ
Á¬½Ó×Ö·û´®ÖÐµÄ server=¼ÆËã»úÃû»òIP
Èç¹û³ÌÐòºÍÊý¾Ý¿âÔÚͬһ̨µçÄÔÉÏ£¬¾ÍÓà server=(local) »ò server=.
Èç¹û²»ÔÚͬһ·þÎñÆ÷£¬¾ÍÓà server=ip
Á¬½Ó×Ö·ûûÎÊÌâµÄ°¡ sqlserverÊý¾Ý¿âÉÏÉèÖÃÓÐÎÊÌâ°¡
°ÑÁ¬½Ó Êý¾Ý¿âµÄ×Ö·û´®·¢ÉÏÀ´
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,ConnStr,Conn
SqlDatabaseName = "lll@.mdb"
SqlUsername = "sa"
SqlPassword = "82257649"
SqlLocalName = "127.0.0.1"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Set dbconn =
Ïà¹ØÎÊ´ð£º
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º
test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺
Response.Write(Test.GetDate());
TestÀàÈçÏ£º
public class Test
{
static string dt="";
public static s ......
<script type="text/javascript" src="js/Dialog.js"></script>
<script type="text/javascript">
function zOpenD()
{
va ......
ÎÒÏë´òÓ¡Êý¾Ý¿âÀïÃæ¶ÁÈ¡³öÀ´µÄ¶àÌõÊý¾ÝÄÚÈÝ£¬ÊµÏÖÅúÁ¿´òÓ¡
Ïȵ¼Èëexcel»òÕßword£¬È»ºóÔÚ´òÓ¡
»òÕß¹ºÂòweb´òÓ¡¿Ø¼þ
ʹÓÃacitvex´òÓ¡¡£Èç¹û²»ÐèҪѡÔñÊôÐÔ£¬ÉèÖÃÊôÐÔ£¬¾Í²»ÐèÒªÉÌÒµµÄÁË¡£
<style media= ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......