Обсуждение: 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