I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY.
But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers.
Has anyone have any experience with 64 bit SQL 2005 and Teradata?
Looked at other 3rd party vendors such as ETI but their documentation excludes IA 64 (Itanium).
Planning to try again using the 64 bit ODBC and .Net Adapter but I'm interested to hear if someone (MSFT & NCR) would have a real solution for 64 bit.
Thanks
Anatole
I'm replying to my own thread as I want to see who else is having the same issue using Teradata Drivers and SSIS (32 or 64 bit).
I think this is a given where the Teradata OLE-DB driver is failing when used as a SQL Stmt rather than Table/View to extract data.
The message is:
An OLE DB error has occurred. Error code: 0x80040E21.An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
Has anyone found a work-around and/or contacted MS about this?
I opened a ticket with teradata/ncr but they are pointing back at SSIS and MS.
This error can occur on any box/cpu (32 bit or 64bit).
Since ODBC adaptor in SSIS converts everything into UNICODE, the only option is to use Linkedserver and OPENQUERY cmd.
I would like to hear back from MS (I know thay have teradata servers) or anyone that has either received this error and has a solution OR is also waiting on one.
Thanks
Anatole
|||
Anatole,
Take a look at :
www.openlinksw.com/
They seem to have an IA64 OLE to ODBC driver. I am not sure I even understand the issue well enough, but we had a similar issue and found them, we are still looking to see if they can solve our issue witch is with Sybase and SQL, but I thought I would just throw it out there for you since you had not gotten anyone to reply back, it might at least give you a better lead....
Hope it helps...
Steve
|||2 other potential resources are:
www.odbcsdk.com
This is another Third Party (Open Access) that advertises a 64bit OLEDB to ODBC Data Provider (Itanium).
http://www.datadirect.com/products/odbc64/overview/index.ssp
This is another Third Party (DataDirect) that advertises a 64bit Sybase ODBC driver (Itanium)
Just trying to be helpful for people running into these types of problems....Hopefully this is helpful...
Steve
|||Hi!
See also my similar question (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=853174&SiteID=1&mode=1).
I can't work out your suggestion using a ".net ODBC".
B.G.
sql
No comments:
Post a Comment