**

Hi, listeners!

Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
HPDHelpDesk is defined and comes with the HelpDesk application.

When I use MS Access to link table (File | Get External Data | Link Tables
| ODBC Databases...), I don't see the view listed on the available table or
view list. I even tried to use id aradmin but still couldn't see the
view. I did use sqlplus to check the owner of the view, which is aradmin.

MS Access: Access 97
Remedy ODBC Driver: 4.0.3
ARS Server: 4.0.3
HelpDesk: 4.0
DBMS: Oracle 8.1.7

Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
(504)263-7206

**

Eric,

from what I remember, you need to configure a system dsn in your odbc
settings... depending if you want to use the remedy odbc driver or the
oracle odbc driver (or the ms oracle odbc driver...)....

if you are using the remedy odbc driver, configure the dsn with a remedy
user id that has access to the form
if you use the oracle odbc driver, make sure you set up the userid with an
oracle user/password who can see that view (aradmin will work, of course...)

make sure that you have that database listed in your tnsnames.ora file....

if you need more clarification, let me know (running off to a meeting, so
kept it short... sorry!)

Matt Reinfeldt
Remedy System Administrator & Developer
Support Solutions - U.S. Cellular
608-441-4491


-----Original Message-----
From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
Sent: Thursday, July 11, 2002 10:13 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Using MS Access to link to view HPDHELPDESK


**

Hi, listeners!

Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
HPDHelpDesk is defined and comes with the HelpDesk application.

When I use MS Access to link table (File | Get External Data | Link Tables
| ODBC Databases...), I don't see the view listed on the available table or
view list. I even tried to use id aradmin but still couldn't see the
view. I did use sqlplus to check the owner of the view, which is aradmin.

MS Access: Access 97
Remedy ODBC Driver: 4.0.3
ARS Server: 4.0.3
HelpDesk: 4.0
DBMS: Oracle 8.1.7

Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
(504)263-7206



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Matt,

Sorry I didn't make it clear.

When I use MS Access to link to the Arsystem, I am able to see all the base
tables such as HPD:HelpDesk, CHG:Change, etc. What I really want is a
database view called HPDHELPDESK. The view is defined using table join so
it contains columns you wouldn't be able to see in table HPD:HelpDesk, such
as dairy fields (e.g., worklog), long data fields (e.g., description),
etc...

Thanks,
Eric

On Thu, 11 Jul 2002 10:29:47 -0500, Reinfeldt, Matt
wrote:

>**
>
>Eric,
>
>from what I remember, you need to configure a system dsn in your odbc
>settings... depending if you want to use the remedy odbc driver or the
>oracle odbc driver (or the ms oracle odbc driver...)....
>
>if you are using the remedy odbc driver, configure the dsn with a remedy
>user id that has access to the form
>if you use the oracle odbc driver, make sure you set up the userid with an
>oracle user/password who can see that view (aradmin will work, of
course...)
>
>make sure that you have that database listed in your tnsnames.ora file....
>
>if you need more clarification, let me know (running off to a meeting, so
>kept it short... sorry!)
>
>Matt Reinfeldt
>Remedy System Administrator & Developer
>Support Solutions - U.S. Cellular
>608-441-4491
>
>
>-----Original Message-----
>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>Sent: Thursday, July 11, 2002 10:13 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Hi, listeners!
>
>Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
>HPDHelpDesk is defined and comes with the HelpDesk application.
>
>When I use MS Access to link table (File | Get External Data | Link Tables
>| ODBC Databases...), I don't see the view listed on the available table or
>view list. I even tried to use id aradmin but still couldn't see the
>view. I did use sqlplus to check the owner of the view, which is aradmin.
>
>MS Access: Access 97
>Remedy ODBC Driver: 4.0.3
>ARS Server: 4.0.3
>HelpDesk: 4.0
>DBMS: Oracle 8.1.7
>
>Thanks in advance for your help.
>
>Eric Zhang
>Entergy Services, Inc.
>(504)263-7206
>
>

>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Eric,

was the view created from within Remedy (join form) or did your dba create
it?

Matt

-----Original Message-----
From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
Sent: Thursday, July 11, 2002 10:43 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Using MS Access to link to view HPDHELPDESK


**

Matt,

Sorry I didn't make it clear.

When I use MS Access to link to the Arsystem, I am able to see all the base
tables such as HPD:HelpDesk, CHG:Change, etc. What I really want is a
database view called HPDHELPDESK. The view is defined using table join so
it contains columns you wouldn't be able to see in table HPD:HelpDesk, such
as dairy fields (e.g., worklog), long data fields (e.g., description),
etc...

Thanks,
Eric

On Thu, 11 Jul 2002 10:29:47 -0500, Reinfeldt, Matt
wrote:

>**
>
>Eric,
>
>from what I remember, you need to configure a system dsn in your odbc
>settings... depending if you want to use the remedy odbc driver or the
>oracle odbc driver (or the ms oracle odbc driver...)....
>
>if you are using the remedy odbc driver, configure the dsn with a remedy
>user id that has access to the form
>if you use the oracle odbc driver, make sure you set up the userid with an
>oracle user/password who can see that view (aradmin will work, of
course...)
>
>make sure that you have that database listed in your tnsnames.ora file....
>
>if you need more clarification, let me know (running off to a meeting, so
>kept it short... sorry!)
>
>Matt Reinfeldt
>Remedy System Administrator & Developer
>Support Solutions - U.S. Cellular
>608-441-4491
>
>
>-----Original Message-----
>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>Sent: Thursday, July 11, 2002 10:13 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Hi, listeners!
>
>Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
>HPDHelpDesk is defined and comes with the HelpDesk application.
>
>When I use MS Access to link table (File | Get External Data | Link Tables
>| ODBC Databases...), I don't see the view listed on the available table or
>view list. I even tried to use id aradmin but still couldn't see the
>view. I did use sqlplus to check the owner of the view, which is aradmin.
>
>MS Access: Access 97
>Remedy ODBC Driver: 4.0.3
>ARS Server: 4.0.3
>HelpDesk: 4.0
>DBMS: Oracle 8.1.7
>
>Thanks in advance for your help.
>
>Eric Zhang
>Entergy Services, Inc.
>(504)263-7206
>
>

>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Matt,
The view was created from within Remedy.

Thanks,
Eric
On Thu, 11 Jul 2002 10:53:13 -0500, Reinfeldt, Matt
wrote:

>**
>
>Eric,
>
>was the view created from within Remedy (join form) or did your dba create
>it?
>
>Matt
>
>-----Original Message-----
>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>Sent: Thursday, July 11, 2002 10:43 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Matt,
>
>Sorry I didn't make it clear.
>
>When I use MS Access to link to the Arsystem, I am able to see all the base
>tables such as HPD:HelpDesk, CHG:Change, etc. What I really want is a
>database view called HPDHELPDESK. The view is defined using table join so
>it contains columns you wouldn't be able to see in table HPD:HelpDesk, such
>as dairy fields (e.g., worklog), long data fields (e.g., description),
>etc...
>
>Thanks,
>Eric
>
>On Thu, 11 Jul 2002 10:29:47 -0500, Reinfeldt, Matt
> wrote:
>
>>**
>>
>>Eric,
>>
>>from what I remember, you need to configure a system dsn in your odbc
>>settings... depending if you want to use the remedy odbc driver or the
>>oracle odbc driver (or the ms oracle odbc driver...)....
>>
>>if you are using the remedy odbc driver, configure the dsn with a remedy
>>user id that has access to the form
>>if you use the oracle odbc driver, make sure you set up the userid with an
>>oracle user/password who can see that view (aradmin will work, of
>course...)
>>
>>make sure that you have that database listed in your tnsnames.ora file....
>>
>>if you need more clarification, let me know (running off to a meeting, so
>>kept it short... sorry!)
>>
>>Matt Reinfeldt
>>Remedy System Administrator & Developer
>>Support Solutions - U.S. Cellular
>>608-441-4491
>>
>>
>>-----Original Message-----
>>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>>Sent: Thursday, July 11, 2002 10:13 AM
>>To: ARSLIST@LISTSERV.VISTAIT.COM
>>Subject: Using MS Access to link to view HPDHELPDESK
>>
>>
>>**
>>
>>Hi, listeners!
>>
>>Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
>>HPDHelpDesk is defined and comes with the HelpDesk application.
>>
>>When I use MS Access to link table (File | Get External Data | Link Tables
>>| ODBC Databases...), I don't see the view listed on the available table
or
>>view list. I even tried to use id aradmin but still couldn't see the
>>view. I did use sqlplus to check the owner of the view, which is aradmin.
>>
>>MS Access: Access 97
>>Remedy ODBC Driver: 4.0.3
>>ARS Server: 4.0.3
>>HelpDesk: 4.0
>>DBMS: Oracle 8.1.7
>>
>>Thanks in advance for your help.
>>
>>Eric Zhang
>>Entergy Services, Inc.
>>(504)263-7206
>>
>>

>
>>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>>www.ARSLIST.org
>>
>>

>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Okay Eric,

I think I understand... Is the name of the Join Form in Remedy HPDHELPDESK?
Or is it something else? Meaning, you have a regular form HPD:HelpDesk and
a join form HPDHELPDESK?

Sorry for asking basic questions, but I haven't done a lot of work w/ join
forms and I'm kinda guessing here... :-)

matt

-----Original Message-----
From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
Sent: Thursday, July 11, 2002 10:58 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Using MS Access to link to view HPDHELPDESK


**

Matt,
The view was created from within Remedy.

Thanks,
Eric
On Thu, 11 Jul 2002 10:53:13 -0500, Reinfeldt, Matt
wrote:

>**
>
>Eric,
>
>was the view created from within Remedy (join form) or did your dba create
>it?
>
>Matt
>
>-----Original Message-----
>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>Sent: Thursday, July 11, 2002 10:43 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Matt,
>
>Sorry I didn't make it clear.
>
>When I use MS Access to link to the Arsystem, I am able to see all the base
>tables such as HPD:HelpDesk, CHG:Change, etc. What I really want is a
>database view called HPDHELPDESK. The view is defined using table join so
>it contains columns you wouldn't be able to see in table HPD:HelpDesk, such
>as dairy fields (e.g., worklog), long data fields (e.g., description),
>etc...
>
>Thanks,
>Eric
>
>On Thu, 11 Jul 2002 10:29:47 -0500, Reinfeldt, Matt
> wrote:
>
>>**
>>
>>Eric,
>>
>>from what I remember, you need to configure a system dsn in your odbc
>>settings... depending if you want to use the remedy odbc driver or the
>>oracle odbc driver (or the ms oracle odbc driver...)....
>>
>>if you are using the remedy odbc driver, configure the dsn with a remedy
>>user id that has access to the form
>>if you use the oracle odbc driver, make sure you set up the userid with an
>>oracle user/password who can see that view (aradmin will work, of
>course...)
>>
>>make sure that you have that database listed in your tnsnames.ora file....
>>
>>if you need more clarification, let me know (running off to a meeting, so
>>kept it short... sorry!)
>>
>>Matt Reinfeldt
>>Remedy System Administrator & Developer
>>Support Solutions - U.S. Cellular
>>608-441-4491
>>
>>
>>-----Original Message-----
>>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>>Sent: Thursday, July 11, 2002 10:13 AM
>>To: ARSLIST@LISTSERV.VISTAIT.COM
>>Subject: Using MS Access to link to view HPDHELPDESK
>>
>>
>>**
>>
>>Hi, listeners!
>>
>>Can anyone tell me how I can access view HPDHelpDesk from MS Access? View
>>HPDHelpDesk is defined and comes with the HelpDesk application.
>>
>>When I use MS Access to link table (File | Get External Data | Link Tables
>>| ODBC Databases...), I don't see the view listed on the available table
or
>>view list. I even tried to use id aradmin but still couldn't see the
>>view. I did use sqlplus to check the owner of the view, which is aradmin.
>>
>>MS Access: Access 97
>>Remedy ODBC Driver: 4.0.3
>>ARS Server: 4.0.3
>>HelpDesk: 4.0
>>DBMS: Oracle 8.1.7
>>
>>Thanks in advance for your help.
>>
>>Eric Zhang
>>Entergy Services, Inc.
>>(504)263-7206
>>
>>

>
>>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>>www.ARSLIST.org
>>
>>

>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Matt,

It's not a form join, rather it's a database view created by Remedy using
table join in the database level.

I tried to use Oracle ODBC driver instead of Remedy ODBC driver suggested
by another listener (Thanks, Pam!), I was able to link to the view.
However, as you would expect, the date/time fields stay as integers, the
values for static dropdown fields stay as integers. The Remedy ODBC driver
would have taken care of these fields.

Thanks,
Eric

On Thu, 11 Jul 2002 12:31:39 -0500, Reinfeldt, Matt
wrote:

>**
>
>Okay Eric,
>
>I think I understand... Is the name of the Join Form in Remedy
HPDHELPDESK?
>Or is it something else? Meaning, you have a regular form HPD:HelpDesk and
>a join form HPDHELPDESK?
>
>Sorry for asking basic questions, but I haven't done a lot of work w/ join
>forms and I'm kinda guessing here... :-)
>
>matt
>
>-----Original Message-----
>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>Sent: Thursday, July 11, 2002 10:58 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Matt,
>The view was created from within Remedy.
>
>Thanks,
>Eric
>On Thu, 11 Jul 2002 10:53:13 -0500, Reinfeldt, Matt
> wrote:
>
>>**
>>
>>Eric,
>>
>>was the view created from within Remedy (join form) or did your dba create
>>it?
>>
>>Matt
>>
>>-----Original Message-----
>>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>>Sent: Thursday, July 11, 2002 10:43 AM
>>To: ARSLIST@LISTSERV.VISTAIT.COM
>>Subject: Re: Using MS Access to link to view HPDHELPDESK
>>
>>
>>**
>>
>>Matt,
>>
>>Sorry I didn't make it clear.
>>
>>When I use MS Access to link to the Arsystem, I am able to see all the
base
>>tables such as HPD:HelpDesk, CHG:Change, etc. What I really want is a
>>database view called HPDHELPDESK. The view is defined using table join
so
>>it contains columns you wouldn't be able to see in table HPD:HelpDesk,
such
>>as dairy fields (e.g., worklog), long data fields (e.g., description),
>>etc...
>>
>>Thanks,
>>Eric
>>
>>On Thu, 11 Jul 2002 10:29:47 -0500, Reinfeldt, Matt
>> wrote:
>>
>>>**
>>>
>>>Eric,
>>>
>>>from what I remember, you need to configure a system dsn in your odbc
>>>settings... depending if you want to use the remedy odbc driver or the
>>>oracle odbc driver (or the ms oracle odbc driver...)....
>>>
>>>if you are using the remedy odbc driver, configure the dsn with a remedy
>>>user id that has access to the form
>>>if you use the oracle odbc driver, make sure you set up the userid with
an
>>>oracle user/password who can see that view (aradmin will work, of
>>course...)
>>>
>>>make sure that you have that database listed in your tnsnames.ora
file....
>>>
>>>if you need more clarification, let me know (running off to a meeting, so
>>>kept it short... sorry!)
>>>
>>>Matt Reinfeldt
>>>Remedy System Administrator & Developer
>>>Support Solutions - U.S. Cellular
>>>608-441-4491
>>>
>>>
>>>-----Original Message-----
>>>From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
>>>Sent: Thursday, July 11, 2002 10:13 AM
>>>To: ARSLIST@LISTSERV.VISTAIT.COM
>>>Subject: Using MS Access to link to view HPDHELPDESK
>>>
>>>
>>>**
>>>
>>>Hi, listeners!
>>>
>>>Can anyone tell me how I can access view HPDHelpDesk from MS Access?
View
>>>HPDHelpDesk is defined and comes with the HelpDesk application.
>>>
>>>When I use MS Access to link table (File | Get External Data | Link
Tables
>>>| ODBC Databases...), I don't see the view listed on the available table
>or
>>>view list. I even tried to use id aradmin but still couldn't see the
>>>view. I did use sqlplus to check the owner of the view, which is
aradmin.
>>>
>>>MS Access: Access 97
>>>Remedy ODBC Driver: 4.0.3
>>>ARS Server: 4.0.3
>>>HelpDesk: 4.0
>>>DBMS: Oracle 8.1.7
>>>
>>>Thanks in advance for your help.
>>>
>>>Eric Zhang
>>>Entergy Services, Inc.
>>>(504)263-7206
>>>
>>>

>
>>
>>>
>>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>>>listserv@listserv.vistait.com
>>>You may also control your subscription options, including UNSUBSCRIBE, at
>>>www.ARSLIST.org
>>>
>>>

>
>>
>>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>>listserv@listserv.vistait.com
>>>You may also control your subscription options, including UNSUBSCRIBE, at
>>www.ARSLIST.org
>>
>>

>
>>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>>www.ARSLIST.org
>>
>>

>
>>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
>www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hi Eric,

Do you see the other views when you link using the Remedy ODBC driver?

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Zhang, Eric L
Sent: July 11, 2002 11:13 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Using MS Access to link to view HPDHELPDESK


**

Hi, listeners!

Can anyone tell me how I can access view HPDHelpDesk from MS Access?
View HPDHelpDesk is defined and comes with the HelpDesk application.

When I use MS Access to link table (File | Get External Data | Link
Tables
| ODBC Databases...), I don't see the view listed on the available table

| or
view list. I even tried to use id aradmin but still couldn't see the
view. I did use sqlplus to check the owner of the view, which is
aradmin.

MS Access: Access 97
Remedy ODBC Driver: 4.0.3
ARS Server: 4.0.3
HelpDesk: 4.0
DBMS: Oracle 8.1.7

Thanks in advance for your help.

Eric Zhang
Entergy Services, Inc.
(504)263-7206



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com You may also control your subscription
options, including UNSUBSCRIBE, at www.ARSLIST.org

**

Hi Jeromy,
I don't see any views when using the Remedy ODBC driver. I only see tables
for forms.
Eric
On Thu, 11 Jul 2002 14:40:36 -0400, REED, JEROMY wrote:

>**
>
>Hi Eric,
>
>Do you see the other views when you link using the Remedy ODBC driver?
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Zhang, Eric L
>Sent: July 11, 2002 11:13 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Hi, listeners!
>
>Can anyone tell me how I can access view HPDHelpDesk from MS Access?
>View HPDHelpDesk is defined and comes with the HelpDesk application.
>
>When I use MS Access to link table (File | Get External Data | Link
>Tables
>| ODBC Databases...), I don't see the view listed on the available table
>
>| or
>view list. I even tried to use id aradmin but still couldn't see the
>view. I did use sqlplus to check the owner of the view, which is
>aradmin.
>
>MS Access: Access 97
>Remedy ODBC Driver: 4.0.3
>ARS Server: 4.0.3
>HelpDesk: 4.0
>DBMS: Oracle 8.1.7
>
>Thanks in advance for your help.
>
>Eric Zhang
>Entergy Services, Inc.
>(504)263-7206
>
>
>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com You may also control your subscription
>options, including UNSUBSCRIBE, at www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Eric,
You are correct that the Remedy ODBC driver will only see forms (schemas)
that are visible in the Remedy User and Admin tools. It uses all Remedy
login security of Forms and Fields (meaning if the login you are using does
not have rights to a form or field in the User tool then it will not be
visible through the Remedy ODBC). Any views or tables defined directly in
the database will not be accessible through the Remedy ODBC. When using the
Oracle (or any other database) ODBC, the dates in Remedy tables will be
displayed as integers.

To convert the integer dates to character dates in Access you can use the
following functions: NOTE: The 21600 is the seconds offset from GMT for
Central Standard Time (GMT-6 hours) and could have been written as ((60 *
60) * 6).

Public Function FromRemedyDate(lngRemedyDate As Variant) As Variant
Dim Result As Variant
Result = Null
If Not IsNull(lngRemedyDate) Then
Result = DateAdd("s", lngRemedyDate - 21600, #1/1/1970#)
End If
FromRemedyDate = Result
End Function

Public Function ToRemedyDate(dteValue As Variant) As Variant
Dim Result As Variant
Result = Null
If Not IsNull(dteValue) Then
Result = DateDiff("s", #1/1/1970#, dteValue) + 21600
End If
ToRemedyDate = Result
End Function

Fred

-----Original Message-----
From: Zhang, Eric L [mailto:ezhang@ENTERGY.COM]
Sent: Thursday, July 11, 2002 4:43 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Using MS Access to link to view HPDHELPDESK


**

Hi Jeromy,
I don't see any views when using the Remedy ODBC driver. I only see tables
for forms.
Eric
On Thu, 11 Jul 2002 14:40:36 -0400, REED, JEROMY wrote:

>**
>
>Hi Eric,
>
>Do you see the other views when you link using the Remedy ODBC driver?
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM] On Behalf Of Zhang, Eric L
>Sent: July 11, 2002 11:13 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Using MS Access to link to view HPDHELPDESK
>
>
>**
>
>Hi, listeners!
>
>Can anyone tell me how I can access view HPDHelpDesk from MS Access?
>View HPDHelpDesk is defined and comes with the HelpDesk application.
>
>When I use MS Access to link table (File | Get External Data | Link
>Tables
>| ODBC Databases...), I don't see the view listed on the available table
>
>| or
>view list. I even tried to use id aradmin but still couldn't see the
>view. I did use sqlplus to check the owner of the view, which is
>aradmin.
>
>MS Access: Access 97
>Remedy ODBC Driver: 4.0.3
>ARS Server: 4.0.3
>HelpDesk: 4.0
>DBMS: Oracle 8.1.7
>
>Thanks in advance for your help.
>
>Eric Zhang
>Entergy Services, Inc.
>(504)263-7206
>
>
>
>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
>listserv@listserv.vistait.com You may also control your subscription
>options, including UNSUBSCRIBE, at www.ARSLIST.org
>
>

>To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
>You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org