Lotus Domino and PostgreSql in Linux
| От | Kallol Nandi |
|---|---|
| Тема | Lotus Domino and PostgreSql in Linux |
| Дата | |
| Msg-id | NBEDKIHMDKLGDCDIJLMMMEGJCAAA.kallol.nandi@indussoft.com обсуждение исходный текст |
| Ответы |
Re: Lotus Domino and PostgreSql in Linux
|
| Список | 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
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.
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?
Is there any way to solve it?
Regards,
Kallol.
В списке pgsql-general по дате отправления: