Francisco Tapia
fhtapia at gmail.com
Thu Mar 26 17:32:40 CDT 2009
That's a good point, which teradata driver did you load? I know often times the vendor will have newer versions of said drivers, (ala oracle) where you can update your oledb driver so that it works better with the 3rd party database. again I am not at all familiar with teradata to be very useful beyond Google searches. -Francisco http://sqlthis.blogspot.com | Tsql and More... On Thu, Mar 26, 2009 at 2:35 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > ODBC drivers have various levels of conformance. > > I've run into some that are very basic (don't ask me what I think of Jade) > > Many proprietary systems are not even relational databases as we know them, > they are > Object Oriented and the ODBC driver is based on virtual tables - which of > necessity limits > much of the DDL part of ODBC. (don't ask me what I think of Jade) > > It's quite possible that the Teradata ODBC driver just doesn't support what > you are trying to > do. > > -- > Stuart > > On 26 Mar 2009 at 14:45, Mark A Matte wrote: > > > > > Thanks Francisco, > > > > I've hit almost every site google found that mentioned Teradata or linked > servers. The one funny part...is I CAN do this with Access as a > pass-through query. > > > > Anything you find would be much appreciated...but I would not expect you > to put too much effort into it. > > > > Thanks again, > > > > Mark > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >