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 =
Ïà¹ØÎÊ´ð£º
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØͼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆλÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐÇ°20¸ö·Ö¸øµ ......
ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£
лл
´úÂëÈçÏ£º
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
u ......
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
ÎÒÏë´òÓ¡Êý¾Ý¿âÀïÃæ¶ÁÈ¡³öÀ´µÄ¶àÌõÊý¾ÝÄÚÈÝ£¬ÊµÏÖÅúÁ¿´òÓ¡
Ïȵ¼Èëexcel»òÕßword£¬È»ºóÔÚ´òÓ¡
»òÕß¹ºÂòweb´òÓ¡¿Ø¼þ
ʹÓÃacitvex´òÓ¡¡£Èç¹û²»ÐèҪѡÔñÊôÐÔ£¬ÉèÖÃÊôÐÔ£¬¾Í²»ÐèÒªÉÌÒµµÄÁË¡£
<style media= ......