Can not able to see 64 bit ODBC driver from SSIS odbc connection

Hi,

I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.

When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.

I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

Can any one please suggest me why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ??

Thanks,

Nag.

May 31st, 2015 1:14pm

Your issue with SQL Server Integration Services and ODBC DSN connections appears to be unrelated to .NET Framework setup (this forum's topic).

I suggest that you ask in the SSIS forum, here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

Free Windows Admin Tool Kit Click here and download it now
May 31st, 2015 7:09pm

Hi Nagarjuna.kt,

As pvdg42 said, your issue is about the SQL Server Integration Services and ODBC DSN connections. The SSIS forum is more proper and I will help you move it to the SSIS forum.

Best Regards,

JiayiLi

May 31st, 2015 10:29pm

Hi,

I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.

When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.

I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

Can any one please suggest me why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ??

Thanks,

Nag.
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2015 12:48am

Thank u pvdg42

June 1st, 2015 1:36am

Thank u JiayiLi
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2015 1:36am

Thank u JiayiLi

If you're refering to SSIS development environment ie BIDS/SSDT then please keep in mind that its a 32 bit application by itself and hence cant find 64 bit DSNs. You can still use them vis dtexec while executing package from the servers

See this article which discusses the issue in details

http://timlaqua.com/2011/11/ssis-bids-and-64bit-system-dsns-whos-on-first/

June 1st, 2015 1:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics