Connectiviity error involving Sql Server

[Peggy Mall]

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_2006_4_0_0_0/comp-databases-ms-sqlserver.htm

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

[Erland Sommarskog]

Peggy Mall (pm...@sc.pima.gov) writes:
> 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.

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, esq...@sommarskog.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/prodinfo/previousversions/books.mspx

[Andrew Morton]

Peggy Mall wrote:
> 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.

Were you trying to do the calculation 4/24?

Andrew