BMC Support to to create a
> ODBC driver to be version 3 compliant.. This may not be an immediate fix
> but
> at least they will consider building their drivers to support version 3..
>
> Joe
>
>
>
> -Original Message-
> From: Action Request System discussion
gt;
> What errors are you getting when you try connecting to the database using
> the AR ODBC driver?
>
> Joe
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] Behalf Of brooksm
> Sent: Friday, Ja
Hello All
I am using SQL Server Reporting Services for my reporting application and
the ARSystem ODBC driver is throwing up errors when I use it to connect to
ARSystem, so I am connecting directly to the database for my reporting. Is
anyone else running into this problem? If not, can someone tell m
m: Action Request System discussion list(ARSList)
>> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
>> Sent: Wednesday, December 12, 2007 6:25 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Cannot log in to Remedy after Windows Server SP2 Install
>>
>> Help!!!
>> I
When logging into the Remedy client, it seems to hang on "Setting Server
Port..."
brooksm wrote:
>
> Help!!!
> I just updated my ARS 7.0 on Windows 2003 SQL Server 2005 system to SP2.
> Now, after rebooting the system, I cannot login to the system.
>
> Cannot logi
Help!!!
I just updated my ARS 7.0 on Windows 2003 SQL Server 2005 system to SP2.
Now, after rebooting the system, I cannot login to the system.
Cannot login to remedy1 as a preference server.
user: brooks, server: remedy1
Unable to successfully log in to any server.
I'm sure it's an e
er Communications, Inc.
>
> 405 736 3211
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Thursday, November 15, 2007 4:55 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Di
on your
> remote queries.
>
> Thanks,
>
>
> Gary Opela, Jr
>
> Sr. Remedy Developer
>
> Leader Communications, Inc.
>
> 405 736 3211
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL
nd has select access to the necessary table.
> Sam
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Thursday, 15 November 2007 5:14 p.m.
> To: ARSList
> Subject: Re: Direct SQL Acti
m: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Thursday, 15 November 2007 2:21 p.m.
> To: ARSList
> Subject: Direct SQL Active Link to query Oracle from SQL Server
>
> Hi Listers
> I've built a query using openquery tha
Hi Listers
I've built a query using openquery that queries an oracle view from my
ARSystem on SQL Server 2005
This doesn't work:
select * from openquery(STG,'select *
from USER.HOUSEHOLD_VIEW
where HOUSEHOLD_ID = ''$Email Address$'')
Produces this error:
ARERR [552] Failure during SQL operation t
in ARS regular forms.
>
> Cheers
>
> Joe D'Souza
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] Behalf Of brooksm
> Sent: Friday, October 26, 2007 6:45 PM
> To: arslist@ARSLIST.ORG
> Subject
Good afternoon listers-
On ARSystem 7.0 SQL Server 2005, i've created a dblink to another SQL Server
2000 table. I've successfully created a view form off of this database link
and used the ROW_ID field as the key field for the new view form. The
problem I'm running into is that this key field is a
riendelijke groet / Kind regards
> Michiel Beijen
> __
> MANSOLUTIONS
> Energieweg 60-62
> 3771 NA Barneveld
> The Netherlands
> Tel. +31-(0)612968592
> Mail [EMAIL PROTECTED]
> Internet http://bsm.mansolutions.nl
>
>
> On
Hi-
My ARSystem server is on MS SQL Server 2005.
I've created a view (view_form1) on my SQL Server of an external SQL Server
2000 table. This new view contains all fields, but when I try to create a
view form on view_form1 all numeric and datetime fields do not come over.
What is the easiest way to
We are on as SQL Server 2005 ARSystem 7.00 Help Desk 6.00 System.
I'm looking at implementing the Java API plugin, but haven't the faintest
idea as to how to do this. I've read that the Java API changed quite a bit
from 7.00 to 7.1 so am thinking that we should upgrade to 7.1 before
implementing th
-2565
> sf49fanv AIM IM
> RogerNall Yahoo IM
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Wednesday, August 15, 2007 4:49 PM
> To: arslist@ARSLIST.ORG
> Subject:
--Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Wednesday, August 15, 2007 3:05 PM
> To: arslist@ARSLIST.ORG
> Subject: How to create a view form
>
> My ARSystem is on a SQL Server 2005 da
gher wrote:
>
> Who were you logged in as when you created the view in your database?
> It is most likely login.view. For example aradmin.ALTIRIS_VIEW.
>
> You also might want to check the permissions on the view and make sure
> the aradmin account has permission to read and write it.
e create the view form.
>
> //SIGNED//
> CRAIG J. CARTER, RSP
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Wednesday, August 15, 2007 2:05 PM
> To: arslist@ARSLIST.OR
My ARSystem is on a SQL Server 2005 database and I need to create a view form
of an external table/view. I've already set up the dblink and created a view
of the external table. I'm having problems with the correct syntax when
creating the view form.
Database = ARSystem
Schema = dbo
So far i've t
Happy Friday!
I have a view (household) of an Oracle table in SQL Server 2005 and created
a Remedy view form of the SQL Server household view. There is a functional
index on the Oracle household table using UPPER("LAST_NAME"). When I do a
search in the Remedy view form for the last name of "Smith"
Hi listers
I have an active link that sets several fields from a view form that fires
on lose focus of a field. This AL works perfectly. I'm trying to do this in
an escalation on a daily interval since the data in the view form may
change. As a test, I have the escalation set to run every 5 minutes
Does anyone know of a way to allow end users to import records from a .csv
into Remedy? My Remedy system is on SQL Server 2005, so I thought there may
be a way to create an SSIS package that imports a file from a shared
directory when triggered by workflow. Does anyone know if this is possible?
Or
We have both an outgoing and incoming mailbox set up. The outgoing is working
fine and haven't had any need to use the incoming mailbox until now. I need
to get email submission working and while trying to send email to the user
that we set up for Remedy emails on MS Exchange I found that these inc
E ( $Requester Name+$ + "%" )
>
>
> brooksm <[EMAIL PROTECTED]> wrote:
> Roney,
> $Requester Name+$ LIKE ( 'Full Name' + "%" ) is one that I tried and
> couldn't get the right behavior. I double checked the QBE Match field on
> the
> 'Requ
matching request or else display a list.
> Hope this helps
>
> Also the requester name field should have a leading database search.
>
> Regards,
> Roney Samuel Varghese
>
>
> On 6/25/07, brooksm <[EMAIL PROTECTED]> wrote:
>>
>> Hi-
>> I'm
Hi-
I'm trying to create the same kind of workflow that occurs on the Requester
Name+ field in Help Desk (but without the AL Guides).
I've created a new form and I'd like to be able to enter the first few
characters of the Requester's Name and hit 'Enter' to pull up a list of
matches or populate t
wrote:
>
> Have you tried turning on SQL logging at the server and taking a look at
> exactly what Remedy is passing to the SQL server and what the SQL server
> is returning?
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[
I've created a SQL view from another SQL Server 2005 database. When I run a
query on this view ins SQL Server management Studio, everything works as
expected. But when I do a SQL Set fields Active Link, I only get 29
characters in the field. Here is the SQL that I used to create my view:
CREATE V
server view by name.
>
> Hope that helps.
>
>
> brooksm wrote:
>>
>> I am running ARS 7.0 on SQL Server 2005 and need to create a view form of
>> an Oracle table.
>> So far i have created the dblink and can query oracle directly from SQL
>> Server
I am running ARS 7.0 on SQL Server 2005 and need to create a view form of an
Oracle table.
So far i have created the dblink and can query oracle directly from SQL
Server. I need help with the syntax of the view form connection in Remedy
Admin.
The syntax i've tried is:
LINK.OWNER.TABLE
[EMAIL PRO
32 matches
Mail list logo