Hi Inoue-san, Hi Dang, Doesn't your odbc.ini or connection string contain SOCKET option?odbc.ini does not contain SOCKET option.I will check the app whether contain it in connection string or not.And reply you soon.
Hi Dang, Doesn't your odbc.ini or connection string contain SOCKET option?
Thanks and best regards.bocap regards, Hiroshi InoueOn 2016/02/11 8:44, Dang Minh Huong wrote:Hi Inoue-san,Sorry for my lately response.I am not remember exactly now, but they are like below.# only connection related parameters odbc.ini[PostgreSQL]Driver = PostgreSQLDriverDatabase = testdbServername = localhostUserName = postgresPassword = postgresPort = 5432odbcinst.ini[PostgreSQLDriver]Description = PostgreSQL DriverDriver = [path to libodbcpsqlw.so file]Thanks and best regards,bocapOn Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote: Hi Dang, Thanks. How are you setting your ODBC.INI(and ODBCINST.INI)? regards, Hiroshi InoueOn 2016/02/10 12:20, Dang Minh Huong wrote:Hi Inoue-san, Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use? It is about 5 connections. And one of them do almost task. DB lock wait also not occured as my confirm.Multi-thread is used but we do not using multi-thread in the same connection.# multi-process is not used in the app.Thanks and best regards,bocap regards, Hiroshi Inoue
regards, Hiroshi InoueOn 2016/02/11 8:44, Dang Minh Huong wrote:Hi Inoue-san,Sorry for my lately response.I am not remember exactly now, but they are like below.# only connection related parameters odbc.ini[PostgreSQL]Driver = PostgreSQLDriverDatabase = testdbServername = localhostUserName = postgresPassword = postgresPort = 5432odbcinst.ini[PostgreSQLDriver]Description = PostgreSQL DriverDriver = [path to libodbcpsqlw.so file]Thanks and best regards,bocapOn Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote: Hi Dang, Thanks. How are you setting your ODBC.INI(and ODBCINST.INI)? regards, Hiroshi InoueOn 2016/02/10 12:20, Dang Minh Huong wrote:Hi Inoue-san, Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use? It is about 5 connections. And one of them do almost task. DB lock wait also not occured as my confirm.Multi-thread is used but we do not using multi-thread in the same connection.# multi-process is not used in the app.Thanks and best regards,bocap regards, Hiroshi Inoue
Hi Inoue-san,Sorry for my lately response.I am not remember exactly now, but they are like below.# only connection related parameters odbc.ini[PostgreSQL]Driver = PostgreSQLDriverDatabase = testdbServername = localhostUserName = postgresPassword = postgresPort = 5432odbcinst.ini[PostgreSQLDriver]Description = PostgreSQL DriverDriver = [path to libodbcpsqlw.so file]Thanks and best regards,bocapOn Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote: Hi Dang, Thanks. How are you setting your ODBC.INI(and ODBCINST.INI)? regards, Hiroshi InoueOn 2016/02/10 12:20, Dang Minh Huong wrote:Hi Inoue-san, Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use? It is about 5 connections. And one of them do almost task. DB lock wait also not occured as my confirm.Multi-thread is used but we do not using multi-thread in the same connection.# multi-process is not used in the app.Thanks and best regards,bocap regards, Hiroshi Inoue
On Feb 10, 28 Heisei, at 22:24, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote: Hi Dang, Thanks. How are you setting your ODBC.INI(and ODBCINST.INI)? regards, Hiroshi InoueOn 2016/02/10 12:20, Dang Minh Huong wrote:Hi Inoue-san, Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use? It is about 5 connections. And one of them do almost task. DB lock wait also not occured as my confirm.Multi-thread is used but we do not using multi-thread in the same connection.# multi-process is not used in the app.Thanks and best regards,bocap regards, Hiroshi Inoue
Hi Inoue-san, Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use? It is about 5 connections. And one of them do almost task. DB lock wait also not occured as my confirm.Multi-thread is used but we do not using multi-thread in the same connection.# multi-process is not used in the app.Thanks and best regards,bocap regards, Hiroshi Inoue
Hi Dang,On 2016/02/09 20:13, Dang Minh Huong wrote:Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information. Are your applications multi-threaded or multi-process? How many connections do your applications use?
Hi Inoue-san,Thanks for response.And so sorry for disturbing you at this time.Please ask if you need aditional information.
regards, Hiroshi Inoue
pgsql-odbc by date:
Соглашаюсь с условиями обработки персональных данных