Обсуждение: Lotus Domino and PostgreSql in Linux
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.
I'm working on pgSQL integration with Domino6 (DECS, LCLSX) (there will be documentation in the coming weeks). I have a question a couple of questions for you: 1) Are you using Domino 6 or 5.x 2) In your DSN setup on (NT?) do you have the valid account information to connect to Pg? 3) If you are running agent are you sure you have the security structure that will permit that? For instance, in Domino 6 DECS (unlike DCR's) require admin priviledge to set up (which probably in not the same as the designer privs). In addition, there is an option you set for the database to allow external connection. Once that is done you have to make sure any agents running against this database have the appropriate privs as well Hope this help a bit. I'm on the same journey too :) Quoting Kallol Nandi <kallol.nandi@indussoft.com>: > 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. > ____________________________________ This email account is being host by: VCSN, Inc : http://vcsn.com