vs2005 Á¬½ÓOracle 8
´úÂëÈçÏÂ
C# code:
public DataSet ExecuteSql(string CommandText)
{
DataSet ds = new DataSet();
//
string ConnectionString = "Server=*.*.*.*;Data Source=dsour;user=uname;password=upsw";//дÁ¬½Ó´®
OracleConnection OracleConn = new OracleConnection(ConnectionString);
OracleConn.Open();
//try
//{
SqlDataAdapter da = new SqlDataAdapter(CommandText, ConnectionString);
[color=#FF0000]da.Fill(ds);[/color]
return ds;
//}
//catch
//{
// MessageBox.Show("Êý¾Ý¶ÁÈ¡´íÎó£¡", " Ìáʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
// ds.Tables.Add();
// return ds;
//}
}
ÔËÐеÄʱºò ºìÉ«µØ·½±¨´í
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL
лл´ó¼Ò£¡£¡£¡ ¼±~
Ϊɶ£¿ Ã÷Ã÷ÊÇOracle °¡£¡ ¶øÇÒ ±¾»úÓÃsqlplus Á¬½ÓÒ»µãÎÊÌâûÓУ¡
O_O ´úÂëûÏÔʾ³öºìÉ«. ²¹³äÒ
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......