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
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?
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?
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?
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?