> Has anyone had/have any experience with using CF and Sybase?
> We predominently use SQLServer 7 but we have a job coming up
> that will require us to use a Sybase Server. I ask as the
> situation we have is that we will be developing with CF4.5
> Enterprise on NT with a SQLServer 7 DB, when we go live we
> will be shifting all code over to Unix and the Syabse
> environment - in an ideal world the code should work but
> before I say yep I want to know any little details that
> possibly may arise!!!
You should expect to spend a bit of debugging time. One problem that one of
our projects encountered when ported from MS SQL Server to Sybase SQL Server
was that the stored procedures were written using ANSI join syntax, which
Sybase at the time didn't support. It may support that now. Other things
that you might run into might be caused by the use of native drivers instead
of ODBC; for example, how dates are handled in ODBC may differ from how
they're handled within Sybase T-SQL.
In addition, not only are you switching databases, but it sounds like you're
also switching web server operating systems! You should definitely budget
some time for unexpected issues.
As for "in an ideal world", you'd be better off developing and testing
against something that more closely matches the deployment platform. You
won't be able to do any meaningful load testing at all, for example. It
costs more up front to set up new development platforms, but it pays off in
the long run.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
