Creating proxy table in IQ pointing to AE table does not work, I wonder why

[Former Member]

We would like to create proxy table in IQ 15.4 latest patches applied, real table being in ASE, we use aseodbc connection. At the creation of  the proxy table we are faced with the following error:

Could not execute statement.

  SQL Anywhere Error -656: Unable to connect to server 'ASE_SERVER_NAME':

  [Sybase][ODBC Driver Manager] Data source not found and no default

  driver specified

  Sybase error code=11206, SQLState="WO001"

  Line 1, column 1

  create existing table TOTO at 'ASE_SERVER_NAME.myDB.dbo.TOTO_ON_ASE'

we have tried to put the columns description in teh create statement it doe snot chnage anything at all.

Unfortunately our dbas do not know much about IQ. One of them has opened a case with SAP.sybase; no reaction from them as yet after 10 days

Please help us advance with our work.

All you help and suggestions are gratefully appreciated.

Ahmad.

[tayeb_hadjou · Accepted solution]

H Ahmad,

With aseodbc class, remote ASE server should be created with command

CREATE SERVER ASE_SERVER_NAME CLASS 'aseodbc' USING 'asedsn_name' ;

Where 'asedsn_name' is a loal valid ASE ODBC DSN connection.

And the current IQ user/password should exist in ASE db or mapped to ASE user.

See CREATE EXTERNLOGIN command.

ASE Odbc connection should be first created using ASE odbc driver (installed from ASE SDK15.x) and tested with success.

To test remote connection from IQ before creating the proxy table, you can use

FORWARD to ASE_SERVER_NAME;

select @@version ;

FORWARD to;

If the purpose is only to copy data from ASE to IQ, then no need to use CIS (remote server, ..).

You can just add ASE connection in local interface file (with IQ installation) and use insert ..location syntax

Example :

INSERT into local_table LOCATION ‘ase_srv.ase_db’ {SELECT * FROM ase_table} ;

Where ase_srv is the interfaces entry for ASE connection.

Moreover this is the recommended way to copy from ASE to IQ in addition of "bcp out"/ load.

Regards,

Tayeb.

[Former Member · Accepted solution]

Thanks for you suggestions, I shall ask the dba to run as you suggested.

As for your proposition regarding insert location, we are aware that this can be done.

In our context of work we can not do it as this is a user based application, each time what is required from ASE varies from one user to another.

I shall let you know if we can make your suggestion work.

Ahmad.