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

C# Á¬½Ó Oracle µÄÆæ¹ÖÎÊÌâ

×î½ü·¢ÏÖ¸öÆæ¹ÖÎÊÌ⣬ÓÐЩ³ÌÐò Á¬½ÓOracle ͻȻ²»ºÃʹÁË
Ìáʾ ¡°ORA-12154: TNS: ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û¡±
ÎҵķþÎñÆ÷×°ÔÚ±¾»úÁË£¬ÎÒ¿ªÊ¼»¹ÒÔΪÊÇ Oracle µÄÎÊÌ⣬ºóÀ´ÎÒн¨¸öÏîÄ¿ÓÃͬÑùµÄÁ¬½Ó×Ö·û´®

m_cnOrclL2.ConnectionString = @"Data Source=orcl;User ID=scott;Password=tiger";
m_cnOrclL2.Open();

¾Í¿ÉÒÔ Í¨¹ý

¶øÏÈǰµÄÏîÄ¿¾Í²»¿ÉÒÔ£¬ÕâÊÇÎªÊ²Ã´ÄØ£¬ÓôÃÆ°¡
ÊǺܾÃûÁ¬½Ó¹ýÁË?

Ó¦¸ÃÊDz»¹æ·¶°É,Õâ¸öûÓÐserverÄØ?
XML code:
<add key="PersistenceSql" value="Database=testdb;Server=WANG\SQLEXPRESS;PWD=123;UID=sa;" />

this just webconfig


°ï¶¥Ï¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

2Â¥µÄÅóÓÑ£¬Äã·¢µÄÊÇʲôµÄ£¬SQL SERVERµÄÂð£¬ÎÒµÄÊÇ Oracle

==============================
ÎÒ·¢ÏÖºÃÏñ»¹ÊÇÏîÄ¿ÎÊÌâ
ÎÒÔÚÕâ¸öÏîÄ¿ÓÖÌí¼ÓÁ˸öÏîÄ¿£¬»¹ÊDz»ÐС£
µ«ÊÇÎÒÓÖÖØÐ¶ÀÁ¢½¨¸öеÄÏîÄ¿£¬¾Í¿ÉÒÔ¡£Ææ¹ÖÁË£¬ÄÇÎÒÏÈǰÄǸöÏîĿҲ²»Äܲ»Òª°¡

²»¹ÜʲôÊý¾Ý¿â¶¼ÊÇÕâô¸öÁ¬½Ó°¡
Äã¸ü¸ÄÕâ¸öÊÔÊÔ°É
C# code:
string ConnectionString = "Database=testdb;Server=WANG\\SQLEXPRESS;PWD=123;UID=sa";


ÊÇÁ¬µÄ±¾µØÊý¾Ý¿â£¬»¹ÊDZðµÄ·þÎñÆ÷£¬±ðµÄ·þÎñÆ÷Òª½¨Ò»¸ö¿Í»§¶ËµÄ¡£
Ҫô¿´ÊDz»ÊÇORACLEµÄ·þÎñÆô¶¯ÆðÀ´ÁË£¡


Ïà¹ØÎÊ´ð£º

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ