Skip to Content.
Sympa Menu

freetds - Re: [freetds] Need help for @table_qualifier

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Need help for @table_qualifier
  • Date: Mon, 30 Oct 2017 17:43:47 +0000

2017-10-26 13:38 GMT+01:00 Rajesh M <raj4721 AT gmail.com>:
> Hello Team,
>
> Connection from Oracle to MS SQL working fine. But when passing below query
> like
>
> sp_columns
> @table_name='slcustm_sap',@table_owner='test_owner',@table_qualifier='test_qualifier',@ODBCVer=3
>

How do you pass this query?
Do you have a TDSDUMP?
Network trace?
Or the query should be generated by FreeTDS ODBC driver?

>
> but what is seen by mssql as
>
> sp_columns @table_name='slcustm_sap',@table_owner='test_owner',@ODBCVer=3
> with no table_qualifier
>
> query I have is from where Oracle picks up table_qualifier details
>
> 1. odbc.ini 2. init*.ora for DG4ODBC 3. dblink or any other place ?
>
> Thanks
> Raj

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page