如何访问 oracle7

[Jarod]

公司的管理软件基于oracle 7数据库（现在都9i了）
Version 7.3.2.2.0—Production
Personal Oracle7 for Windows 95
windows 98


网上的事例都是8i、9i的,请问如何写oracle7的连接字符串
其它还有什么不同的地方？



请详细些！
谢谢

[brightheroes]

看看直接用9i的连接字符串可以吗？

[91bct]

看看用OleDbDataAdapter向导连接后产生的ConnectionString

[sjzwinfor]

public void ConnectToOracle()
{
OracleClient.OracleConnection conn =
new OracleClient.OracleConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
conn.ConnectionString = "Data Source=" +
"<oracle data source name>;Integrated Security=yes";
try
{
conn.Open();
// Insert code to process data.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}

[nedvedlh]

<appSettings>
<!-- 此处显示用户应用程序和配置的属性设置。-->
<!-- 示例：<add key="settingName" value="settingValue"/> -->
<!--<add key="connectstring" value="provider=MSDAORA;Data Source=xxwgl;User ID=xxwgl_sa;Password=xxwgl"/> -->
<add key="connectstring" value=" Provider = msdaora;Data Source =xxwgl;User Id = xxwgl_sa;Password = xxwgl"/>
<add key="ConnXxwgl" value=" Provider = msdaora;Data Source =xxwgl;User Id = xxwgl_sa;Password = xxwgl"/>
<add key="connectmispt" value="provider=MSDAORA;Data Source=jqsmis;User ID=pt_sa;Password=ptmanager"/>
<add key="path" value="C:\\Inetpub\\wwwroot\\xxwgl"/>


</appSettings>
以上在webconfig设置
OleDbConnection Conxxwgl = new OleDbConnection(ConfigurationSettings.AppSettings["ConnXxwgl"]);
string StrInsertInfo = "insert into xxwt_bm_dw (dwdh,dwmc) values('" + dwdh + "','" + dwmc + "')";
OleDbCommand OlecmdInfo = new OleDbCommand(StrInsertInfo,Conxxwgl);
Conxxwgl.Open();
OlecmdInfo.ExecuteNonQuery();

Conxxwgl.Close();

[Jarod]

不好意思对oracle不了解

有多个表名相同 Owner 不同
如何指定是那个表
如:
name Owner
S_Main s1
S_Main s2
S_Main s3

Local Database Properties
General
name:Local Database
type:personal oracle7 Database
connection
Username : po3
Password: ***
setting
Display objects by :Object type

-------------------------------