Error number -49:
DMS-E-DBACCESS, It was not possible to access the 'CODMSQ_v10' database.
MicrosoftODBC Driver Manager Data source name not found and no default driver specified
I am getting the above error when i am trying to Open a .Imr file via Impromptu, I have Series 7 version 3 on my machine. I googled it and found this solution.
This is my INI file
OUTDOORS=;LOCAL;DB;C:\Program Files (x86)\Cognos\cer4\samples\Impromptu\database@OEM
I was asked to delete this line from the file and reopen it but i still get an error.. what am i doin wrong?
Can someone help?
DanielWagemann 2700058MAJ411 Posts
Re: Error Number 492012-10-03T16:48:17ZThis is the accepted answer. This is the accepted answer.Its been a while since I have touched Impromptu.
The error tells me that Impromptu cannot access the ODBC data source you have created to your Microsoft Access Database.
The reference to the x86 folder in the ini file tells me you are probably on a 64 bit system.
Since Impromptu is a 32 bit application, it would be looking for an ODBC connection definition within the 32 bit ODBC Administrator.
The Microsoft Site reads:
A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
•The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
•The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
Launch the Odbcad32.exe from the System32 directory and make sure you have CODAPROD_v10 DSN defined.