This is the error I am getting:

Connectivity error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Conversion failed when converting the varchar value '4/24/' to data type int.

From http://www.developmentnow.com/g/95_2...-sqlserver.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Peggy Mall (pmall (AT) sc (DOT) pima.gov) writes:
I would not call that a connectivity error, but a plain error at run-time.

Since there is absolutely no context, I cannot really help you. The error
message is what it says. There is an attempt to convert a non-numeric
string to int.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Peggy Mall wrote:
Were you trying to do the calculation 4/24?

Andrew