×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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!

*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

Access Remedy Database from VB?

Access Remedy Database from VB?

Access Remedy Database from VB?

(OP)
I am trying to SELECT information out of a Remedy Database from a Visual Basic 6 program.

I am using ADODB and connecting to the Remedy ODBC Data Source.

I can open the connection with out error, but when I try to Execute my SQL Statment ("SELECT ...") I get the following error:  [ISAM]No Data Found.

Can anyone help me?

Thanks in advance.
- Bill

RE: Access Remedy Database from VB?

I was able to retreive Remedy data via ODBC .NET, which is in Beta 1.  

Can you update Remedy data via ODBC?  Well, with the ODBC drivers that Remedy supplies?  What's the workaround if you can't,,, just the API.

RE: Access Remedy Database from VB?

Hi all
well, my experiance with connecting to remedy was from ultradev and i found that ur select statment must have a 'where ' clause so it can retrive data ,i dont know y, but thats the way it works guy,...but my problem is that iwhen i test the statment it retrive rows but when i try to aply it , it give my an error ...unexpected end of the sql statement ..So any idea ??!!!!

RE: Access Remedy Database from VB?

I know that this is an old thread, but I have got Remedy reads working fine from VB6, Access and Excel QueryTables.

1.  Use the Remedy-supplied ODBC driver.
2.  SELECT syntax; fields are quote-encapsulated when longer than a single word and need CrLf breaks between SQL lines (& Chr(13) & "" & Chr(10)), so the query looks weird.  The following is an example:

strSQL = "SELECT Site, ""Reporting Type"", ""Request ID"", ""Create-date"", " & _
     """Requester Name +"", Status, ""Modified Date"", ""Short-Description"", ""Assignee Group"", " & _
     """Primary Assignee"", ""User Location"", ""Date Required"", SLA" & _
     Chr(13) & "" & Chr(10) & _
     "FROM ""QKAN Service Request""" & Chr(13) & "" & Chr(10) & _
     "WHERE (Status <> 'Closed') AND (Status <> 'Resolved') AND (Status <> 'Cancelled') " & _
     Chr(13) & "" & Chr(10) & _
     "ORDER BY ""Date Required"""

3.  You must have at least one WHERE clause, because Remedy generally won't let you perform unqualified SELECTs.

Hope this helps.

RE: Access Remedy Database from VB?

HI! Could you please provide me the stirng connection that you use to connect to the remedy database. I have one that works well by VB6 but by ASP it doesn´t work PLEASE HELP!!!!!

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! Already a Member? Login


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