Oracle XE DBconnection from ASPX (转载) - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DotNet - 窗口里的风景

Oracle XE DBconnection from ASPX (转载)

Oracle XE DBconnection from ASPX (转载)# DotNet - 窗口里的风景

i*p2007-05-21 07:05

1 楼

【以下文字转载自 Database 讨论区】
发信人: isup (No), 信区: Database
标题: Oracle XE DBconnection from APSX
发信站: BBS 未名空间站 (Mon May 21 19:03:54 2007)
Could anyone show me the piece of code for ASPX (C# and/or VB) to access
Oracle XE?
Thanks.

y*o2007-05-21 07:05

2 楼

This is what I did.
// In web.config:

providerName="System.Data.OracleClient" />
providerName="System.Data.SqlClient" />

...
// End
// In aspx file:

【在 i**p 的大作中提到】

: 【以下文字转载自 Database 讨论区】
: 发信人: isup (No), 信区: Database
: 标题: Oracle XE DBconnection from APSX
: 发信站: BBS 未名空间站 (Mon May 21 19:03:54 2007)
: Could anyone show me the piece of code for ASPX (C# and/or VB) to access
: Oracle XE?
: Thanks.

b*u2007-05-21 07:05

3 楼

you can find examples of different connection strings here.
http://www.connectionstrings.com/

i*p2007-05-21 07:05

4 楼

Can I use ODP.net with .NET framework and Web Matrix? What do I need to
download?
Oracle website says to use it with Visual Studio .NET.

【在 b****u 的大作中提到】

: you can find examples of different connection strings here.
: http://www.connectionstrings.com/

b*u2007-05-21 07:05

5 楼

not familiar with oracle, is ODP.net a .net library provided by oracle?

i*p2007-05-21 07:05

6 楼

I think so.

【在 b****u 的大作中提到】

: not familiar with oracle, is ODP.net a .net library provided by oracle?

i*p2007-05-21 07:05

7 楼

Thank you!
But I don't think you have accessed DB in your ASPX part of code. Cuuld you
show me your code to run "select" command?
Is that something like SqlDataSource1.Select()?

local
True"
MyCompute

【在 y********o 的大作中提到】

: This is what I did.
: // In web.config:
:
: : providerName="System.Data.OracleClient" />
: : providerName="System.Data.SqlClient" />
:

y*o2007-05-21 07:05

8 楼

Why? I have SelectCommand="select blah blah " in the ASPX file. Please che
ck my original reply and verify.

you

【在 i**p 的大作中提到】

: Thank you!
: But I don't think you have accessed DB in your ASPX part of code. Cuuld you
: show me your code to run "select" command?
: Is that something like SqlDataSource1.Select()?
:
: local
: True"
: MyCompute

i*p2007-05-21 07:05

9 楼

I may not understand how your code work. I am used to run conn.open and the
like. But it seems it is not necessary to run it in your method. Is your
method named ODP.NET?

che

【在 y********o 的大作中提到】

: Why? I have SelectCommand="select blah blah " in the ASPX file. Please che
: ck my original reply and verify.
:
: you

y*o2007-05-21 07:05

10 楼

So, you wanna open the connection in your code-behind?
For oracle, do this:
Instantiate an OracleDataSource object and pass your db user name and passow
rd as well as the network protocol to its setter methods, like so:
OracleDataSource ods = new OracleDataSource();
ods.setUser(dbUser); // e.g. "hr"
ods.setPassword(dbPassword); // e.g. "hr"
ods.setDriverType(driverType); // e.g. "oci8"
ods.setNetworkProtocol(networkProtocol); // e.g. "ipc"
And then you say,
Connection conn = ods.getConnection(

【在 i**p 的大作中提到】

: I may not understand how your code work. I am used to run conn.open and the
: like. But it seems it is not necessary to run it in your method. Is your
: method named ODP.NET?
:
: che

i*p2007-05-21 07:05

11 楼

Compiler Error Message: CS0246: The type or namespace name 'OracleDataSource
' could not be found (are you missing a using directive or an assembly
reference?)
How can I include the name space in c#?

passow

【在 y********o 的大作中提到】

: So, you wanna open the connection in your code-behind?
: For oracle, do this:
: Instantiate an OracleDataSource object and pass your db user name and passow
: rd as well as the network protocol to its setter methods, like so:
: OracleDataSource ods = new OracleDataSource();
: ods.setUser(dbUser); // e.g. "hr"
: ods.setPassword(dbPassword); // e.g. "hr"
: ods.setDriverType(driverType); // e.g. "oci8"
: ods.setNetworkProtocol(networkProtocol); // e.g. "ipc"
: And then you say,

y*o2007-05-21 07:05

12 楼

O, sorry, that code is for oracle jdbc.
I can connect to my Oracle 10g using ODBC, not sure if this is what you wann
a use.
oracleConn = new OdbcConnection();
oracleConn.ConnectionString = @"DSN=OraServiceName; UID=myusername;PWD=my
passwd; DRIVER= {Microsoft ODBC for Oracle}; SERVER=110.119.114.120;";
oracleConn.Open();
I hope this would help.

OracleDataSource

【在 i**p 的大作中提到】

: Compiler Error Message: CS0246: The type or namespace name 'OracleDataSource
: ' could not be found (are you missing a using directive or an assembly
: reference?)
: How can I include the name space in c#?
:
: passow

i*p2007-05-21 07:05

13 楼

Thanks! I like this method.
I am confused by OraServiceName. I installed Oracle 10g XE with all default
settings in my computer(Name: blue, IP:168.192.0.5). What is the
OraServiceName?
Aslo, Do I need convert {Microsoft ODBC for Oracle} to some string or value
or just it? I am wondering how Microsoft ASP.NET can regnize {Microsoft
ODBC for Oracle} if we don't convert it to some driver file name.

wann
my

【在 y********o 的大作中提到】

: O, sorry, that code is for oracle jdbc.
: I can connect to my Oracle 10g using ODBC, not sure if this is what you wann
: a use.
: oracleConn = new OdbcConnection();
: oracleConn.ConnectionString = @"DSN=OraServiceName; UID=myusername;PWD=my
: passwd; DRIVER= {Microsoft ODBC for Oracle}; SERVER=110.119.114.120;";
: oracleConn.Open();
: I hope this would help.
:
: OracleDataSource

y*o2007-05-21 07:05

14 楼

Do you know how to create a DSN?
The code I showed you uses a DSN connection. The name can be anything you c
hoose. Once you have the DSN set up, the connection will be OK.

default
value

【在 i**p 的大作中提到】

: Thanks! I like this method.
: I am confused by OraServiceName. I installed Oracle 10g XE with all default
: settings in my computer(Name: blue, IP:168.192.0.5). What is the
: OraServiceName?
: Aslo, Do I need convert {Microsoft ODBC for Oracle} to some string or value
: or just it? I am wondering how Microsoft ASP.NET can regnize {Microsoft
: ODBC for Oracle} if we don't convert it to some driver file name.
:
: wann
: my

i*p2007-05-21 07:05

15 楼

I tried to create system and user DSN with both "Oracle in XE" and "
Microsoft ODBC for Oracle" driver, but all of them got an error when the
code reached to oracleConn.Open().
There is a testing procedure when I set system DSN with driver "Oracle in XE
" and connection test is successful.
Could you show me how you set your DSN in your method?
Here is my error meesage from oracleConn.Open().
ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]Error while trying
to retrieve text for error OR

【在 y********o 的大作中提到】

: Do you know how to create a DSN?
: The code I showed you uses a DSN connection. The name can be anything you c
: hoose. Once you have the DSN set up, the connection will be OK.
:
: default
: value

i*p2007-05-21 07:05

16 楼

Finally, I got it work by following connection string:
oracleConn.ConnectionString = "Driver={Oracle in XE};Server=XE;Uid=user/
passwd;";
I still wonder why my DSN setting does not work. DSN OracleXE is set to the
same as above. It passes connection test succesfully. But .Open() fails when
I use the following connect strings:
oracleConn.ConnectionString = "DSN=OracleXE;";
oracleConn.ConnectionString = @"DSN=OracleXE;";
Any reasons?

c

【在 y********o 的大作中提到】

: Do you know how to create a DSN?
: The code I showed you uses a DSN connection. The name can be anything you c
: hoose. Once you have the DSN set up, the connection will be OK.
:
: default
: value