CF 4.5 and MS SQL 2005

[Newsgroup_User]

Any quick and easy points or guidance to getting these two to play together?

We are in the unenviable position of having to get some maintenance,
enhancement code installed on the venerable 4.5 ColdFusion server that
will interact with the new MS SQL 2005 server before we are able to
migrate the entire CFML code to the awaiting ColdFusion 8 production server.

I tried to create a connection in the 4.5 administrator and I am just
being presented with errors that give me little idea what the root issue
is.

Can anybody provide some guidance before I start bumbling blindly forward?

[The_ScareCrow]

Ian, it's been years since I used 4.5 But I will throw some ideas at you.

I would think 4.5 drivers would not be able to connect and interact with sql 2005 and that is the problem.

As you are going to port to cf 8, I would suggest:

Just use a windows ODBC datasource connection.
In the event that you can't, then you may be able to add an updated driver to 4.5

Ken

[Newsgroup_User]

The ScareCrow wrote:
> Just use a windows ODBC datasource connection.

This got me all excited and I started to go and implement it, until I
recalled our old 4.5 servers are Unix servers. The new 8 servers will
be Windows, but that doesn't help me at this time.

> In the event that you can't, then you may be able to add an updated driver to
> 4.5

I suspected this might be the case. I have never had to adjust the
drivers bundled with CF. For my simple needs the bundled drivers have
always worked for me. I'm finding it challenging to find information
that help me to upgrade this ancient technology. If I went out and got
the latest driver, isn't it highly likely to be incompatible with 4.5?

[The_ScareCrow]

Ian,

It's been 20 years since I used Unix. Like you I also have only used the bundled drivers.

But having said that, I'm wondering if the following will work.

You can get a jdbc driver for unix and 2005
Here's a link to one

After installing this, I wonder if you can then use "other" as the driver in cf 4.5.

As far as installing the driver into 4.5, I'm not sure if this would work either. But would be worth a try.

In the short term, if nothing else is left

You could install mysql on the unix box and dump the data or (not sure if mysql can do this) just link through mysql to sql server 2005.

I know in sql server 2005 you can link to sybase and then query sql server and the data is returned from the sybase db.

Ken

Ken

[Guest]

MSSQL drivers for on cf45 were just microsoft's own odbc driver, I believe. I would expect your best chance is to go out to Microsoft and download the latest MDAC that will work on your platform. This will update ODBC and the mssql driver. Then give it a try. I would not expect new ms2005 functionality to work in cf45, but it may get you connected.

I would definitely backup the system before updating MDAC and have a reasonable rollback plan. The update may not work or it may break more then it fixes.