asp/asp.netÁ¬½Ósql anywhereÊý¾Ý¿â
<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_stud"
set rs=conn.Execute("sql")
response.write rs
%>
string connStr = "Provider=SAOLEDB.10;uid=dba;pwd=sql;Links=TcpIp(host=192.168.1.2;serverport=2638);eng=mysadb";
OleDbConnection oleConn = new OleDbConnection(connStr);
OleDbCommand oleComm = new OleDbCommand("select count(*) from t_test");
oleComm.Connection = oleConn;
oleConn.Open();
Response.Write(oleComm.ExecuteScalar());
oleConn.Close();
ÆäÖÐÒªµã£¨¾¶à·½³¢ÊԵóö£©£º°ÑSql anywhereĿ¼win32ÏÂdboledb10.dll£¨°æ±¾Îª10.0.1£©¡¢dboledba10.dll£¨°æ±¾Îª10.0.1£©×¢²áregsvr32 ....
Èç¹ûc:\windows\system32ÏÂûÓÐÕâÁ½¸öÎļþÔò½«Æ临ÖƹýÈ¥¡£²âÊÔ10.0.0°æasp.net²»¿ÉÓÃ×ÜÌáʾSAOLEDBδע²á,winform¿ÉÒÔ£¬±ØÐëΪ10.0.1
Ïà¹ØÎĵµ£º
sysforeignkeys
°üº¬¹ØÓÚ±í¶¨ÒåÖÐµÄ FOREIGN KEY Ô¼ÊøµÄÐÅÏ¢¡£¸Ã±í´æ´¢ÔÚÿ¸öÊý¾Ý¿âÖС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
constid int FOREIGN KEY Ô¼ÊøµÄ ID¡£
fkeyid int ¾ßÓÐ FOREIGN KEY Ô¼ÊøµÄ±í¶ÔÏó ID¡£
rkeyid int ÔÚ FOREIGN KEY Ô¼ÊøÖÐÒýÓõıí¶ÔÏó ID¡£
fkey smallint ......
SQL Server 2005µÄжÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßжÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏжÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öÊ°빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØжÔع¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.mic ......
ºú»Ô£º13028803715 0755-82945017
9¡¢ÉîÛÚmicrosoft Windows 2003 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§ 4100
10¡¢ÉîÛÚmicrosoft Windws 2003 Server±¨¼Û ÖÐÎÄÆóÒµ°æ25Óû§ 20500
11¡¢ÉîÛÚmicrosoft Windows 2008 Server±¨¼Û ÖÐÎıê×¼°æ5Óû§ 580 ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£ ......