Error Number 45 Cognos
Contents |
ini file could not be found Technote (troubleshooting) Problem(Abstract) Query Server Error Error number -45: DMS-E-YV_SGINOTSUPP, The database type
Cognos Impromptu Error
'attach database' associated with the database name '?' is not supported cognos error traceback DMS-E-DBDLL_NOTFOUND, the dynamic link library "unknown check ini file" could not be found in the search path. cognos error qe-def-0260 when attempting to run an Impromptu report against an Oracle 8.x database natively on Win95, Win98, WinNT, Win2000 platforms. Resolving the problem 1. In the Cogdmor.ini file, under
Cognos Error 'sqlopenresult' Status='-28'
the [DLL Names] section, ensure that the entries looks similar to the following. Do a search on your machine for OR*.dll, if OR805.DLL is found in your search then ensure there is an entry like that marked * below. Similarly, if OR815.DLL is found in your search then there should be an entry like that marked
Cognos Error Dpr-err-2101
*** below. [DLL Names] ; ; Uncomment the following entries to ensure that a specific version is used. ; ;Default Win32=OR71-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 2. Check the path. In Command Prompt, type PATH. Ensure that there is an entry that points to the Oracle entry bin directory. For example: x:\ORANT\bin. 3. If the path has been manually edited, check that the path does not have any entries with spaces in it. If it does, remove the spaces and use 8.3 path naming conventions. 4. Use Oracle client utlity - SQL PLUS x.x - to test that you can connect to the database before re-running your report in Impromptu. Cross reference information Segment Product Component Platform Version Edition Business Analytics Cognos Planning Contributor Historical Number 108621 Document information More support for: Cognos Series 7 Impromptu Software version: Impromptu 5.0, Impromptu 6.0, Impromptu 7.1, Planning - Contributor 7.3 Operating
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of cognos error dpr-err-2082 this site About Us Learn more about Stack Overflow the company Business Learn
Cognos Error Log
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question cognos error 1053 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up http://www-01.ibm.com/support/docview.wss?uid=swg21336994 OCI.DLL error connecting to Oracle DB in Impromptu 7.5 up vote 0 down vote favorite I am trying to connect to an Oracle 11 database in Impromptu 7.5 but I am getting the below error. This is generated when trying to open a catalogue and when the option for 'connect to database' is selected: Error number -45: DMS-E-DBDLL_NOTFOUND, The dynamic link library 'OCI.DLL' could http://stackoverflow.com/questions/13722965/oci-dll-error-connecting-to-oracle-db-in-impromptu-7-5 not be located in the search path or one of its dependent dynamic link libraries failed to load I am using Impromptu version 7.5 on a Windows 7 64 bit machine attempting to connect to an Oracle 11g database. I have the Oracle 11g client installed on my machine and the correct service name configured for my database in Net8 Assistant. I have also checked the C:\oracle\product\11.2.0\client_1\BIN directory and OCI.DLL exists there. This directory is also referenced in my PATH variable. I am able to connect to the database without issue using Aqua Data Studio v12 but it just seems to be Impromptu 7.5 that doesn't like it. Any ideas anyone? Could it just be a compatibility issue? Thanks oracle11g business-intelligence cognos impromptu share|improve this question asked Dec 5 '12 at 12:10 Jimsan 115213 Here's an idea: use procmon to monitor where it's looking for that file. procmon generates a lot of data but you can see exactly what and where your impadmin.exe process is looking for the DLL. –Nick.McDermaid Dec 5 '12 at 22:35 Thanks for the suggestion. I've run procmon and
check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum http://www.dbforums.com/showthread.php?1633462-Oracle-Cognos-ODBC that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Oracle - Cognos - ODBC Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-29-08,10:56 #1 ralph908 View Profile View Forum Posts Registered User Join Date Aug 2008 Posts 2 Unanswered: Oracle - Cognos - ODBC Hi all We cognos error rolled a new windows xp pc to replace a very old one. The old PC is running a congos impromptu application and the data is on a oracle server. I have been trying to install the cognos application on the new PC. I am using the same software that was installed on the old PC Oracle client 8.1 and congos version 5. I have installed Oracle Client 8.1 and have tested error number 45 the connection to an oracle database with sqlplus and it connects. I have installed congos impromptu version 5 and ran the sample jobs and it runs fine. I set up the ODBC connection with the same name that is used in the tnsnames file. However when I go to test the connection via congos I get the following error Error number -45: DMS-E-YV_SGINOTSUPP, The database type 'attach database' associated with the database name '2' is not supported. DMS-E-DBDLL_NOTFOUND, The dynamic link library '