Extended Stored Procedures Problems

• Al Simmons

  Newbie

  Points: 2

  More actions

  September 24, 2003 at 5:44 pm

  #82965

  Hello.

  I create my Extended Stored Procedure in Visual C++.

  1.-This Stored Procedure run good in this Enviroment:

  SO = Windows NT

  Database = Sql Server7

  2.-But when i migrate this Extended Stored Procedure to

  this Enviroment:

  SO = Windows 2000

  Database = Sql Server2000.

  Problem: I have problems reading the variables varchar.

  In the code of my xp i receive a parameter with some strange characters

  in some times(this case not is always), is in sometimes.

  by example:

  Code: Cast--> (const char*)srv_paramdata (srvproc,i)

  Parameter1= FULANO DE TALe (This string is readed directly from sqlserver

  never is used a variable)

  Parameter2= FULANO DE TAL„

  I sent from sql server 2000 this("FULANO DE TAL")

  Solution: And i change my xp to receive to parameters more

  sizeof(parameter1) and sizeof(parameter2)

  with this 2 variables i fix my problem.

  I was installed service pack 4 ,and the patch of extended stored procedures.

  But my dude is somebody know how fix this problem.

  i do not like receive strange characters from sql in the extended stored procedures.

  Thank you very much for your help.

  Regards,

  Enrique Lino

  1

  
  1

• September 29, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 3, 2003 at 5:23 am

  #476958

  Did you test on a W2k machine without SP4 if not could be related to the heap manager which was changed in SP4. See http://support.microsoft.com/default.aspx?scid=kb;EN-US;195009 otherwise not sure what is causing it without seeing the code.