473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Connecting a GridView to an Oracle table

Hello All,

I am trying to connect a GridView to an Oracle table using the standard
SqlDataSource. The process is fairly simple and there are detailed
instructions from Microsoft ...
http://msdn2.microsoft.com/en-us/lib...04(vs.80).aspx

The problem is not accessing or displaying data from an Oracle table
.... that all works great!

The problem is the number of tables Oracle returns when connecting
using the SqlDataSource. By default, the Oracle 10g server has over
1500 system/sample tables ... yes, I said 1500 as in one thousand five
hundred default tables with the standard installation of Oracle 10g.

If you look at the above link ... step 12 reads as follows:

....

"12. Make sure that the Yes, save this connection check box is
selected, change the name of the connection string if you want, and
then click Next to have the connection string information saved in the
application's Web.config file.

The Configure the Select Statement pane appears."

....

So, that part in step 12, where it says "The Configure the Select
Statement pane appears" does show up but only after the Web Developer
IDE has locked the computer for 5 minutes!!! while it reads over 1500
tables from the Oracle server.

I looked into forcing Oracle to filter the tables shown by a specified
Oracle Schema ... but no luck. It seems the OracleClient provided from
Microsoft forcibly retrieves ALL Oracle tables/view/stored procedures
when used in the SqlDataSource ... regardless of the assigned user
Default Schema.

Does anyone have any ideas on how I work around this problem? Is there
better data provider than the Microsoft OracleClient? What about
subclassing the SqlDataSource and manually filtering the tables that
are shown?

Thank you in advance for any help given :)

Nov 29 '06 #1
2 5501

<rc*******@gmail.comwrote in message
news:11*********************@l12g2000cwl.googlegro ups.com...
Hello All,

I am trying to connect a GridView to an Oracle table using the standard
SqlDataSource. The process is fairly simple and there are detailed
instructions from Microsoft ...
http://msdn2.microsoft.com/en-us/lib...04(vs.80).aspx

The problem is not accessing or displaying data from an Oracle table
... that all works great!

The problem is the number of tables Oracle returns when connecting
using the SqlDataSource. By default, the Oracle 10g server has over
1500 system/sample tables ... yes, I said 1500 as in one thousand five
hundred default tables with the standard installation of Oracle 10g.

If you look at the above link ... step 12 reads as follows:

...

"12. Make sure that the Yes, save this connection check box is
selected, change the name of the connection string if you want, and
then click Next to have the connection string information saved in the
application's Web.config file.

The Configure the Select Statement pane appears."

...

So, that part in step 12, where it says "The Configure the Select
Statement pane appears" does show up but only after the Web Developer
IDE has locked the computer for 5 minutes!!! while it reads over 1500
tables from the Oracle server.

I looked into forcing Oracle to filter the tables shown by a specified
Oracle Schema ... but no luck. It seems the OracleClient provided from
Microsoft forcibly retrieves ALL Oracle tables/view/stored procedures
when used in the SqlDataSource ... regardless of the assigned user
Default Schema.

Does anyone have any ideas on how I work around this problem? Is there
better data provider than the Microsoft OracleClient? What about
subclassing the SqlDataSource and manually filtering the tables that
are shown?

Thank you in advance for any help given :)

I downloaded the Oracle provider for .Net from Oracle, and played around
with it against a 10g database on my lan awhile back. It seemed to work
fine.
Dec 2 '06 #2
You'd better try the provider by Oracle

On 28 Nov 2006 21:19:31 -0800, rc*******@gmail.com wrote:
>Hello All,

I am trying to connect a GridView to an Oracle table using the standard
SqlDataSource. The process is fairly simple and there are detailed
instructions from Microsoft ...
http://msdn2.microsoft.com/en-us/lib...04(vs.80).aspx

The problem is not accessing or displaying data from an Oracle table
... that all works great!

The problem is the number of tables Oracle returns when connecting
using the SqlDataSource. By default, the Oracle 10g server has over
1500 system/sample tables ... yes, I said 1500 as in one thousand five
hundred default tables with the standard installation of Oracle 10g.

If you look at the above link ... step 12 reads as follows:

...

"12. Make sure that the Yes, save this connection check box is
selected, change the name of the connection string if you want, and
then click Next to have the connection string information saved in the
application's Web.config file.

The Configure the Select Statement pane appears."

...

So, that part in step 12, where it says "The Configure the Select
Statement pane appears" does show up but only after the Web Developer
IDE has locked the computer for 5 minutes!!! while it reads over 1500
tables from the Oracle server.

I looked into forcing Oracle to filter the tables shown by a specified
Oracle Schema ... but no luck. It seems the OracleClient provided from
Microsoft forcibly retrieves ALL Oracle tables/view/stored procedures
when used in the SqlDataSource ... regardless of the assigned user
Default Schema.

Does anyone have any ideas on how I work around this problem? Is there
better data provider than the Microsoft OracleClient? What about
subclassing the SqlDataSource and manually filtering the tables that
are shown?

Thank you in advance for any help given :)
--

Bits.Bytes.
http://bytes.thinkersroom.com
Dec 2 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Kong Li | last post by:
Follow up to this thread, the latest Oracle 9i release 2 patchset (9.2.0.5) fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong...
1
by: yahibble | last post by:
Now, I am no Python expert but I have dabbled and I have spent a couple of days with another engineer unsuccessfully installing oracle drivers for MS ODBC on the win XP machine. It looked to me...
0
by: Bob Keller | last post by:
I've been working on a web project (VB) previously done with DataGrids in VS2003. I've migrated the project over to VS2005, because I like what I've seen of the newer features. Soooo.. I've...
1
by: RLN | last post by:
RE: Access 2003 using WinXP SP2 Problem: When I start up my app I double click either one of my two Oracle tables in the table list, it asks for an id and pass. I need them to be linked at...
2
by: guanfenglin | last post by:
Hello, I have a grid view which display and updates the data, however it doesn't work well, I always either get invalid name/number or not all varaibles bound, I am very frustrated at the...
1
by: jobs | last post by:
I am able to access 9i and 10g Oracle DBs from other clients on my pc - sqlplus, PLSQL Developer, etc. As a simple test I just wanted to connect and access the same oracle DBs through ASP.NET on...
3
by: hakiran | last post by:
Hello all, I have been using Perl DBI the last 6months or so. I use it extensively with MySQL. But recently i tried to access Oracle DB with it and was having trouble. Any help would be...
1
by: kinnu | last post by:
hi, could any one help me with the steps of connecting the vb form with the oracle database/table. I could connect vb to access. as my collage project requires connecting of vb with oracle...
19
by: mask | last post by:
Hi all, I have a problem of urgent nature . I am using Oracle and VB6 for an application . i am using ADODB coding In oracle i have created a table and trying to connect thru vb form. the vb code...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.