Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmooney
Starting Member
3 Posts |
 Posted - 2012-01-25 : 08:46:56
|
| Trying to connect to Teradata using MSDASQL in order to issue commands through OLE DB Command (only way in 64 bit?) but cannot see the OLE DB for ODBC provider (MSDASQL) in the OLEDB provider drop down. It is installed - I can see it in Management Studio and through Regedit - but cannot work out how to get it available in BIDS.Also cannot see the Teradata OLE DB provider in Management Studio but can in BIDS which would allow me to create a linked server.Have been trying on and off for months? Any ideas.Dev system is 32 bit WinXP SP3, Live system is Server 2008 64 bit running SQL 2008 R2 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-25 : 09:54:27
|
| try executing package using 32 bit options (ie set 64bitRuntime to false)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dmooney
Starting Member
3 Posts |
Posted - 2012-01-25 : 10:04:22
|
| It's not the execution that is the problem. I execute already in 32 bit but that rather defeats the object of deployment on 64 bit. The problem is at design time where the OLE DB ODBC provider option is not available. According to Teradata forums using the OLE DB ODBC route allows me to run in 64 bit mode thereby taking full advantage of 64 bit ServerD Mooney |
|
|
|
|
|
|
MSDASQL and BIDS