主机名
参考连接大全:
Oracle
ODBC
New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"
OLEDB, OleDbConnection (.NET)
Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
OracleConnection (.NET)
Standard:
"Data Source=Oracle8i;Integrated Security=yes";
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open(); VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()
Data Shape
MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
参考连接大全:
Oracle
ODBC
New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"
OLEDB, OleDbConnection (.NET)
Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
OracleConnection (.NET)
Standard:
"Data Source=Oracle8i;Integrated Security=yes";
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open(); VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()
Data Shape
MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"
解决方案 »
- 关于jquery如何验证radio的问题
- |zyciis| 基础问题:Session 和 Cache 存放和读取的区别 还有
- 用水晶报表还需要输入用户名和密码吗?
- 初次用Asp.Net 2.0做东西,头疼啊,界面布局和美化到底怎么办???
- 555,怎么这么多奇怪问题啊!提交时有汉字就说字段为空!!!
- 若要支持vmlscript,是不是要将网站配置成WAp网站,若是,怎么配置?
- 请大家推荐“开发Web服务器控件”方面的文章,多谢!
- 求SQL查询语句!
- 请教Asp.net做的网页如何上传到空间中????????????
- ASP.Net 如何与SQL数据库相连
- 固定资产管理系统中的这个问题如何用asp.net来实现?
- 请教大家:有没有不通过File Field控件上传文件的办法?或者动态构造File Field并给它赋值的方法?
conn.ConnectionString = "Provider='MSDAORA.1';User ID=aaa;Data Source=aaa;Password=aaa"
conn.Open()
出错
Oracle error occurred, but error message could not be retrieved from Oracle
为什么用OracleConnection的时候没出错
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;" msdaora和OraOLEDB.Oracle什么区别?
Dim conn As New System.Data.OracleClient.OracleConnection
conn.ConnectionString = "user id=aaa;data source=myOracle;password=aaa"
conn.Open()
改成这个就出错:
Dim conn As New OleDb.OleDbConnection
conn.ConnectionString = "Provider=msdaora;User ID=aaa;Data Source=myOracle;Password=aaa"
conn.Open()
出错信息:
Oracle error occurred, but error message could not be retrieved from Oracle
请问是哪儿错了呢?