Impromptu Query Server Error 1

[po944he]

I am converting a user from a win98 desktop to a win2K laptop the Costpoint and Sql-Talk run fine but Impromptu gives me an error when I try to open something from the network, it otherwise runs fine.

Error number -45:
DMS-E-YV-SGINOTSUPP,The database type 'attach database'associated with the database name '?' is not supported.
DMS-E-DBLL_NOTFOUND, The dynamic link library'<unknown>,check INI file' could not be located in the search path.

What do I need to do to get this running.
Any help would be appreciated.

 

[griffindm]

Hi there fellow Costpoint user!

A typical problem with these types of migrations is a potential change in the dll used to connect to the database. Oracle particularly has a number of different dll's to support version 8.x. Sometimes a client computer may be using a prior version of the dll successfully (i.e. the Ora 7.3 dll to access Oracle 8.x). The issue is that there is a hierarchy of dll access in the cogdmor.ini file (usually located under c:\Program Files\Cognos\cer1\bin - use cer2 for version 7) that determines which dll of Sqlnet Impromptu attempts to use. You need to make modifications if the default dll is not the one the client has. The section and lines are:

[DLL Names]
;
; Uncomment the following entries to ensure that a specific version is used.
;
Default Win32=OR815-Win32
;Default Win16=OR72

OR815-Win32=ORACLIENT8.DLL,8.1
OR805-Win32=ORA805.DLL,7.1
OR804-Win32=ORA804.DLL,7.1
OR803-Win32=ORA803.DLL,7.1
OR73-Win32=ORA73.DLL,7.3
OR72-Win32=ORA72.DLL,7.2
OR71-Win32=ORANT71.DLL,7.1

OR805=ORA805.DLL,8.0
OR804=ORA804.DLL,8.0
OR803=ORA803.DLL,8.0
OR73=ORA73WIN.DLL,7.3
OR72=ORA72WIN.DLL,7.2
OR71=ORA71WIN.DLL,7.1
OR70=ORA7WIN.DLL,7.0
OR60=ORA7WIN.DLL,6.0


Hope this helps,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
&quot;Magic with Data&quot;
Want good answers? Read FAQ20-2863 first!

 

[po944he]

I'm using Sql-Server, does this still apply.

 

[griffindm]

Not directly. There is no related dll section in the cogdmms.ini, which is used for direct access. Some Costpoint users with SQL Server use direct access. Many others use ODBC with the MS MDAC drivers they use for Costpoint itself. There is referenced support in the cogdmod.ini for ODBC, but this is rarely an issue that requires the file to be modified. I'd check first to see that the new laptop is using the same MDAC SQL Server ODBC client version as the rest of your computers that are running Impromptu without problems. You can check this under Control Panel | Admin Tools | Data Sources | Drivers. Locate the entry for SQL Server (usually at the bottom of the list) and compare the version number between the computers. If it is different, see what you can do to change the new laptop to use the other ODBC version.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
&quot;Magic with Data&quot;
Want good answers? Read FAQ20-2863 first!