Service Desk Practitioners Forum
cancel

ECW+Sql2005

Highlighted
Hemul
Super Contributor.

ECW+Sql2005

Hello all,
I have Service Desk 4.5 SP20 running on Win2k. I have a problem with Data Import from Altiris DB (Sql2005).
1. I Have created Odbc to Altiris DB server with username and password
2. In Altiris DB i have created "View" with all relevant data.
3. Start ECW from SD server for select data that i want to export to Xml file and when i select this view or some other views that have "[uniqueidentifier]" field type, where Altiris contains "_ResourceGuid" for all resources, I'v got the Error: "SqlException was thrown: [Microsoft][SQL Native Client]Numeric value out of range"
4. I understand that this error occurs when the column type is INT and i want to fill text into this field, So what the reason Out of that the ECW don't understand that column type "[uniqueidentifier]" must contain 32 digits with 4 dashs
anybody can help me plz?
Attached Print-Screen with this error
2 REPLIES
Hemul
Super Contributor.

Re: ECW+Sql2005

This problem is solved, I have converted this column type to varchar, but now i have different problem, when i select this view in step 2 i must select columns from this view i'v got the next error:"Source doosen't exist in this ODBC"
Attached Print-Screent with this error
Hemul
Super Contributor.

Re: ECW+Sql2005

Solved