Attempting to access SQL table via IQD

[biinsguy]

I am trying to build an IQD file called "test.iqd" that I can pass to Transformer to allow me direct access to a SQL server database w/out having to go through Impromptu, Architect or Framework Manager. 

Below is the code I am using:

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Test_Source
DATASOURCENAME,E:\test.iqd
BEGIN SQL
{select Policy_Base
from dbo.Policy}

END SQL
COLUMN,0,Policy_Base


I set up my Cognos.ini file w/ the following:

[Databases]
GOS=;LOCAL;OD;DSN=GOScer4@ASYNC=0@0/0
GOV=;LOCAL;OD;DSN=GOVcer4@ASYNC=0@0/0
GODW=;LOCAL;OD;DSN=GODWcer4@ASYNC=0@0/0
GOMR=;LOCAL;OD;DSN=GOMRcer4@ASYNC=0@0/0
I71_DBASE_NTV_PP71_SAMPLE=;LOCAL;DB;C:\Program Files\Cognos\cer4\samples\PowerPlay\database@OEM
GREAT OUTDOORS=;LOCAL;OD;DSN=GREAT OUTDOORS@ASYNC=0@0/0
Test_Source=^User ID:^?Password:;LOCAL;OD;DSN=Test_Source;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=


I also created an ODBC definition called "Test_Source".

The error message I am getting is as follows:

(TR0118) Transformer can't read the database [Test_Source] defined in E:\test.iqd.

I have read the posts on this subject but I seem to be missing something.  Any help would be greatly appreciated.

Thanks.

[atnaatna]

The only thing I can think of is you may need to qualify your table name, so for example:

select Policy_Base
  from somedatabase.dbo.Policy

where "somedatabase" is the name of your database instance.