Hi,

I'm using SQL passthrough on an Oracle-environment.

I have used the SQLORA SET SERVER <servername> syntax with success...but recently our admins changed the username/schemaname in our EDASPROF.CFG and all of a sudden my reports don't run...

The fact that I have to use SET SERVER is a bit of an administrative nightmare...is there any way to tell which connection should be used as default in EDASPROF.CFG???

While testing it's OK to specify adapter to use but I would like to skip that once the report moves to our PROD environment...

Ideas??
Know-how???

Ted

We are using Microsoft SQL server and have multiple connections in our edasprof.cfg. The first one is always the default when a .fex is executed.

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES DBIBS USBOSIBS01D/,;dbIBSD1

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES DBMNT USBOSIBS01D/redsox,EDC3C365FB87FF9D;DBMNTD1

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES DBIBSTEST HOUSQLT3/,;dbIBSP1

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES DBIBSDEV HOUSQLD3/,;dbIBSP1

This is what we would have in a .fex do execute a SQL proc.

SQL SQLMSS EX p_get_rpt_as_of_date_current;

The proc would be executed on the default connection:


ENGINE SQLMSS SET CONNECTION_ATTRIBUTES DBIBS USBOSIBS01D/,;dbIBSD1

Would stating the schema name in your pass-through be better then stating the server name?

If you don't have schema's that are named the same in other data connections this should work for you.