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

Hi Michael,

Aren't you setting the *Max Varchar* option as 254?
Please try to set the option >= the size of the column 'tagname'.

regards,
Hiroshi Inoue

On 2019/07/24 15:31, michael(dot)riksman(at)khalda-eg(dot)com wrote:
>
> Looks like it already is. This is what was created when the CREATE
> TABLES button was pressed in FactoryTalk;
>
> 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(dot)riksman(at)khalda-eg(dot)com
>
> *From:*Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> *Sent:* Wednesday, 24 July 2019 8:18 AM
> *To:* Michael Riksman (Salam - Gas)
> *Cc:* pgsql-odbc(at)postgresql(dot)org
> *Subject:* Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is
> not supported'
>
> Hi Michael,
>
> Do you define 'tagname' column of 'tagtable' as varchar with no column
> size?
> If so, please try to change the column as varchar(..) with a explicit
> column size less than 256 .
>
> regards,
> Hiroshi Inoue
>
> On 2019/07/23 15:12, michael(dot)riksman(at)khalda-eg(dot)com
> <mailto:michael(dot)riksman(at)khalda-eg(dot)com> wrote:
>
> Hi Hiroshi,
>
> Firstly;
>
> The changes you made meant that the ‘Create Tables’ is now
> working. Previously, it wouldn’t create ‘Float Table’ and ‘String
> Table’ – presumably because they were the two tables that had a
> TIMESTAMP column. I previously had to create them manually.
>
> Secondly;
>
> Now when I click 'OK', I get the following error instead. So it
> appears the TIMESTAMP issue is fixed (what was the problem!?), but
> now a new problem;
>
> I have attached the mylog log.
>
> Thanks for your time!
>
> 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(dot)riksman(at)khalda-eg(dot)com
> <mailto:michael(dot)riksman(at)khalda-eg(dot)com>
>
> -----Original Message-----
> From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
> Sent: Tuesday, 23 July 2019 7:07 AM
> To: Michael Riksman (Salam - Gas)
> Cc: pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org>
> Subject: Re: Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is
> not supported'
>
> Hi Michael,
>
> Could you please try the test drivers 11.00.0100 on Windows at
> https://winpg.jp/~inoue/psqlodbc/index.html
>
> ?
>
> regards,
>
> Hiroshi Inoue
>
> On 2019/07/23 13:24, michael(dot)riksman(at)khalda-eg(dot)com
> <mailto:michael(dot)riksman(at)khalda-eg(dot)com> wrote:
>
> > Hi Hiroshi,
>
> >
>
> > I’ll try anything! Would be great to use PostgreSQL with an
> industrial software like Rockwell.
>
> >
>
> > Thanks :)
>
> >
>
> > Regards,
>
> >
>
> > Michael Riksman
>
> >
>
> > Sent from iPhone
>
> >
>
> > On 23 Jul 2019, at 1:14 am, Inoue, Hiroshi
> <h-inoue(at)dream(dot)email(dot)ne(dot)jp <mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp>> wrote:
>
> >
>
> >  Hi Michael,
>
> >
>
> > Could you try the test driver if I provide a Windows test driver?
>
> >
>
> > regards,
>
> > Hiroshi Inoue
>
> >
>
> > On 2019/07/18 18:18,
> michael(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com
> <mailto:michael(dot)riksman(at)khalda-eg(dot)com%3cmailto:michael(dot)riksman(at)khalda-eg(dot)com>>
> wrote:
>
> > Hi,
>
> >
>
> >
>
> > ·         your ODBC driver version
>
> >
>
> > psqlODBC is v11.01.000.
>
> >
>
> >
>
> >
>
> > SQL_DRIVER_ODBC_VER reports “3.51”
>
> >
>
> > [6608-0.002] info.c[PGAPI_GetInfo]71: entering...fInfoType=77
>
> >
>
> > [6608-0.002] info.c[PGAPI_GetInfo]1032: p='03.51', len=0,
> value=0, cbMax=12
>
> >
>
> >
>
> >
>
> > ·         your PostgreSQL database version
>
> >
>
> > v10.9 x86
>
> >
>
> > Running on Windows 10 32-bit
>
> >
>
> >
>
> >
>
> > ·         any error messages you saw on the screen
>
> >
>
> > The client application (Rockwell FactoryTalk), has a button
> which can automatically create the tables in an existing database.
>
> > It created a table successfully that DID NOT have a TIMESTAMP
> column. But I had to manually create two tables that had a
> TIMESTAMP column.
>
> > When I clicked ‘OK’ to accept the changes, I get this error;
>
> >
>
> > <image001.png>
>
> >
>
> > FactoryTalk works fine with Microsoft SQL ODBC.
>
> >
>
> >
>
> > ·         the debug log (mylog_????.log) file (you will have to
> enable the mylog driver option)
>
> >
>
> > Attached.
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > I ran the ODBC Test tool, and connected via ODBC version 2 (as
> this is
>
> > what FactoryTalk appears to be using)
>
> > [2892-0.001]odbcapi30.[SQLSetEnvAttr]477: Entering att=200,2
>
> >
>
> > I then ran a GetTypeInfo on SQL_TIMESTAMP(11), and it returns
>
> > SQL_SUCCESS <image002.png>
>
> >
>
> > But in the logs, it shows this;
>
> > [6608-1677.216]odbcapiw.c[SQLGetTypeInfoW]1015: Entering
>
> > [6608-1677.216] info.c[PGAPI_GetTypeInfo]1115:
> entering...fSqlType=93
>
> > [6608-1677.216]statement.[SC_recycle_statement]812: entering
>
> > self=0052D2E0 [6608-1677.216] qresult.c[QR_Constructor]173:
> entering
>
> > [6608-1677.216] qresult.c[QR_Constructor]242: leaving
>
> > [6608-1677.216]statement.[SC_set_Result]531: (0052D2E0, 00539F48)
>
> > [6608-1677.216] qresult.c[QR_Destructor]344: entering
>
> > [6608-1677.216] bind.c[extend_column_bindings]718: entering ...
> self=0052D370, bindings_allocated=0, num_columns=19
>
> > [6608-1677.216] bind.c[extend_column_bindings]762: leaving 004F8C30
>
> > [6608-1677.216] qresult.c[QR_set_num_fields]40: entering
>
> > [6608-1677.216] qresult.c[QR_set_num_fields]44: leaving
>
> >
>
> > It appears the fSQLType changed from SQL_TIMESTAMP(11) to
> SQL_TYPE_TIMESTAMP(93)…? Could this be what is causing the issue?
>
> >
>
> >
>
> >
>
> > 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(dot)riksman(at)khalda-eg(dot)com<mailto:michael(dot)riksman(at)khalda-eg(dot)com
> <mailto:michael(dot)riksman(at)khalda-eg(dot)com%3cmailto:michael(dot)riksman(at)khalda-eg(dot)com>>
>

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com