[freetds] Microsoft SQL Server 2005 Express Beta 1

Daniel Morgan danielmorgan at verizon.net
Wed Jun 30 22:12:49 EDT 2004


Hmmm...  I need to look into that... I knew freetds had an answer! :)

I found this article on MSDN.  Beware of word-wrapped lines below.

SQL Server 2005 Express Edition Overview

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/h
tml/sseoverview.asp

Run the setup from the command-line like:
SQL Server 2005 Express Edition Overview

E:\download\2005_Stuff>SQLEXPR.EXE ADDLOCAL=ALL
DISABLENETWORKPROTOCOLS=0 INSTANCENAME=SQLEXPRESS2

This is the important option:
DISABLENETWORKPROTOCOLS=0

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Wednesday, June 30, 2004 8:55 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Microsoft SQL Server 2005 Express Beta 1


On Wed, 30 Jun 2004, danielmorgan at verizon.net> wrote:
> I would like to be able to connect to SQL Server 2005 Express.
> 
> Unfortunately, they do not allow it to be used outside of their .NET 
> 2005 Express IDEs like Visual C# 2005 Express or Visual Basic.NET 2005

> Express.
> 
> SQL Server 20005 Express has replaced MSDE.
> 
> Microsoft has SQL Server 2005 Express Beta 1 for download.
> 
> http://lab.msdn.microsoft.com/express/sql/default.aspx
> 
> Any ideas on how to get it to work externally?

I read about this in the New York times on Monday, I think.  I thought
at the time, "I bet it doesn't accept TDS connections".  Thanks for
confirming.  

The thing to do, it seems to me, is to build on Steve Kirkendall's work
on src/server.  From a brief look at Microsoft's documentation, it seems
you'd need to create what's now called a "Windows Service Application". 
Drop in the FreeTDS server, attach query/result handling to the SS2K5E
API, and you're done.  Just a small matter of programming....

Does that look like a reasonable approach?  

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list