May 25, 2005 at 5:06 am
Hi, when using impromptu to connect to a sql server database I get the message
[Microsoft][ODBC Sql Server Driver] Dialog Failed
Error Number 9
DMS-E-General: A General Exception has occured during operation ' attach database'
[Microsoft][ODBC SQL Server Driver] Dialog Failed
I have updated the MDAC on my pc to the lastest one, however when I test my odbc sources they connect without any problems. I also get the ODBC message Invalid Windows Handle. Can anyone give me a pointer or a lead or anything on what might be happening.
Thanks in advance for your help. Mike.
May 25, 2005 at 6:30 am
These may seem obvious - but are you using system dsn (as opposed to user) & are you referencing the dsn name in your connection string (& not the db name..)
**ASCII stupid question, get a stupid ANSI !!!**
May 25, 2005 at 7:01 am
Hi, I get the same error in either the system dsn or the user dsn and when I connect I use the dsn name in the connection string. Also whenever I try and run a report using impromptu that previously worked i get the following (don't know if it's going to help)
[Microsoft][ODBC Sql Server Driver]Dialog Failed
Error Number -239
DMS-E-General, a general exception has occured during operation prepare request (and the same thing for operation 'start transaction')
[Microsoft][ODBC SQL Server Driver]Dialog Failed
May 25, 2005 at 7:49 am
Michael - I read on one of the sites that you can enable impromptu log in [Impromptu - Audit Configuration] and if it is a database connection error you will get a "Detail" button listing this...
Alternately, you should check the code generating the report to make sure that no changes have been made (I know all this seems obvious, but....)
You maybe better off addressing this in an impromptu forum...here's one:
http://datawarehouse.ittoolbox.com/groups/groups.asp?v=cognos-l&i=436534
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy