I have an Object with Datatype Varchar(400) and data in the column has special
characters.When I try to parse the object it doesnt parse and I get an exception
Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not be prepared.State: 42000
Database :SQL Server 2005.
Business objects XI 3.0
I have tried using substring( columnname,1,400) and tried to parse but I have
the same problem.Even tried with Longchar as datatype.
Can someone through light on this issue.
Hi sparkling,
Did you find any solution to this error message?
Please share the solution if you found !!!
The problem we are facing is:
This is the error message. Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.State: 42000
We exported the report from Dev to Prod using the Import wizard.
Logged on to the Infoview in Prod Env. and wanted to test the reports.
I was able to open the report ,but when hit refresh it don’t show up the list of values for the Prompts.
So logged into designer in the Prod Env. , check the connections its was working fine and responding.
But when we right click on the table to view values it is giving the above mentioned error.
Also tried to create new connections and test,it was responding but not giving the table values.
Another thing I noticed is when logged in the CMC
Dev: I can see the connection the universe is using
Prod: I cannot see the connection.
