MS-SQL 2005 (MS-SQL 8.0)

[cyberdevil67]

Has anyone got CF MX / CF MX 7.0 do work with the new SQL 2005 as yet.

Looking for a solution to evaluate this urgently, the only means I have at the
moment is to use an ODBC connection and that is not an ideal solution as it
cause problems with our framework.

Have tried to use the JDBC drivers from MS to no avail really has anyone got
any advice tips or anything to get this to work?

[philh]

I know this is kinda OT, but are you also planning to rewrite your DTS packages
in SSIS? Are you ready to deal with the demise of T-SQL in favor of CLR-based
querying? Have you investigated the feasibility of doing so yet?

[cyberdevil67]

Yes very off topic....

All I want is the ability for Coldfusion to connect to MSSQL Server 2005.

And FYI we don't use T-SQL or DTS packages, because we are server and platform independant.

[The ScareCrow]

Have a read of this thread.


[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=1044557&CFID=9383714&CFTOKEN=42bc1e9205c08869-EB98AE72-C8EE-3283-BB583087131E
2466&jsessionid=48301c64353979475428

Ken

[cyberdevil67]

That thread doesn't talk about getting SQL 2005 to work, I have an ODBC
connection already and it works but not properlly with inner joins etc within
the framework we have.

So I am at a loss and guess will have to wait until MM get the act together
and make a suggetion:-)

[mxstu]

>Have tried to use the JDBC drivers from MS to no avail really has anyone got
any

>advice tips or anything to get this to work?

From your original post it sounded like your ultimate goal was to get SQL 2005
to work with with JDBC, which is discussed at end of that thread.

>So I am at a loss and guess will have to wait until MM get the act together
>and make a suggetion:-)

If SQL 2005 is still in the beta stage then I think the ball the is in MS's
court not MM ;-)

[Abinidi]

Exactly. MM, nor any other Application vender, going to commit time to a
product that is still in beta and will be changed for the state it is in now to
how the final product will be once it is out.

Im sure that once Microsoft releases it for public in November, MM will start
to impliment support for it. Who knows, maybe SQL2005 will have fixed itself by
then to be able to run with JDBC drivers.
We'll see.

[cyberdevil67]

Abinidi,

I really don't think yo gave your answer too much thought!

MS have JDBC drivers for SQL 2005, which work in java and yes the examples MS give work. But just not with CF MX 6.1 / 7.0