Post reply

Import NTEXT fields to SQL from Remedy ODBC 4.5 using DTS

  • February 12, 2004 at 2:36 am

    #59119

    Hi guys,

    I made this question on this cool forum cause I can't find an answer in any other place, but may be it's too hard and strange anyway ....

    I have a server with Remedy ARS installed and I connect via Remedy ODBC 4.5, I also tried to upgrade to 6.0 but doesn't work, probably cause server is 4.5.

    For some policies I can't access using Oracle or other ODBC drivers.

    If I import the fields of a table with Microsoft Access linking the source with Remedy ODBC and SQL with ODBC everything works fine.

    When I try to use DTS all the rows are copied but two fields of ntext type are not copied and inside them I find a little square instead the content of the row.

    I noticed that Access calls that fields Memo, SQL ntext(16).

    I tried everything but doesn't work !

    I know that fields are a reference to a separate object, so may be there's a flag that says to Access to return the content and to SQL to return just the pointer ???

    Using the disconnected edit I see a lot of fields but I don't understand what to do.

    I don't want use Access on the server, I want a good clean job !

    Please help me !!! 

    Thanks in advance.

                       Marco

  • February 12, 2004 at 5:34 am

    #493777

    I have never seen this problem.  Here are a couple thoughts.

    Try changing the SQL field from ntext to text.  ntext is for Unicode data and text is for ANSI data.

    Another thought (again speculation):  your source text may be Unicode and your Remedy ODBC 4.5 driver may not understand Unicode.  Unicode puts a null before the standard Ansi characters.

    Russel Loski, MCSD

    Russel Loski, MCSE Business Intelligence, Data Platform

  • February 12, 2004 at 7:29 am

    #493799

    I noticed that smelling fields are just 201 characters maximum, so I removed NTEXT from my database and declared them NVARCHAR(254).

    At least I don't want such fields in my database for such silly size !

    They should be maniacs to declare in such way a so small stuff ! 

    I can't even run functions or other conversion stuff on the query who takes out the data from Remedy, everything I write it returns an error.

    I don't know about unicode and the parameters inside Disconnected Edit look to be geroglifics! 

    I hope a solution that comes from the sky .... or from the forum ! 

    Thanks Again

                     Marco

     

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply