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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy