[dba-SQLServer] SQL Server linked to Teradata

They went ahead and created some 'permanent' tables.  For now...I'm gonna give up on dropping the tables from SQL Server.
 
Thanks again for the assistance.
 
Mark A. Matte

----------------------------------------
> Date: Thu, 26 Mar 2009 15:32:40 -0700
> From: fhtapia at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] SQL Server linked to Teradata
>
> 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 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
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
_________________________________________________________________
Quick access to Windows Live and your favorite MSN content with Internet Explorer 8.
http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A