July 1, 2014 at 9:24 pm
i am migrating the data from postgresql to sql server .
i have created DSN for postgresql connection
oledb source to oledb destination .
but i am unable to select created DSN from connection manger . its not visible there .its only showing sql server
related.
if i created a ODBC connection there but couldnt able to mapped it with OLEDB source as its showing sql server related.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 2, 2014 at 12:43 am
Again, DSN are for ODBC connections (which you can use in the ADO.NET connection managers).
It does not work with OLE DB.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2014 at 12:56 am
Koen,
first of all thanks for the regular support. 🙂
i need to make connection for postgresql . how can i ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 2, 2014 at 1:04 am
Bhuvnesh (7/2/2014)
Koen,first of all thanks for the regular support. 🙂
i need to make connection for postgresql . how can i ?
A little bit of Google won't hurt you.
SSIS: Connect to PostgreSQL[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 2, 2014 at 2:33 am
thanks koen , i googled these links ealrier too but couldnt get any help . i will come with complete issue details
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 2, 2014 at 10:40 am
when i create connection
this i got
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
------------------------------
BUTTONS:
OK
------------------------------
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 2, 2014 at 12:15 pm
Bhuvnesh (7/2/2014)
when i create connectionthis i got
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
------------------------------
BUTTONS:
OK
------------------------------
Did you install the 32-bit ODBC driver or 64-bit? If you have 32-bit only, set the Run64BitRuntime property of the project to False.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply