Database Link Oracle

akkineni

New member
Joined
Aug 31, 2004
Messages
2
Programming Experience
1-3
Do anyone have some idea regarding the usage of database link tables from vb.net. If so please give me details of oledb driver that you are using.

while confuguring adapter its giving errors.

Thanks and Regards.
 

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
Hello akkineni and welcome.

I tested a dataForm with a connection to a linked table and had no problems. My dataBase was Access, the provider was Microsoft Jet 4.0 OLE DB Provider, the table was linked to another Access DB table.

What are the errors? What type of dataBase? What is the source of the linked table?
 

akkineni

New member
Joined
Aug 31, 2004
Messages
2
Programming Experience
1-3
Thanks for your reply Paszt.

I am using Oracle to Oracle database link. I have created database link and its working fine from SQL*Plus.

When I place a new OracleDataAdapter onto the form and start configuring it, the following sql statement

SELECT * FROM T1@MyLink

(T1 is the table name and MyLink is the link name)

its giving error "There were errors configuring the data adapter."

For the same table I have created a synonym from oracle as

CREATE SYNONYM S_FIRST FOR T1@MyLink

then given following sql statement in adapter configuration

SELECT * FROM S_FIRST

Now the error is "No data exists for the row or column."

So, thats the story. Hope I am clear.

Thanks in advance.
 
Top Bottom