July 1, 2014 at 12:53 am
i need to transfer data from sql server 2008 r2 to postgresql .
but i am not able to setup system DSN for OLE DB connection manager . Please help.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 1, 2014 at 12:58 am
Don't you mean ODBC instead of OLE DB?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 1, 2014 at 1:02 am
so which DSn i need to use for postgresql from drop down ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 1, 2014 at 1:05 am
Bhuvnesh (7/1/2014)
so which DSn i need to use for postgresql from drop down ?
You should create a system DSN first on the machine, using a Postgresql driver.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply