vb6 addate with sql server 2005 smalldatetime and datetime

• sumituniverse

  SSC Veteran

  Points: 278

  More actions

  March 1, 2010 at 11:52 pm

  #217131

  Dear all,

  i am new in this forum ,

  i have a problem regarding vb6 ado 2.8 passing datepicker date to the sql server strored procedure containing a variable decleration of smalldatetime.

  the stored procedure rises a error in vb6 (addbtimestamp-parametre datatype):

  -2147217900-[Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.

  (as suggested by http://support.microsoft.com/kb/214459)

  the stored procedure rises a error in vb6 (addate-parametre datatype):

  -2147217887-[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

  Please reply in this regard.

  (Thanks in advance)

• sqlusers

  SSCrazy

  Points: 2463

  More actions

  March 2, 2010 at 2:20 am

  #1126898

  Change the datatype as datetime instead of int and then check.

• sumituniverse

  SSC Veteran

  Points: 278

  More actions

  March 2, 2010 at 10:57 pm

  #1127539

  :-)Thanks for reply Mr SSC Rookie;

  After posting this topic i tried myself with more experiments on it.

  finally i got that the format of date is must be yyyy-mm-dd for insertion of data in Sql server 2005 sp thru vb6.

  Again thanks for your consideration.

  

• sqlusers

  SSCrazy

  Points: 2463

  More actions

  March 2, 2010 at 11:05 pm

  #1127542

  COOL

  There are lot of date format in sql server. Use "CONVERT" function for neccssary data format.

  And also ref this URL:

  http://msdn.microsoft.com/en-us/library/ms187928.aspx