[Database] entries in cs7g.ini

[LEO]

Hi,

In order to start using the Transformer for building cube,
I want to make an entry for my target database(sql server sql server authentication) connection in the "cs7g.ini" file.

I copied the connection string from Cognos Connection which is as below
;^User ID:^?Password:;LOCAL;OD;DSN=Mart_LX;UID=%s;PWD=%s;@ASYNC=0@0/0@COLSEQ=

I made the entry in cs7g.ini as below:
[Databases]
Mart=;^User ID:^?Password:;LOCAL;OD;DSN=Mart_LX;UID=%s;PWD=%s;@ASYNC=0@0/0@COLSEQ=

But it's not working and the "Mart" is not accessible. How do i need to provide the user login details(user and password) in the above entry.

[Michael75]

Apparently you are starting a new cube. You only need the "cs7g.ini" file if you are going to use .iqd datasources.

Why not use reports or packages for your datasources?

[LEO]

hi michael,

we have cubes alreday designed using iqd files. In one of the systems, it worked where, we have windows authentication mode for sql server.

For the system where we have sql server authentication mode, i need to test it ad provide username/password.

Hence , I made the entry in cs7g.ini as below:
[Databases]
Mart=;^User ID:^?Password:;LOCAL;OD;DSN=Mart_LX;UID=%s;PWD=%s;@ASYNC=0@0/0@COLSEQ=

but it's not working.

[RKMI]

Hi,

I'm not entirely following, but I found this might help.

[Databases]
Mart=;^User ID:^?Password:;LOCAL;OL;DBInfo_Type=MS;Provider=SQLOLEDB;User ID=%s;Password=%s;Data Source=Mart;Provider_String=Initial Catalog=Mart_LX;@COLSEQ=

or these links might help,
http://www-01.ibm.com/support/docview.wss?uid=swg21342791
http://www-01.ibm.com/support/docview.wss?uid=swg21344045

Thanks,
RK

[MMcBride]

Mart=;^User ID:^?Password:;LOCAL;OD;DSN=Mart_LX;UID=%s;PWD=%s;@ASYNC=0@0/0@COLSEQ=

Try

Mart=^User ID:^?Password:;LOCAL;OD;DSN=Mart_LX;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ=

I have 25 different entries in my cs7g.ini and none have that leading ";" that you have or after the PWD=%s