Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


How do I connect directly to the database?

How do I connect directly to the database?

How do I connect directly to the database?

I want to run queries directly without using the Remedy client.

I notice that a Remedy ODBC driver is installed on my PC but there is no DSN.

I am trying to find out how I can do this with the techies in my organisation but don't know how long this will take - can anyone help in the meantime?

RE: How do I connect directly to the database?

It sounds like you still need to configure your Remedy ODBC driver.  Open it up and in the AR Server field key in your server name (the same as in accounts).

RE: How do I connect directly to the database?

I managed to get a connection using your suggestion to create a system DSN using the Remedy ODBC driver and the server name. Thanks.
The only utility I have that connects using this DSN is MS Query.  When I try using Access I get the err msg " the database engine can't find (table name)..." and the connection fails.
What tools do people use to connect directly to the database?

RE: How do I connect directly to the database?

I have the same question. Have you figured it out?

RE: How do I connect directly to the database?

What is the datbase and version of the ARS databse (i.e. Oracle8, Oracle9, SQL Server 7, SQL Server 2000, etc.)?

What version of ARS are you using?

You should be able to go into whatever tool you use to run SQL queries against any database (Query Analyzer for SQL Server or SQL Plus for Oracle) and run queries against the database.

Give a little more info about how you are trying to do it and perhaps I can attempt to help.

RE: How do I connect directly to the database?

I know this is not a contribution to the thread here, but for some reason it wont let me add a new thread.

How can I create an automatic incremental circuit id in remedy ars. So that when I create a new circuit, the system will look at the last circuit id for a particular circuit level and assign the next circuit id to the new circuit.

I am a bit stumped on this one.



Thanks for the help and sorry for not contributing to the original thread

RE: How do I connect directly to the database?


You can create a regular form that we'll call NEXT_CIRCUIT.  On that form, create a field 'Next Circuit ID'.  There will only be one record in this form, and the value in the 'Next Circuit ID' field will always be the next circuit ID to be assigned.

Then when you save a record that creates a new circuit ID:

1. Assign the new circuit ID from the value in the 'Next Circuit ID' field on the NEXT_CIRCUIT form

2. Have a filter update the 'Next Circuit ID' on the NEXT_CIRCUIT form by setting 'Next Circuit ID' = ('Next Circuit ID' + 1)

You will have some considerations since it appears that you are using Alphanumeric circuit ID values instead of numeric ones, but the same concept will apply.

RE: How do I connect directly to the database?

Okay, I am able to set the Circuit ID field to the Next Circuit ID. Yet I am having issues with creating the filter to update the Next Circuit Form with the Next Circuit ID.

Not sure where I am going wrong.

RE: How do I connect directly to the database?

I am having a similar problem (connecting to Remedy).

I can connect to Remedy using AR System User (the Remedy client); however, when I try to connect using Excel or Access through the AR System ODBC driver I get the following error:

Driver]Cannot open catalog; Message number = 90

Some more information - The Remedy database is not local, I connect remotely, but have no problems connecting Remedy, just when I try to connect with the AR System ODBC to pulling data to a spreadsheet or Access databse.  Any ideas???


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close