On Tuesday 07 November 2006 13:04, Carl Karsten wrote: > johnf wrote: > > On Tuesday 07 November 2006 10:13, Ed Leafe wrote: > >> On Nov 7, 2006, at 12:03 PM, johnf wrote: > >>> You bring up a question - does MSSQL.PY and FreeTDS work with MSDE/ > >>> Express? > >>> I'd say the answer is yes. In the FreeTDS conf there is an entry for > >>> '127.0.0.1' (localhost) but doesn't the new express require some > >>> settings. I > >>> heard (haven't used it yet) that Express's default was to prevent > >>> TCP/IP > >>> access and used a different port??? Anybody know? > >> > >> They are the same program. It should work without modification. All > >> the tools that access SQL Server access MSDE. > >> > >> -- Ed Leafe > >> -- http://leafe.com > >> -- http://dabodev.com > > > > I did confirm the special settings (normally set during install) for > > express. > > huh? > > I am guessing you are talking about "instance name". all flavors of MSsql > support it, I think Express's setup defaults to a name, which you then need > to specify in your connection, where the others (including msde) don't. > > Carl K Actually, I spoke with Larry Long (VFP programmer) and he confirmed that if the user accepted the default install settings for express that TCP/IP access is turned off. Also that express uses a different port (in other words not 1433). So I think that my current solution would access express unless the tcp/ip access was turned on.
John _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
