Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Postby vinokur » Tue Oct 20, 2009 1:24 pm

selecting a date column not timestamp from postgresql - thru linkserver 2005 standard 64bit.
all other datatypes work.

Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Please let me know how to get thur this!

Thanks
Mike
vinokur
 
Posts: 1
Joined: Tue Oct 20, 2009 1:20 pm

Re: Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Postby Moderator » Thu Oct 22, 2009 8:34 pm

From e-mail to Mike:
I’ve performed the following test:
1. Created table in Postgres
CREATE TABLE mytest
(
id integer NOT NULL,
strcol character varying(50),
txtcol text,
modified date NOT NULL default now()
)
2. Added a few test rows.
3. Executed query via linked server:
select * from pgnpww.postgres.[public].mytest
Here is result:
<<picture>>
So basically it displayed date field as SQL Server type datetime.

Is this similar to what you see in your tests?
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 2 guests

cron