RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'

Поиск
Список
Период
Сортировка
От
Тема RE: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'
Дата
Msg-id 8d59c6fb05384b0a9b3352dea36c5ca2@SB-MBX-02.KHALDA-EG.com
обсуждение исходный текст
Ответ на Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список pgsql-odbc

Hey,

 

I’m not sure what happened, but after restarting the PC, it started working. I am sure I restarted after installing the driver, but perhaps I didn’t…?

 

But we have data!

 

THANK YOU SO MUCH!

 

I am curious – what was the original error with TIMESTAMP? What lines of code did you change?

 

Thanks.

 

 

Regards,

 

Michael Riksman

Instrument and Control Specialist

Khalda Petroleum Co.

A KPC/Apache Corp. Joint Venture

Salam Base, Egypt

Mob: +20 122 0530603

Email: michael.riksman@khalda-eg.com

 

From: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
Sent: Friday, 26 July 2019 2:29 PM
To: Michael Riksman (Salam - Gas)
Cc: pgsql-odbc@postgresql.org
Subject: Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'

 

Hi,

On 2019/07/25 15:27, michael.riksman@khalda-eg.com wrote:

Hey,

 

I turned it on;

 

But the only time something is written to the trace is when I open up the configuration window, and click OK;

 

postgreSQL

51 ‘Tags in Model’

SQLpostgres.LOG

Microsoft SQL

17 ‘Tags in Model’

SQLmsql.LOG

 

 

But when I right-click and start the DataLog;

 

 

Nothing is added to the SQL.LOG file/ODBC Tracing.

 

 

Data is successfully being logged to Microsoft SQL at this point – but still no additional data in the ODBC Tracing.


So there seems no ODBC API call.
Would you like to see the page www.plctalk.net/qanda/archive/index.php/t-109368.html ?

regards,
Hiroshi Inoue


 

Regards,

 

Michael Riksman

Instrument and Control Specialist

Khalda Petroleum Co.

A KPC/Apache Corp. Joint Venture

Salam Base, Egypt

Mob: +20 122 0530603

Email: michael.riksman@khalda-eg.com

 

ウイルス フリー。 www.avg.com

 

Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Xuesong Gao
Дата:
Сообщение: psqlodbc - prepared statement crash
Следующее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'