Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Sql Server 2005 October CTP Upgrade - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, MonoTouch for iPhone, MonoDroid for Android, and Windows Azure.

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Sql Server 2005 October CTP Upgrade

When I upgraded my installation of beta 2 of Sql Server 2005 to the October CTP bits, I repaved my system and started over.  I had a copy of the database tables and was able to re-attach them.  I have not seen any ill-effects of doing this.

I was just reading through the Release Notes for this build and there were two things that caught my eye.

  • You can not restore a Beta 2 backup to the October CTP bits.
  • Beta 2 clients are unable to connect to a machine running the October CTP bits.

I don't think that either issue is bad, just something that you need to watch out for.

Note: Bobb @ Developmentor says that he is able to connect from a beta 2 client to an October CTP server.

Correction: the problem occurs when the beta2 app is running on the same machine with the database.

Wally

Posted: Oct 22 2004, 02:46 PM by Wallym | with 5 comment(s)
Filed under: ,

Comments

Bob Beauchemin said:

Hmmm...

I can connect from a Beta2 client (on a Beta2 machine) to a machine running October CTP SQL Server using either ADO.NET, SNAC OLE DB or ODBC.

Do you/they mean on a single machine after you've done an upgrade? I installed CTP on fresh machine. Or something else?

Otherwise, works for me.
Bob
# October 22, 2004 4:08 PM

Wallym said:

Bob,

Good response. I was just reading this and the two issues caught my eye.

Wally
# October 22, 2004 4:10 PM

Kent Tegels said:

I believe the problem will be local to local since the two versions require different versions FX which you can't have on the same host. Don't see the problem?

QARA, an application Lloyd Sheen wrote so the bridge for SSX, was based on B2 and is thus a B2 client. If you install the CTP, QARA breaks. And not just a little.

And right now, he doesn't have a way of fixing it either, since he's only using the VBExpress bits. More about that problem in my Blog.
# October 22, 2004 4:27 PM

Bob Beauchemin said:

Ahh, never would have deduced that from the wording.

"cannot connect to a machine running..."

would be cleared if it had said

"clients compiled under beta2 of the .NET runtime cannot run on a machine that has CTP version of the runtime installed"

In certain earlier versions, the network protocol had changed in such a way that you couldn't *connect*, which is what this wording implies.
# October 22, 2004 5:52 PM

Kent Tegels said:

Clarity is both a skill and an opportunity. Many writers have the first but not the second.
# October 22, 2004 6:27 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)