can you connect and extract data from remedy using a remedy driver and .NET application

Has anyone ever tried this.

I am trying to do it using vbscript in SSIS.

Get a S000 AR Remedy driver No Data found error.

Thanks

YRKS
YRKSAsked:
Who is Participating?
 
TimConnect With a Mentor Business Systems AnalystCommented:
We use the standard AR System ODBC Driver that is installed with the Remedy components.  It works well for most ODBC connections.  Apart from that, you'll probably want to use a driver specific to the database that is storing the data.
0
 
YRKSAuthor Commented:
Do you use a DSN CONNECTION OR DSN less odbc Connection?
0
 
TimConnect With a Mentor Business Systems AnalystCommented:
DSN.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
YRKSAuthor Commented:
Could you let me know what wrong I am doing here in the vb script below.
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.Data.Odbc
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Xml

Public Class ScriptMain

      ' The execution engine calls this method when the task executes.
      ' To access the object model, use the Dts object. Connections, variables, events,
      ' and logging features are available as static members of the Dts class.
      ' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
      '
      ' To open Code and Text Editor Help, press F1.
      ' To open Object Browser, press Ctrl+Alt+J.

      Public Sub Main()
            '
        ' Add your code here




        Dim conn As Odbc.OdbcConnection
        Dim comm As Odbc.OdbcCommand

        'Dim conn As Odbc.OdbcConnection
        'Dim comm As Odbc.OdbcCommand
        Dim connectionString As String
        Dim objReader As Odbc.OdbcDataReader
        connectionString = "DSN=MYDSN;UID=uSERid;Pwd=MYpaSSWORD;Driver={AR System ODBC Driver}; arserver=MYSERVER; arserverport=8888;  aruseunderscores=1; server=MYSERVER;"
       
        conn = New Odbc.OdbcConnection(connectionString)

        comm = New Odbc.OdbcCommand("select cOLUMN1, CoLUMN2 from TABLE1 WHERE ID='CYYYYY00000000038'", conn)
        conn.Open()
        ''       Dim myReader As Odbc.OdbcDataReader
        ''      myReader = comm.ExecuteReader()
        ' Always call Read before accessing data.
        ''    While myReader.Read()
        ''Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
        '' + myReader.GetString(1))
        ''End While
        ' always call Close when done reading.

        ''myReader.Close()
        Dim ODBCdata As Odbc.OdbcDataAdapter


        ODBCdata = New Odbc.OdbcDataAdapter("select cOLUMN1, CoLUMN2 from TABLE1 WHERE ID='CYYYYY00000000038'", conn)
        Dim table As New DataTable




        Dim recordCount As Integer







        recordCount = ODBCdata.Fill(table)  ---this is where it errors out


        MsgBox(recordCount)






        ODBCdata.Dispose()



        ' Close the connection when done with it.
        conn.Close()



        'objReader = comm.ExecuteReader()
        Dts.TaskResult = Dts.Results.Success
    End Sub

End Class
0
 
Reza RadConsultant, TrainerCommented:
what is the error you received exactly?
0
 
YRKSAuthor Commented:
I was not using the odbc connection properly.

Thanks for your help.
0
 
TimBusiness Systems AnalystCommented:
Ty!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.