Re: Issue related to 32 Bit AR ODBC Driver

2016-11-04 Thread Lee Cullom 
Oh jeesh – Have you seen our YouTube channel?  Please, for the love of all that 
is Remedy, have a look by clicking on my little link below.  MS Analysis 
Services is way, way better for automating all of this, not to mention the fact 
that you can also use Tableau and PowerBI with it.  Have a look!  
http://www.youtube.com/user/northcraftanalytics



Lee Cullom | Northcraft Analytics
IT Metrics Specialist | Business Intelligence Applications for IT
Direct – 678-438-7244 | 
http://www.northcraftanalytics.com<http://www.northcraftanalytics.com/>
Main - (678) 664-ITSM
[cid:image003.jpg@01CD6684.40E6DBC0]<https://www.linkedin.com/company/1747717?trk=tyah=clickedVertical%3Acompany%2Cidx%3A2-1-6%2CtarId%3A1429298510789%2Ctas%3ANorthcraft>[cid:image004.jpg@01CD6684.40E6DBC0]<http://twitter.com/#!/NorthcraftIT>[http://citadel.sjfc.edu/students-virtual/A/act00294/public_html/webdesign/Responsive%20Web%20site/images/youtube.png]<http://youtube.com/user/northcraftanalytics>
What is Northcraft Analytics? Find out in 87 Seconds. 
<http://www.youtube.com/watch?v=SRNyPNK_HJc>

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Friday, November 4, 2016 9:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Issue related to 32 Bit AR ODBC Driver

**
You are going to need an ODBC to JDBC bridge as Microsoft products do not 
support JDBC directly

Do a Google search on “odbc-jdbc bridge”

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm
Sent: Friday, November 04, 2016 8:51 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Issue related to 32 Bit AR ODBC Driver

**
Hi Carina & Mark,

I am using Oracle more over remedy credentials is easier to access then to go 
for an oracle account as we need to request for a service account:( which 
is a tedious process.

Since it is Microsoft Share Point I cannot use JDBC Driver.

Thank you,
Sriram.


On Fri, Nov 4, 2016 at 6:51 PM, Burns, Carina 
<carina.bu...@risd.org<mailto:carina.bu...@risd.org>> wrote:
**
What database are you running?  Instead of the AR ODBC driver, why not try a 
64-bit ODBC driver for the db?  I use an oracle odbc driver for my reporting.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of sriram pm
Sent: Friday, November 04, 2016 6:11 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Issue related to 32 Bit AR ODBC Driver

**
Dear Experts,

We have a Dashboard in Share-point which publishes Reports in Excel.

We have installed 32 Bit AR ODBC Driver in the Share Point 2013 Server and the 
report gets

refreshed when I run the report in an MS Excel Application but when I access 
the report using

the Browser where the report is published and try to refresh it throws an error 
as "Unidentified

ODBC Driver". We raised a Case with Microsoft and they say that an 64 Bit AR 
ODBC Driver

needs to be installed in the Share Point Server.  I am not able to find a 64 
Bit AR ODBC Driver.

Kindly help in fixing this issue.

Thank you,
Sriram.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issue related to 32 Bit AR ODBC Driver

2016-11-04 Thread sriram pm 
Hi Carina & Mark,

I am using Oracle more over remedy credentials is easier to access then to
go for an oracle account as we need to request for a service account:(
which is a tedious process.

Since it is Microsoft Share Point I cannot use JDBC Driver.

Thank you,
Sriram.


On Fri, Nov 4, 2016 at 6:51 PM, Burns, Carina  wrote:

> **
>
> What database are you running?  Instead of the AR ODBC driver, why not try
> a 64-bit ODBC driver for the db?  I use an oracle odbc driver for my
> reporting.
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *sriram pm
> *Sent:* Friday, November 04, 2016 6:11 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Issue related to 32 Bit AR ODBC Driver
>
>
>
> **
>
> Dear Experts,
>
>
>
> We have a Dashboard in Share-point which publishes Reports in Excel.
>
>
>
> We have installed 32 Bit AR ODBC Driver in the Share Point 2013 Server and
> the report gets
>
>
>
> refreshed when I run the report in an MS Excel Application but when I
> access the report using
>
>
>
> the Browser where the report is published and try to refresh it throws an
> error as "Unidentified
>
>
>
> ODBC Driver". We raised a Case with Microsoft and they say that an 64 Bit
> AR ODBC Driver
>
>
>
> needs to be installed in the Share Point Server.  I am not able to find a
> 64 Bit AR ODBC Driver.
>
>
>
> Kindly help in fixing this issue.
>
>
>
> Thank you,
>
> Sriram.
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issue related to 32 Bit AR ODBC Driver

2016-11-04 Thread Walters, Mark 
Unfortunately there is no 64-bit ODBC driver for Remedy.  One problem with 
using the database driver is that you bypass the Remedy security model and data 
dictionary – you have access to all data, which may be acceptable depending on 
your requirements.  You could try the JDBC driver - 
https://communities.bmc.com/docs/DOC-22516

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Burns, Carina
Sent: 04 November 2016 13:21
To: arslist@ARSLIST.ORG
Subject: Re: Issue related to 32 Bit AR ODBC Driver

**
What database are you running?  Instead of the AR ODBC driver, why not try a 
64-bit ODBC driver for the db?  I use an oracle odbc driver for my reporting.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm
Sent: Friday, November 04, 2016 6:11 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Issue related to 32 Bit AR ODBC Driver

**
Dear Experts,

We have a Dashboard in Share-point which publishes Reports in Excel.

We have installed 32 Bit AR ODBC Driver in the Share Point 2013 Server and the 
report gets

refreshed when I run the report in an MS Excel Application but when I access 
the report using

the Browser where the report is published and try to refresh it throws an error 
as "Unidentified

ODBC Driver". We raised a Case with Microsoft and they say that an 64 Bit AR 
ODBC Driver

needs to be installed in the Share Point Server.  I am not able to find a 64 
Bit AR ODBC Driver.

Kindly help in fixing this issue.

Thank you,
Sriram.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, 
Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 
1927903 The content of this email is confidential. If you are not the 
addressee, you may not distribute, copy or disclose any part of it. If you 
receive this message in error, please delete this from your system and notify 
the sender immediately.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issue related to 32 Bit AR ODBC Driver

2016-11-04 Thread Burns, Carina 
What database are you running?  Instead of the AR ODBC driver, why not try a 
64-bit ODBC driver for the db?  I use an oracle odbc driver for my reporting.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm
Sent: Friday, November 04, 2016 6:11 AM
To: arslist@ARSLIST.ORG
Subject: Issue related to 32 Bit AR ODBC Driver

**
Dear Experts,

We have a Dashboard in Share-point which publishes Reports in Excel.

We have installed 32 Bit AR ODBC Driver in the Share Point 2013 Server and the 
report gets

refreshed when I run the report in an MS Excel Application but when I access 
the report using

the Browser where the report is published and try to refresh it throws an error 
as "Unidentified

ODBC Driver". We raised a Case with Microsoft and they say that an 64 Bit AR 
ODBC Driver

needs to be installed in the Share Point Server.  I am not able to find a 64 
Bit AR ODBC Driver.

Kindly help in fixing this issue.

Thank you,
Sriram.
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"