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