Connect Virtuoso with PostgreSQL

Hi Guys,
Im trying install virtuoso odbc driver to connect with postgress, created new dsn for postgress with settings but this error ,

SQLConnect failed
Error Message : [OpenLink][ODBC]RPC: Remote system error

Error Message : [OpenLink][ODBC]Connection rejected by data source

Thanks

Which OpenLink PostgreSQL ODBC Driver did you install, Single-Tier or Multi-Tier and what are the ODBC DSN params you have configured for connecting to the PostgreSQL database ?

The RPC: Remote system error implies the Multi-Tier product is being used and the OpenLink Request Broker (oplrqb) cannot be located on the specified hostname:portno.

Hi
I installed those links
PostgreSQL 7.x, 8.x, 9.x, 10.x, 11.x Database Agent (Multi-Threaded) Installer Archive for Generic Linux Glibc 2.12 (64 Bit) (x86_64) and Higher – Amazon S3 HTTP Depot

ODBC Data Source Administrator (HTTP) Installer Archive on Generic Linux Glibc 2.12 (64 Bit) (x86_64) and Higher – Amazon S3 HTTP Depot

Installation script for Enterprise and Lite Edition UDA Archives (*.taz)

The files are odbc_admin.taz, pgr7_lt.lic, pgr7_lt.taz and install.sh

The odbc parameter are:
[pg]
DeferLongFetch =
Description = postgress DSN
Options =
Host = database ip
Port = 5432
UseSSL =
UserName = db-username
ServerType = PostgreSQL
Driver = /root/openlinklite/lib/oplodbc.so
Database = databasename
ReadOnly =
NoLoginBox =
SqlDbmsName =
FetchBufferSize = 99

but the lg file contains

cn_dbport=[]
cn_svtype=[PostgreSQL]
cn_dbpath=[databasename]
cn_dbopts=[]
cn_readonly=0
cn_fetchSize=60
cn_deferLongFetch=0
cn_appname=[www_sv]
ConnOpen: Unable to allocate connection handle
[7F2CED954700] SQLDriverConnectW: returning SQL_ERROR

[7F2CED954700] SQLErrorW hDbc=20006
szSqlState=7FFE9720B8A0 pfNativeError=7FFE9720D2C8
szErrorMsg=1349BD0 cbErrorMsgMax=8192 pcbErrorMsg=7FFE9720D2CE
Returning RPC: Unable to receive
[7F2CED954700] SQLErrorW: returning SQL_SUCCESS

[7F2CED954700] SQLErrorW hDbc=20006
szSqlState=7FFE9720B8A0 pfNativeError=7FFE9720D2C8
szErrorMsg=1349BD0 cbErrorMsgMax=8192 pcbErrorMsg=7FFE9720D2CE
Returning Connection rejected by data source
[7F2CED954700] SQLErrorW: returning SQL_SUCCESS

Where is the error
Thanks

Well you clearly have installed the Multi-Tier Generic ODBC Client (oplodbc.so) at some point and that is what your DSN references, whereas it shouldbe referencing the PostgreSQL Lite ODBC Driver (pgr7_mt_lt.so) ie something like the following in your odbc.ini file:

Driver                  = /root/openlinklite/lib/pgr7_mt_lt.so
Cursor_Sensitivity      = Low
FetchBufferSize         = 60
UserName                = db-username
Database                  = databasename
MaxRows                 = 0
NoAutoCommit            = No
NoLoginBox              = No
ReadOnly                = No
Options                 = -H hostname -P 5432
DeferLongFetch          = No
MultipleActiveStmtsEmul = No
HSODBCFix               = No
IncludeViews            = No
IncludeAll              = No
JetFix                  = Yes
NoRowsetSizeLimit       = No

as detailed at http://wikis.openlinksw.com/UdaWikiWeb/InstallPostgreSQLLiteUnix

Hi
Thank you, I tried the steps in the link http://wikis.openlinksw.com/UdaWikiWeb/InstallPostgreSQLLiteUnix
Installed the files ( odbc_admin.taz, pgr7_lt.lic, pgr7_lt.taz and install.sh )
but the result is different
Started installation on : virtuoso-instance-linux-small
*

  • Temporarily saving your original ODBC DSN settings
  • (the file odbc.ini) to odbc.ini.save
  • Temporarily saving your original ODBC Installation settings
  • (the file odbcinst.ini) to odbcinst.ini.save
  • Temporarily saving your original UNIX Lite settings
  • (the file openlink.ini) to openlink.ini.save

Extracting (odbc_admin.taz) …
Extracting (pgr7_lt.taz) …
*

  • Restoring your original ODBC DSN settings
  • (the file odbc.ini) and created a new odbc.ini.sample
  • Restoring your original ODBC Installation settings
  • (the file odbcinst.ini) and created a new odbcinst.ini.sample
  • Restoring your original UNIX Lite settings
  • (the file openlink.ini) and created a new openlink.ini.sample

Creating link for Generic ODBC driver manager …
Welcome to the HTTP-based OpenLink ODBC Administrator Setup.

This program will install the HTTP-based OpenLink ODBC Administrator, ther
eby
enabling remote configuration for all OpenLink Drivers from any Web
Browser.

TCP/IP Port to use? [ENTER=8000] :
Log File? [ENTER=www_sv.log] :
Log all requests (y/n)? [ENTER=n] :
The HTTP-based OpenLink ODBC Administrator is now ready for use.
Please (re)start the HTTP-based OpenLink ODBC Administrator
(using the command ‘iodbc-admin-httpd.sh start’)
and then point your Web Browser to the URL below:
http://virtuoso-instance-linux-small:8000
Creating scripts …
End of installation

when i start the odbc administrator i get this error :
Error
No ODBC drivers installed on the server.

Thanks

Before starting the HTTP-based OpenLink ODBC Administrator ie http://virtuoso-instance-linux-small:8000 did you run the . ./openlink.sh script as specified in the documentation, which sets up the OpenLink environment, in particular the $ODBCINI & $ODBCINSTINI environment variables to enable the ODBC configuration files to be located ?

Also, what files are in the /root/openlinklite/lib/ directory assuming this is still where you installed the ODBC Driver ?

Thanks a lot, but i try use External Data Sources in database tab in Conductor Virtuoso 7.2 , i set this configures:
DSN pg10
Driver /root/virtuoso7212/lib/oplodbc.so

FetchBufferSize=60;
UserName= username;
Database=databse-name;
Host=databse-ip;
Port=5432;
MaxRows=0;
NoAutoCommit=No;
NoLoginBox=No;
ReadOnly=No;
Options=-H databse-ip -P 5432;
DeferLongFetch=No;
MultipleActiveStmtsEmul=No;
HSODBCFix=No;
IncludeViews=No;
IncludeAll=No;
JetFix=Yes;
NoRowsetSizeLimit=No;

I get this error: VD052: Remote DSN pg10: STATE[08004] [OpenLink][ODBC]RPC: Unable to receive

any idea,

Thanks

Why are you still referencing oplodbc.so as the ODBC driver file name, which as stated in a previous post is not the correct driver. You should be referencing pgr7_mt_lt.so as the PostgreSQL Lite ODBC Driver file.

Please provide the content of:

  1. $ODBCINI
  2. $ODBCINSTINI
  3. The /root/virtuoso7212/lib directory

Hi
I converted the referencing odbc driver in the odbc files into pgr7_mt_lt.so

odbc.ini
[ODBC Data Sources]
Local Virtuoso = OpenLink Virtuoso
Local Virtuoso (Unicode) = OpenLink Virtuoso
VOS = Virtuoso
pg10 = Postgress
[Local Virtuoso]
Driver = OpenLink Virtuoso
Address = localhost:1111
[Local Virtuoso (Unicode)]
Driver = OpenLink Virtuoso
Address = localhost:1111


[pg10]
Driver = /root/virtuoso7212/lib/pgr7_mt_lt.so
FetchBufferSize=60
UserName=db-username
Database=db-name
Host=db-ip
Port=5432
MaxRows=0
NoAutoCommit=No
NoLoginBox=No
ReadOnly=No
Options=-H db-ip -P 5432
DeferLongFetch=No
MultipleActiveStmtsEmul=No
HSODBCFix=No
IncludeViews=No
IncludeAll=No
JetFix=Yes
NoRowsetSizeLimit=No

odbcinist.ini
[Virtuoso]
Driver = /root/virtuoso7212/lib/virtodbc_r.so
UsageCount = 1
[ODBC Drivers]
OpenLink Virtuoso = Installed
OpenLink Virtuoso (Unicode) = Installed

pg10 = Installed

[virtuoso-odbc]
Driver = /root/virtuoso83/lib/virtodbc_r.so
[OpenLink Virtuoso]
Driver = /root/virtuoso7212/lib/virtodbc_r.so
[OpenLink Virtuoso (Unicode)]
Driver = /root/virtuoso7212/lib/virtodbcu_r.so
[pg10]
Driver = /root/virtuoso7212/lib/pgr7_mt_lt.so

The /root/virtuoso7212/lib directory:
oplodbc.so virt_dialect.jar virtjdbc4_2ssl.jar virtodbc_r.so
oplodbcu.so virtjdbc3.jar virtjdbc4.jar virtodbcu_r.so
pgr7_lt.lic virtjdbc3ssl.jar virtjdbc4ssl.jar virt_sesame2.jar
pgr7_mt_lt.lic virtjdbc4_1.jar virt_jena2.jar virt_sesame4.jar
pgr7_mt_lt.so virtjdbc4_1ssl.jar virt_jena3.jar
pgr7_mv.o virtjdbc4_2.jar virt_jena.jar

but i still give me

This site can’t be reached

virtuoso ip refused to connect.
I granted virtuoso ip on database server but still this error appear: VD052: Remote DSN PG: [OpenLink][ODBC][PostgreSQL Server]Connection refused

.

Thanks

The error is coming from the PostgreSQL server which is refusing the connection based on the connection parameters it has received, which may not just be the ip address the request is coming from.

I would suggest created an OpenLink ODBC trace such that we can see what DSN params are being passed at connect time.

Hi
I solved the problem with postgres and now connected but when i press on link objects i have this error:

An error has occurred when processing “/conductor/vdb_obj_link.vspx” page.

SQL State S1000
SQL Message VD052: Remote DSN PG: [OpenLink][ODBC][PostgreSQL Server] current transaction is aborted, commands ignored until end of transaction block

any idea,

Thanks

Can you create and provide an OpenLink ODBC trace such that we can see what ODBC call is resulting in the [PostgreSQL Server] current transaction is aborted, commands ignored until end of transaction block error.

Hi,
This is trace file content:
** iODBC Trace file
** Trace started on Wed Jan 22 16:04:46 2020
** Driver Manager: 03.52.1216.0712
[000000.000114]
virtuoso 7F401BCA7B80 ENTER SQLAllocEnv
SQLHENV * 0x198d000
[000000.000128]
virtuoso 7F401BCA7B80 EXIT SQLAllocEnv with return code 0 (SQL_SU$
SQLHENV * 0x198d000 (0x52d5890)

the odbcdebug file:

** OpenLink ODBC Trace file **
** started on Wed Jan 22 16:10:18 2020 **
Driver: 07.00.171020 OpenLink PostgreSQL Lite Driver
[7F753D6D4700] SQLAllocHandle
handleType=1
[7F753D6D4700] SQLAllocHandle: returning SQL_SUCCESS
[7F753D6D4700] SQLSetEnvAttr hEnv=10000
Attribute=200 ValuePtr=2 StringLength=0
[7F753D6D4700] SQLSetEnvAttr: returning SQL_SUCCESS
[7F753D6D4700] SQLAllocHandle hEnv=10000
handleType=2
[7F753D6D4700] SQLAllocHandle: returning SQL_SUCCESS
[7F753D6D4700] SQLSetConnectOption hDbc=20000
fOption=1051 vParam=18892673
[7F753D6D4700] SQLSetConnectOption: returning SQL_SUCCESS
[7F753D6D4700] SQLConnect hDbc=20000

[7F753D6D4700] SQLConnect hDbc=20000
szDSN=7F754C1AA2A8 cbDSN=-3 szUID=7F754C7AF6D8 cbUID=-3 szPWD=7F754C6216F$
DSN=PG;UID=username;PWD=***
connStr=[DSN]
key=[DSN] data=[PG] supplied=1
key=[DATABASE] data=[db-name] supplied=0
key=[OPTIONS] data=[-H db-ip -P 5432] supplied=0
key=[UID] data=[db-username] supplied=1
key=[READONLY] data=[No] supplied=0
key=[SVT] data=[PostgreSQL] supplied=0
key=[FBS] data=[99] supplied=0
key=[NLB] data=[No] supplied=0
key=[DLF] data=[No] supplied=0

key=[DRIVER] data=[] supplied=0
key=[NOAC] data=[No] supplied=0
key=[MAXROWS] data=[0] supplied=0
key=[INITSQL] data=[] supplied=0
key=[SQLDBMS] data=[] supplied=0
key=[NRSSL] data=[No] supplied=0
key=[MASE] data=[No] supplied=0
key=[IV] data=[No] supplied=0
key=[IA] data=[No] supplied=0
cn_svtype=[PostgreSQL]
cn_dbpath=[db-name]
cn_dbopts=[-H db-ip -P 5432]
cn_readonly=0
cn_fetchSize=99
cn_deferLongFetch=0
cn_jetfix=1
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[VIRTUOSO]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]

[7F753D6D4700] SQLError hDbc=20000
szSqlState=7F753D6C9B20 pfNativeError=7F753D6C9B2C
szErrorMsg=7F753D6C9910 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
Returning License not found
[7F753D6D4700] SQLError: returning SQL_SUCCESS

[7F753D6D4700] SQLError hDbc=20000
szSqlState=7F753D6C9B20 pfNativeError=7F753D6C9B2C
szErrorMsg=7F753D6C9910 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
Returning License not found
[7F753D6D4700] SQLError: returning SQL_SUCCESS
[7F753D6D4700] SQLError hDbc=20000
szSqlState=7F753D6C9B20 pfNativeError=7F753D6C9B2C
szErrorMsg=7F753D6C9910 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
returning NO_DATA_FOUND
[7F753D6D4700] SQLError: returning SQL_NO_DATA_FOUND
[7F753D6D4700] SQLFreeHandle hDbc=20000
handleType=2
[7F753D6D4700] SQLFreeHandle: returning SQL_SUCCESS
[7F753D6D4700] SQLFreeHandle hEnv=10000
handleType=1
[7F753D6D4700] SQLFreeHandle: returning SQL_SUCCESS
** finished on Wed Jan 22 16:10:18 2020 **
** normal end **

Thanks

The trace is showing a License not found error:

which is different to the previous error, and seems to imply your environment has not been setup to pick up the PostgreSQL Lite ODBC Driver license file pgr7_lt.lic, which is was doing previously as you were able to connect.

So you need to check your environment prior to starting Virtuoso and ensure when started the OpenLink License Manager (oplmgr) is pointing to a directory location where the pgr7_lt.lic. Basically if you place pgr7_lt.lic in the same location as your virtuoso.lic file then it should pick it up …

Hi
I review the liecense, it is exits, this is old log, I deleted the odbcdebug and odbctrace files and create new one, when i restart virtuoso , the log created and are different

This is odbctrace.log
** iODBC Trace file
** Trace started on Mon Jan 27 14:11:43 2020
** Driver Manager: 03.52.1216.0712
[000000.000146]
virtuoso 7F2B99D28B80 ENTER SQLAllocEnv
SQLHENV * 0x198d000
[000000.000176]
virtuoso 7F2B99D28B80 EXIT SQLAllocEnv with return code 0 (SQL_SU$
SQLHENV * 0x198d000 (0x56208a0)

and this is odbcdebug.log

** OpenLink ODBC Trace file **
** started on Mon Jan 27 14:20:32 2020 **

Driver: 07.00.171020 OpenLink PostgreSQL Lite Driver

[7F34B37FE700] SQLAllocHandle
handleType=1
[7F34B37FE700] SQLAllocHandle: returning SQL_SUCCESS

[7F34B37FE700] SQLSetEnvAttr hEnv=10000
Attribute=200 ValuePtr=2 StringLength=0
[7F34B37FE700] SQLSetEnvAttr: returning SQL_SUCCESS

[7F34B37FE700] SQLAllocHandle hEnv=10000
handleType=2
[7F34B37FE700] SQLAllocHandle: returning SQL_SUCCESS

[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=1051 vParam=18892673
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS

[7F34B37FE700] SQLConnect hDbc=20000
szDSN=7F34C05946D8 cbDSN=-3 szUID=7F34C0594738 cbUID=-3 szPWD=7F34C03C9B78 cbPWD=-3
DSN=PG;UID=db-user;PWD=***
connStr=[DSN]
key=[DSN] data=[PG] supplied=1
key=[DATABASE] data=[db-name] supplied=0
key=[OPTIONS] data=[-H db-ip -P 5432] supplied=0
key=[UID] data=[db-user] supplied=1
key=[READONLY] data=[No] supplied=0
key=[SVT] data=[PostgreSQL] supplied=0
key=[FBS] data=[99] supplied=0
key=[NLB] data=[No] supplied=0
key=[DLF] data=[No] supplied=0
key=[JET] data=[Yes] supplied=0
key=[DRIVER] data=[] supplied=0
key=[NOAC] data=[No] supplied=0
key=[MAXROWS] data=[0] supplied=0
key=[INITSQL] data=[] supplied=0
key=[SQLDBMS] data=[] supplied=0
key=[NRSSL] data=[No] supplied=0
key=[MASE] data=[No] supplied=0
key=[IV] data=[No] supplied=0
key=[IA] data=[No] supplied=0
cn_svtype=[PostgreSQL]
cn_dbpath=[db-name]
cn_dbopts=[-H db-ip -P 5432]
cn_readonly=0
cn_fetchSize=99
cn_deferLongFetch=0
cn_jetfix=1
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[VIRTUOSO]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
cn_needbind=1
cn_hasMoreRes=1
cn_hasParamOp=1
cn_hasScrlCurs=1
cn_hasDynMixCurs=1
cn_hasV2DAE=0
cn_spOutDeferFetch=0
cn_hasExecute2=1
autocommit=0
[7F34B37FE700] SQLConnect: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=23 rgbInfoValue=7F34C0593DE8 cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=24 rgbInfoValue=7F34C0593DEA cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetConnectOption hDbc=20000
fOption=5011 pvParam=7F34B37F44DE
[7F34B37FE700] SQLGetConnectOption: returning SQL_ERROR

[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=101 vParam=0
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=17 rgbInfoValue=7F34B37F4470 cbInfoValueMax=64 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=6 rgbInfoValue=7F34B37F4470 cbInfoValueMax=64 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=46 rgbInfoValue=7F34C059244C cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=23 rgbInfoValue=7F34C059244E cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLGetInfo hDbc=20000
fInfoType=24 rgbInfoValue=7F34C0592450 cbInfoValueMax=2 pcbInfoValue=0
[7F34B37FE700] SQLGetInfo: returning SQL_SUCCESS

[7F34B37FE700] SQLSetConnectOption hDbc=20000
fOption=102 vParam=0
[7F34B37FE700] SQLSetConnectOption: returning SQL_SUCCESS

[7F34B37FE700] SQLGetConnectOption hDbc=20000
fOption=5011 pvParam=7F34B37F44B8
[7F34B37FE700] SQLGetConnectOption: returning SQL_ERROR

[7F34B37FE700] SQLAllocStmt hDbc=20000
phstmt=7F34C03EF478
[7F34B37FE700] SQLAllocStmt: returning SQL_SUCCESS

[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10010 ValuePtr=7F34C03C3108 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS

[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10011 ValuePtr=7F34C03F0D88 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS

[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10012 ValuePtr=7F34C03F0DD8 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS

[7F34B37FE700] SQLGetStmtAttr hStmt=30000
Attribute=10013 ValuePtr=7F34C03EFF88 BufferLength=0 StringLengthPtr=00000000
[7F34B37FE700] SQLGetStmtAttr: returning SQL_SUCCESS

[7F34B37FE700] SQLTables hStmt=30000
szTableQualifier=0 cbTableQualifier=0 szTableOwner=0 cbTableOwner=0 szTableName=0 cbTableName=0 szTableType=0 cbTableType=0
Qualifier=’’ Owner=’%’ Name=’%’ Type=’’

[7F34B37FE700] SQLTables: returning SQL_ERROR

[7F34B37FE700] SQLError hStmt=30000
szSqlState=7F34B37F44D0 pfNativeError=7F34B37F44DC
szErrorMsg=7F34B37F42C0 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
Returning [PostgreSQL Server] current transaction is aborted, commands ignored until end of transaction block
[7F34B37FE700] SQLError: returning SQL_SUCCESS

[7F34B37FE700] SQLError hStmt=30000
szSqlState=7F34B37F44D0 pfNativeError=7F34B37F44DC
szErrorMsg=7F34B37F42C0 cbErrorMsgMax=500 pcbErrorMsg=198CFE0
returning NO_DATA_FOUND
[7F34B37FE700] SQLError: returning SQL_NO_DATA_FOUND

[7F34B37FE700] SQLFreeStmt hStmt=30000
fOption=1
[7F34B37FE700] SQLFreeStmt: returning SQL_SUCCESS

[7F34B37FE700] SQLTransact hDbc=20000
fType=1
[Rollback]
[7F34B37FE700] SQLTransact: returning SQL_SUCCESS

[7F34C67FC700] SQLTransact hDbc=20000
fType=1
[Rollback]
[7F34C67FC700] SQLTransact: returning SQL_SUCCESS

[7F34C67FC700] SQLDisconnect hDbc=20000
[7F34C67FC700] SQLDisconnect: returning SQL_SUCCESS

[7F34C67FC700] SQLFreeHandle hDbc=20000
handleType=2
[7F34C67FC700] SQLFreeHandle: returning SQL_SUCCESS

[7F34C67FC700] SQLFreeHandle hEnv=10000
handleType=1
[7F34C67FC700] SQLFreeHandle: returning SQL_SUCCESS

** finished on Mon Jan 27 14:37:13 2020 **
** normal end **

Thanks

What version of PostgreSQL are you running ?

Can you replace the the current pgr7_mt_lt.so with this updated version , restart Virtuoso and repeat the test to see if this resolves the problem …

Hi,
version of PostgreSQL: PostgreSQL 9.6.15
I replaced the current pgr7_mt_lt.so with updated version
but the connection need upgrade license and this error happened.

An error has occurred when processing “/conductor/vdb_obj_link.vspx” page.

SQL State 08U01
SQL Message VD052: Remote DSN PG: STATE[08004] [OpenLink][ODBC]Product requires a license upgrade

what is the version for license

Thanks

What version of the OpenLink PostgreSQL Lite ODBC Driver did you download, as I provided a latest Release 8 driver, but seems you are using an earlier release driver current hence the license upgrade error.

You can obtain a Linux PostgreSQL Lite ODBC evaluation license from here and replace the existing pgr7_lt.lic with it and restart Virtuoso …

Hi hwilliams,
OpenLink PostgreSQL Lite ODBC Driver (latest).
I replaced the license, now it works well.
Thanks a lot.