Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
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!
- Posts: 1
- Joined: Tue Oct 20, 2009 1:20 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),
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:
So basically it displayed date field as SQL Server type datetime.
Is this similar to what you see in your tests?
- Site Admin
- Posts: 352
- Joined: Wed Oct 29, 2008 11:27 pm
Return to SQL Server/DTS/SSIS/Linked servers/Replication
Who is online
Users browsing this forum: Yahoo [Bot] and 3 guests