Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP²ÉÓÃODBCÊý¾ÝÔ´Á¬½ÓMSSQLÊý¾Ý¿âÏêϸ˵Ã÷¡¾ÊµÓá¿

ODBCÊý¾ÝÔ´¿É·ÖΪ“ϵͳÐÍ”ºÍ“ÎļþÐÍ”£¬ËûÃǵÄÇø±ðÔÚÓړϵͳÐÍ”ÊÇÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢½¨Á¢Ôړϵͳע²á±í”À“ÎļþÐÍ”ÔòÊÇÒÔdsnÎļþÐÎʽ´æ´¢ÔÚODBCÔ´µÄĿ¼ÏÂÃæ
Ò»¡¢½¨Á¢ODBCÊý¾ÝÔ´µÄ·½·¨£º
¿ØÖÆÃæ°å - ¹ÜÀí¹¤¾ß - Êý¾ÝÔ´£¨ODBC£©
´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¬È»ºóÒ»²½²½°´ÕÕÐèÒª½¨Á¢“ϵͳDSN”»òÕß“ÎļþDSN”
(½¨Òé°Ñн¨Á¢µÄÎļþDSN±£´æÔÚODBCÔ´µÄĿ¼ÏÂÃæ£¬±ãÓÚÁ¬½Ó)
¶þ¡¢MSSQLµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®Ð´·¨£º
1¡¢Í¨¹ýoledb½¨Á¢Á¬½Ó
conn.open ""Provider=SQLOLEDB;server=(SQL·þÎñÆ÷Ãû³Æ»òIPµØÖ·);database=Êý¾Ý¿âÃû³Æ;uid=;pwd=""
2¡¢Í¨¹ýdriver½¨Á¢Á¬½Ó
conn.open ""driver={sql server};server=(SQL·þÎñÆ÷Ãû³Æ»òIPµØÖ·);database=Êý¾Ý¿âÃû³Æ;uid=;pwd=""
3¡¢Í¨¹ýODBC DSN½¨Á¢Á¬½Ó
ϵͳDSNÁ¬½Ó
conn.open ""DSN=(ϵͳDSNÃû³Æ);Database=Êý¾Ý¿âÃû³Æ;UID=;PWD=;""
ÎļþDSNÁ¬½Ó1
conn.open ""FileDSN=(ÎļþDSNÃû³Æ.dsn);Database=Êý¾Ý¿âÃû³Æ;UID=;PWD=;""
Àý£ºconn.open ""FileDSN=test.dsn;Database=mytest;UID=test;PWD=1234;""
ÎļþDSNÁ¬½Ó2(°²È«ÐÔ×î¸ß)
---ºÍµÚÒ»ÖÖ·½·¨ÀàËÆ,Ö»Êǽ«ÃÜÂëдÔÚODBCÎļþÖÐ
µÚÒ»²½£¬ÓüÇʱ¾ÐÞ¸ÄdsnÎļþ(ºìÉ«²¿·ÖΪÐèÒªÔö¼ÓµÄ)£º
[ODBC]
DRIVER=SQL Server
UID=test
PWD=1234
Regional=Yes
WSID=KIT-PC
APP=Microsoft Data Access Components
SERVER=(local)
µÚ¶þ²½£¬ÐÞ¸ÄÁ¬½Ó×Ö·û´®£º
conn.open ""FileDSN=(ÎļþDSNÃû³Æ.dsn);Database=Êý¾Ý¿âÃû³Æ;""
Èý¡¢AccessÊý¾Ý¿âÁ¬½Ó×Ö·û´®µÄд·¨
ϵͳDSNÁ¬½Ó
conn.open ""test""
ÎļþDSNÁ¬½Ó
conn.open ""filedsn=test.dsn""
(·¢Ìûʱ¼ä:2005-01-04 14:37:01)
---kittow¡¾³ÌÐòÔ±ÁªÃ˳ÉÔ±¡¿¡¾±à¼­¡¿¡¾»Ø¸´¡¿
¡¾Â¥Ö÷¡¿ (1):µÚÒ»²½£¬ÓüÇʱ¾ÐÞ¸ÄdsnÎļþ(ºìÉ«²¿·ÖΪÐèÒªÔö¼ÓµÄ)£º
[ODBC]
DRIVER=SQL Server
UID=test
PWD=1234
Regional=Yes
WSID=MYPC
APP=Microsoft Data Access Components
SERVER=(local)
ÕâÀïÇë×¢ÒâÊÇÔÚUIDÏÂÃæÌí¼ÓÒ»ÐУº
PWD=1234


Ïà¹ØÎĵµ£º

2¡¢´¿ASP´úÂëÉú³Éͼ±íº¯Êý——Öùͼ

2¡¢´¿ASP´úÂëÉú³Éͼ±íº¯Êý——Öùͼ
<%
dim total(12,2)
total(1,1)=56
total(2,1)=7
total(3,1)=-7
total(4,1)=0
total(5,1)=16
total(6,1)=10
total(7,1)=14
total(8,1)=7
total(9,1)=9
total(10,1)=7
total(11,1)=11
total(12,1)=14
total(1,2)="µØÀí"
total(2,2)="»¯Ñ§"
total(3,2)="ÀúÊ· ......

3¡¢´¿ASP´úÂëÉú³Éͼ±íº¯Êý——ÕÛÏßͼ

3¡¢´¿ASP´úÂëÉú³Éͼ±íº¯Êý——ÕÛÏßͼ
<%dim total(7,3)
total(1,0)="Öйú¾­Óª±¨"
total(2,0)="ÕÐÆ¸Íø"
total(3,0)="51Job"
total(4,0)="ÐÂÃñÍí±¨"
total(5,0)="ÐÂÎÅÍí±¨"
total(6,0)="ÄÏ·½ÖÜÄ©"
total(7,0)="Ñò³ÇÍí±¨"
total(0,1)="#FF0000,1.5,1,2,¹«Ë¾1"'²ÎÊý1ÏßÌõµÄÑÕÉ«£¬²ÎÊý2ÏßÌõµÄ¿í¶È£¬²ÎÊý3Ï ......

ÓÃASPËæ»ú²úÉúËæ»úÊý

<%
Function gen_key(digits)
'Create and define array
dim char_array(50)
char_array(0) = "0"
char_array(1) = "1"
char_array(2) = "2"
char_array(3) = "3"
char_array(4) = "4"
char_array(5) = "5"
char_array(6) = "6"
char_array(7) = "7"
char_array(8) = "8"
char_array(9) = "9"
char_array( ......

ASPÏîÄ¿ÖеĹ«¹²·­Ò³Ä£¿é

ÔÚ´óÐ͵ÄASPÏîÄ¿ÖУ¬ºÜ¶àµÄÒ³Ãæ¶¼Éæ¼°µ½·­Ò³¹¦ÄÜ¡£Èç¹ûÿ¸öÒ³Ãæ¶¼Ð´Ò»¸ö·­Ò³µÄ³ÌÐòµÄ»°£¬ÕâÑùµÄ¹¤×÷¼´½µµÍÁ˹¤×÷Ч
ÂÊ£¬Ò²²»ÀûÓÚ¹¤³ÌµÄÄ£¿é»¯£¬²»ÄÜʹ´úÂëÖØÓá£Òò´Ë£¬°Ñ·­Ò³ÕâÑùµÄ¹¦ÄÜÄ£¿é»¯ÊǺÜÓбØÒªµÄ¡£
¡¡¡¡Éè¼Æ·½·¨£º
¡¡¡¡1¡¢µ÷ÓøÃÄ£¿éʱ£¬Ö»ÐèÒª´«µÝ¼Ç¼¼¯ºÍÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£»
¡¡¡¡2¡¢¿ÉÒÔµã»÷Á´½Ó½øÐз­ ......

c# ²Ù×÷mssqlÊý¾Ý¿â º¬Óдø²ÎÊýsqlÓï¾äÔËÐÐ

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
  <add key="Default" value="Default" />
 </appSettings>
 <connectionStrings>
  <add name="Default" connectionString="Data Source=192.168.1.197;User ID ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ