Lotus Domino and PostgreSql in Linux

From: "Kallol Nandi" <kallol(dot)nandi(at)indussoft(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Lotus Domino and PostgreSql in Linux
Date: 2003-06-23 13:24:24
Message-ID: NBEDKIHMDKLGDCDIJLMMMEGJCAAA.kallol.nandi@indussoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running an agent in the domino server that connects to a database in
Postgresql through odbc dsn.Both are installed in the same Linux box.
I am getting an error "Error Creating product object" at the line
Set con = New ODBCConnection

Here is the code :

Option Public
Uselsx "*LSXODBC"

Sub Initialize

Dim con As ODBCConnection
Dim qry As ODBCQuery
Dim result As ODBCResultSet
Dim id As Integer
Dim nam As String,job As String

Am getting Error here
Set con = New ODBCConnection
Set qry = New ODBCQuery
Set result = New ODBCResultSet
Set qry.Connection = con
Set result.Query = qry

status = con.ConnectTo("debug")
qry.SQL = "select * from testtable"
result.Execute
Do
result.NextRow
id = result.GetValue("a", id)
nam = result.GetValue("b", nam)
Loop Until result.IsEndOfData
result.Close(DB_CLOSE)
con.Disconnect
End Sub

I guess it is an error related to Domino.
But not sure..... may be related to the ODBC driver also.
Is there any way to solve it?

Regards,
Kallol.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2003-06-23 14:23:23 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message scott.marlowe 2003-06-23 13:22:40 Re: [GENERAL] interesting PHP/MySQL thread