Click here to Skip to main content
15,891,184 members
Home / Discussions / C#
   

C#

 
GeneralRe: please help me i want to file send Pin
Member 339178814-Feb-10 20:12
Member 339178814-Feb-10 20:12 
Questioninvoice form design Pin
sudhir behera13-Feb-10 1:01
sudhir behera13-Feb-10 1:01 
AnswerRe: invoice form design Pin
Saksida Bojan13-Feb-10 1:18
Saksida Bojan13-Feb-10 1:18 
GeneralRe: invoice form design Pin
sudhir behera13-Feb-10 1:21
sudhir behera13-Feb-10 1:21 
GeneralRe: invoice form design Pin
Saksida Bojan13-Feb-10 1:29
Saksida Bojan13-Feb-10 1:29 
GeneralRe: invoice form design Pin
sudhir behera13-Feb-10 1:32
sudhir behera13-Feb-10 1:32 
GeneralRe: invoice form design Pin
Saksida Bojan13-Feb-10 2:33
Saksida Bojan13-Feb-10 2:33 
QuestionUnable to fetch data from Action Remedy System 7.1 patch 006 using .Net API's Pin
Praveen Raghuvanshi13-Feb-10 0:47
professionalPraveen Raghuvanshi13-Feb-10 0:47 
Hi,

I have upgraded remedy system to 7.1 and I have developed a .Net C# application which retrieves the data from the remedy database pertaining to my company. I am able to retrieve the data for a query which retrives a single record only. For queries supposed to be returning multiple rows, data is not fetched and an ODBC exception is thrown with native code 9055. I searched and found a ARS error document . Below the description of error code 9055 in the document.

*******************
9055
Error
The VUI import file is in an incorrect format.
No VUI definition from the file was retrieved during the import operation. The format of the
import file was corrupted so that it contains no VUI information.
*******************

No idea what does this mean.
Additional information regarding the exception.

Native error: 9055
Message: [AR System ODBC Driver]Data types are not appropriate for relational operation
Source: ARODBC70.DLL
SQL State: S000

BMC error reference document provides some explanation to the above message

313
Error
Data types are not appropriate for relational operation.
The data types of the fields used in a relational operation are not consistent with the operations
allowed for that operation. See the Form and Application Objects guide for information about the
allowed data types of operations.

If we have a problem with the datatyes, how we are able to fetch a single record and not the multiple records.

All was working with Remedy 6.0 and there were some changes with the database and I started to get these errors. How can I overcome this and fetch the data.

I am able to open the connection successfully.


KINDLY TREAT IT AS URGENT and any guidance to this is highly appreciated.


- Rags1512

Reference CODE:

OdbcDataAdapter odbcAdapter = new OdbcDataAdapter(query, connection);
DataSet ds = new DataSet();

try
{
int recordCount = odbcAdapter.Fill(ds);
}
catch (OdbcException oexp)
{
}
Praveen Raghuvanshi
Software Engineer,

India.

QuestionFileSystemWatcher Question Pin
#realJSOP12-Feb-10 23:51
mve#realJSOP12-Feb-10 23:51 
AnswerRe: FileSystemWatcher Question Pin
Keith Barrow13-Feb-10 0:04
professionalKeith Barrow13-Feb-10 0:04 
GeneralRe: FileSystemWatcher Question Pin
#realJSOP13-Feb-10 0:19
mve#realJSOP13-Feb-10 0:19 
AnswerRe: FileSystemWatcher Question Pin
Dimitri Witkowski13-Feb-10 0:05
Dimitri Witkowski13-Feb-10 0:05 
GeneralRe: FileSystemWatcher Question Pin
#realJSOP13-Feb-10 0:18
mve#realJSOP13-Feb-10 0:18 
AnswerRe: FileSystemWatcher Question Pin
Abhinav S13-Feb-10 0:07
Abhinav S13-Feb-10 0:07 
GeneralRe: FileSystemWatcher Question Pin
#realJSOP13-Feb-10 0:17
mve#realJSOP13-Feb-10 0:17 
QuestionHow to set ToolTip to ToolStripButton? Pin
arichikato12-Feb-10 18:44
arichikato12-Feb-10 18:44 
AnswerRe: How to set ToolTip to ToolStripButton? Pin
Saksida Bojan12-Feb-10 19:46
Saksida Bojan12-Feb-10 19:46 
AnswerMessage Closed Pin
12-Feb-10 20:43
stancrm12-Feb-10 20:43 
GeneralRe: How to set ToolTip to ToolStripButton? Pin
arichikato13-Feb-10 7:47
arichikato13-Feb-10 7:47 
QuestionInaccessible due to its protection level [modified] Pin
ASPnoob12-Feb-10 16:38
ASPnoob12-Feb-10 16:38 
AnswerRe: Inaccessible due to its protection level Pin
Wes Aday12-Feb-10 17:14
professionalWes Aday12-Feb-10 17:14 
GeneralRe: Inaccessible due to its protection level Pin
ASPnoob12-Feb-10 17:25
ASPnoob12-Feb-10 17:25 
GeneralRe: Inaccessible due to its protection level Pin
Wes Aday12-Feb-10 17:37
professionalWes Aday12-Feb-10 17:37 
AnswerRe: Inaccessible due to its protection level Pin
DaveyM6912-Feb-10 22:56
professionalDaveyM6912-Feb-10 22:56 
AnswerRe: Inaccessible due to its protection level Pin
Luc Pattyn13-Feb-10 1:26
sitebuilderLuc Pattyn13-Feb-10 1:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.