Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

**

The case-sensitive part got me. I have not tried it for quite a while now
but when I did I played around with the case.

Try:

appsbrowser@H3GPEOPLE@UAT ..... or something like that!

Seems silly but I remember having the same problem and it was because of the
case.

Mike.
--------------------------------------------
Michael Worts
Remedy Consultant
michael.worts@ntl.com
--------------------------------------------
Remedy v4.52 Patch 1017
RS/6000 - AIX 4.3
Oracle 8.1.6
--------------------------------------------

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: 12 July 2002 13:32
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms



Nothing to do.
It always appears the same message "Requested database table not found.
Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named
it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf
documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the
guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle
database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the
remote database, and H3GPEOPLE is the table that I want to see in my View
Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the
owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G





The contents of this email and any attachments are sent for the personal attention
of the addressee(s) only and may be confidential. If you are not the intended
addressee, any use, disclosure or copying of this email and any attachments is
unauthorised - please notify the sender by return and delete the message. Any
representations or commitments expressed in this email are subject to contract.

ntl Group Limited

Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

I have dropped and re-created the link as
CREATE DATABASE LINK uat CONNECT TO appsbrowser IDENTIFIED BY appsbrowser USING 'UAT';
and if I try to
select * from cat@uat
the answer is
TABLENAME TABLETYPE
------------------------------ -----------
H3GPEOPLE SYNONYM
Could it depend on fact that remote table is a synonym?

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:42 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

Seems to me, that it shouldn't. Have tried :

select * from H3GPEOPLE@uat

That might solve the problem.

Although, I am not the one who sets up our links here, we have to also enter the user so for us it works as :

select * from appsbrowser.h3gpeople@uat

Try one of those.

Brian

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 9:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


I have dropped and re-created the link as
CREATE DATABASE LINK uat CONNECT TO appsbrowser IDENTIFIED BY appsbrowser USING 'UAT';
and if I try to
select * from cat@uat
the answer is
TABLENAME TABLETYPE
------------------------------ -----------
H3GPEOPLE SYNONYM
Could it depend on fact that remote table is a synonym?

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:42 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G

Mauro, oracle is not case sensitive when it comes to object naming so I don't think its that.

I suspect appsbrowser does not have permission to view the h3gpeople view so log in as aradmin and type:

grant select on hg3people to appsbrowser

Barry.

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: 12 July 2002 14:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Seems to me, that it shouldn't. Have tried :

select * from H3GPEOPLE@uat

That might solve the problem.

Although, I am not the one who sets up our links here, we have to also enter the user so for us it works as :

select * from appsbrowser.h3gpeople@uat

Try one of those.

Brian

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 9:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


I have dropped and re-created the link as
CREATE DATABASE LINK uat CONNECT TO appsbrowser IDENTIFIED BY appsbrowser USING 'UAT';
and if I try to
select * from cat@uat
the answer is
TABLENAME TABLETYPE
------------------------------ -----------
H3GPEOPLE SYNONYM
Could it depend on fact that remote table is a synonym?

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:42 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G





*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************

No, it isn't, take a look at what I have done in the meanwhile from my ARADMIN user:
CREATE SYNONYM people FOR H3GPEOPLE@uat;
hence I try to spool the data directly from ARADMIN using the new synonym:
SQL> select count(*) from people;
COUNT(*)
----------
731
So it is real that in Oracle works fine.
But when I try to mount this synonym in the view form, the dream vanishes...

Ok, I don't want to bore you again! Thank a lot for your time, I'll try in more conservative way!
Greetings from Italy, a kindly country for next RUG!
Mauro

-----Original Message-----
From: Rawlinson, Barry [mailto:BRawlinson@COLT-TELECOM.COM]
Sent: Friday, July 12, 2002 5:45 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro, oracle is not case sensitive when it comes to object naming so I don't think its that.

I suspect appsbrowser does not have permission to view the h3gpeople view so log in as aradmin and type:

grant select on hg3people to appsbrowser

Barry.

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: 12 July 2002 14:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Seems to me, that it shouldn't. Have tried :

select * from H3GPEOPLE@uat

That might solve the problem.

Although, I am not the one who sets up our links here, we have to also enter the user so for us it works as :

select * from appsbrowser.h3gpeople@uat

Try one of those.

Brian

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 9:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


I have dropped and re-created the link as
CREATE DATABASE LINK uat CONNECT TO appsbrowser IDENTIFIED BY appsbrowser USING 'UAT';
and if I try to
select * from cat@uat
the answer is
TABLENAME TABLETYPE
------------------------------ -----------
H3GPEOPLE SYNONYM
Could it depend on fact that remote table is a synonym?

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:42 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G





*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************

FYI
I finally found the solution: problem was caused by the fact that H3GPEOPLE was a synonym, changing the connection string with the table it works very well.
Correct connection string is UserOwnerOfTheTable.TableName@DbLink
Thank you everybody
Mauro

-----Original Message-----
From: Rawlinson, Barry [mailto:BRawlinson@COLT-TELECOM.COM]
Sent: Friday, July 12, 2002 5:45 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro, oracle is not case sensitive when it comes to object naming so I don't think its that.

I suspect appsbrowser does not have permission to view the h3gpeople view so log in as aradmin and type:

grant select on hg3people to appsbrowser

Barry.

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: 12 July 2002 14:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Seems to me, that it shouldn't. Have tried :

select * from H3GPEOPLE@uat

That might solve the problem.

Although, I am not the one who sets up our links here, we have to also enter the user so for us it works as :

select * from appsbrowser.h3gpeople@uat

Try one of those.

Brian

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 9:18 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


I have dropped and re-created the link as
CREATE DATABASE LINK uat CONNECT TO appsbrowser IDENTIFIED BY appsbrowser USING 'UAT';
and if I try to
select * from cat@uat
the answer is
TABLENAME TABLETYPE
------------------------------ -----------
H3GPEOPLE SYNONYM
Could it depend on fact that remote table is a synonym?

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:42 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

I admit, I always use lower case and that has always worked for me. Unfortunately, that is about all I can suggest. Also, if you aren't the one that set up the link, verify that you are using the correct link name.

Brian Goralczyk

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 8:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: [ARSLIST] Setting Up a Remote Database for View Forms


Nothing to do.
It always appears the same message "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)."
I also have created a synonim of the remote table on my DB, and I have named it "H3GPEOPLE", but also in this way it doesn't work at all.
Have you noticed that the Admin's guide on-line is different from the pdf documentation? If the guide is right, I have no hope, it seems.
Thank you and bye.
Mauro

-----Original Message-----
From: Brian Goralczyk [mailto:Brian.Goralczyk@VERIZONWIRELESS.COM]
Sent: Friday, July 12, 2002 2:21 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Setting Up a Remote Database for View Forms


Mauro,

This is a pretty easy issue to fix. It seems that there is a typo in the guide. You want to use the format :

OWNERNAME.TABLENAME@LINK

so type in :

APPSBROWSER.H3GPEOPLE@UAT

and you should get everything you need.

Hope that helps,

Brian Goralczyk
Verizon Wireless

-----Original Message-----
From: Gabrielli Mauro [mailto:Mauro.Gabrielli@H3G.IT]
Sent: Friday, July 12, 2002 6:32 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: [ARSLIST] Setting Up a Remote Database for View Forms


Reading the programmer guide I founded the following statement for Oracle database:
LINK.OWNERNAME.TABLENAME@LINK

but I am not able to make it run. I use the following command line:

UAT.APPSBROWSER.H3GPEOPLE@UAT

where UAT is the DBLINK, APPSBROWSER is the owner of the table on the remote database, and H3GPEOPLE is the table that I want to see in my View Form. I tried also with ARADMIN instead of APPSBROWSER, being ARADMIN the owner of the DBLINK, but no way.

What am I wronging?

I hope faithfully...

Ciao everybody

Mauro

Mauro Gabrielli

Via Alessandro Severo, 246 - 00145 - Roma - Italy

+39 348 4525755

+39 06 59556170

IT Development, OSS, Trouble Ticket Management Systems

H3G





*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************