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¸ö·Ö¸øµ ......
owc11Âú×ã²»ÁËÒªÇó£¬ÓÐûÓиüºÃµãµÄ£¬aspÄܵ÷ÓõÄ
Ŀǰû·¢ÏÖ£¬°ïÄã¶¥£¡
Ó¦¸ÃûÓÐÁ˰É
×ÔÒÑд¡£¶¥
°ï¶¥£¬¹Ø×¢£¡
ºÃÏñ¾ÍÕâ¸öÁË£¬Ä¿Ç°»¹Ã»¿´µ½ÆäËûµÃÉÏÊÐʹÓᣡ£¡£°ï¶¥£¡
×Ô¼ºÔÙ¶¥Ò»ÏÂ
ºÃÏñÊÇûÓÐ ......
c#.NET ÃæÊÔÒ»°ã¶¼¿´Ê²Ã´Êé??
ÓÐÒ»±¾ .NET ÃæÊÔ±¦µâ ²»ÖªµÀÈçºÎ??
ÊDz»ÊÇÒª°ÑÍøÉϵıÊÊÔÌâÄ¿¶¼±³Í¨±³ÊìÁ˲ÅÄܹý±ÊÊÔ¹Ø,
ÒªÊDZ³´ð°¸,È˼ÒÓÖ˵ÄãÊÇÊÂÏȱ³ÏÂÀ´µÄ,ÓÖ²»ÏàÐÅÄã
ÿ´Î¶¼ËÀÔ ......
asp ÎÒ²»Õ¦¸ö¶«£¬ÎÒÊÇ×öasp.netµÄµ«ÊÇǰÕß¿´¶®Ó¦¸ÃûÓÐÎÊÌ⣬ÎÒÔÙά»¤Ç°ÃæµÄÒ»¸öÍøÕ¾£¬µ«ÊÇ£¬½ñÌìÎÒÒ²²»ÖªµÀÊÇÔõô¶¯ÁË·þÎñÆ÷ºÍÊý¾Ý¿â£¬µ¼ÖÂÎÒaspÒ³ÃæÃ»ÓÐʹÓÃÊÓͼֱ½Ó´Ó±íÖлñµÃµÄÊý¾ÝÕý³£ÏÔʾ£¬¶øÄÇЩʹÓÃÁËÊÓͼÀ´ ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......