ColdFusion and SQL Server 2005 Express Edition

Posted At : December 19, 2007 9:26 AM
Related Categories: ColdFusion

I'm sure many of you already know this, but just in case, I've been beating my head against a wall for a while to get this working. SQL Server 2005 Express Edition and the default settings do not work well with CF. I searched and FeedSquirrel found me a set of instructions for how to set it up. Unfortunately, that blog no longer seems to exist (originally from http://www.orbwave.com/cfjboss/2006/04/connecting-coldfusion-to-sql-server.html), but I've found another version of it here: http://www.fusioncube.net/?p=59

Comments (6) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 1814 Views

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

[Add Comment]

Already had my own link (and many others) at http://eee.actcfug.com/ - see:

http://www.actcfug.com/index.cfm?actcfug=LinkView&...

Point is it does not run on the same port than SQL 2005 Standard does - and that is easy enough to check or change.

# Posted By Peter Tilbrook | 12/19/07 8:33 PM

Heh - at about the same time as the fusioncube article I posted the same information but without the pretty pictures..

http://nil.checksite.co.uk/index.cfm/2007/4/30/SQL...

I think this is actually mentioned when you install SQL Server/Express 2005, but I think I probably skimmed over it when I ran the installer.

# Posted By Stephen Moretti | 12/20/07 7:55 AM

SQL Server 2005 is the Vista of databases. Everyone I know has ignored it and stayed with 2000.

# Posted By Tony Petruzzi | 12/20/07 8:17 AM

@Tony,

You really shouldn't ignore it... There are some very cool features in there...

# Posted By Stephen Moretti | 12/20/07 8:56 AM

We assessed our Intranet and public Internet site since a first release of 2005 SQL by using CF. MX and MX 7. Other than the mentioned user gotchas, which were small as soon as I read the book, everything seemed to work big - and been quick. Does not point out problems with our main CFC or keeps procedures. They are not tremendously complex, but I think that our complete production stretches should go very slowly. Anyways, just our observations!

John @ http://www.autopartswarehouse.com/shop_parts/throt...

# Posted By Buick Lloyd Kruz | 1/1/08 9:02 PM

# Posted By Buick Lloyd Kruz | 1/1/08 9:29 PM

[Add Comment]

Calendar

Links

The house project

Archives By Subject

Baby (2) [RSS]
Breezo (1) [RSS]
CFEclipse (1) [RSS]
ColdFusion (25) [RSS]
Eclipse (1) [RSS]
Flex (2) [RSS]
FlexBuilder (2) [RSS]
Magic (1) [RSS]
MAX (5) [RSS]
Personal (9) [RSS]
Rant (3) [RSS]
Report Builder (13) [RSS]
Scorpio (1) [RSS]
Security (1) [RSS]
Subreports (1) [RSS]
Tip (2) [RSS]