Re: Need help for @table_qualifier

Frediano Ziglio <[email protected]> Mon, 30 Oct 2017 17:43:47 +0000

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CAHt6W4eqah1VeghQcYtts_n62B-LG-7hOanV379XNsF=wYt7Ug@mail.gmail.com>

2017-10-26 13:38 GMT+01:00 Rajesh M <[email protected]>:
> 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