Hi all,

We are STILL using IS 4.6 and we are trying to call a SQL 2000 Stored Procedure using CALL in pub.db. One of the input values to stored procedure is Datetime, when we call the sp with all the input values I am getting an error message
“[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Error converting data type nvarchar to datetime.”

Any body experienced this one, please help us figure this problem.

Thanks,
Muru.

Sounds like SQL Server can’t parse the format of the datetime-parameter. If you pass a datetime-value as string, SQL Server will try to parse this based on regional settings. In my experience the safest way to pass a date-string to SQL Server is as “yyyy-mm-dd hh:nn:ss”.

Martin,

Thats exactly how we are passing the date string. Here is the date format yyyy-MM-dd HH:mm:ss

Thanks,
Muru.