uncleroydee
Technical User
We have a identical copies of a MS SQL Server 2K database on our development and production servers. The timestamps (and content)of our ASP pages are the same on both servers. We recently had to change the datatype on a number of fields in the database from varchar to ntext (I know...I know...) to accomodate an increase in the sizes of these fields. Now we are getting ODBC errors (Cannot convert varchar to numeric) on the production server, but not on the development server.
All of the configurations appear to be the same on both web servers and the ODBC connections appear identical. The only thing I cannot verify is which patches have been applied to the servers.
I don't feel it's a database issue, although it could be.
Any ideas would be appreciated.
All of the configurations appear to be the same on both web servers and the ODBC connections appear identical. The only thing I cannot verify is which patches have been applied to the servers.
I don't feel it's a database issue, although it could be.
Any ideas would be appreciated.
