ConString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + StrPath + ";" + "Persist Security Info=True";这个是Access的吧
那要连接oracle的话要怎么写 一样不一样?
å¨NETç¯å¢ä¸é¾æ¥Oracleæ°æ®åºæ两ç§ç»å»ºé¾æ¥æ¹å¼ï¼
1ï¼ä½¿ç¨OleDBç»ä»¶æ¯éè¿Oracle OleDB驱å¨ç¨åºï¼OraOLEDB.dllï¼è¿æ¥å访é®Oracleæ°æ®åº
2ï¼ä½¿ç¨System.Data.OracleClient.dllç»ä»¶ï¼ADO.Netç»ä»¶ï¼
OleDbConnection模å¼:
<add key="ConnectionString" value="Provider=OraOLEDB.Oracle.1;Data Source=orcl;User ID=sysman;Password=sa;Unicode=True"/>
OracleConnection 模å¼:
<add key="orclConnStr" value="Data Source=orcl;User ID=exp;Password=sql;"/>
asp.netä¸oracleè¿æ¥å符串
ããconnectionString="Password=oracleç¨æ·å¯ç ;User ID=oracle ç¨æ·å;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=æå¡å¨IPæè æå¡å¨å称)(PORT=端å£)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=skydream)));"
ããå¦æoracleæ°æ®åºåwebå¨åä¸å°æå¡å¨ä¸å¯ä»¥åæ
ããconnectionString="Password=å¯ç ;User ID=ç¨æ·å;Data Source=æ°æ®åºDB;"
ããä½ ä¹å¯ä»¥å¨C:\oracle\ora92\network\admin\tnsnames.oraï¼oracleå®è£ ç®å½ä¸é¢ï¼ æ¥çé ç½®æ件