Yes the TCP/IP protocol was disabled. Once I enabled it using SVRNETCN.exe I was able to connect to the MSDE database over the network. Thanks for the tip.
Mark Potter -----Original Message----- From: Kevin Hegg [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 12:43 PM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] SQL Server Emulator? Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;810826. If that doesn't help then search on microsoft.com for "msde sp3". Your problem is not uncommon. -----Original Message----- From: Moderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Potter, Mark S. Sent: Tuesday, January 06, 2004 11:06 AM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] SQL Server Emulator? I have had a bit of a problem getting Service Pack 3 to work with TCP/IP over a network. It works okay on the local machine but not over the network. Prior service packs of MSDE worked fine over the network. Has anyone else experienced this problem. Did MS plug a network hole with SP 3? Thanks, Mark Potter -----Original Message----- From: Damien Guard [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 10:37 AM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] SQL Server Emulator? Why not use MSDE? It's quite small, free* and very compatible with SQL Server so you won't suddenly find problems with your SQL statement that didn't show up on an emulator. [)amien * if you have VisualStudio, Office or WebMatrix. WebMatrix is a free download. Check the licencing terms for the actual specifics. >Can anyone weigh-in on the idea of a C#-based SQL Server emulator? Something that would accept connection strings from >an ODBC/OLEDB/SQL-Managed client, accept dynamic SQL or a stored >procedure, and return a TDS? I was thinking it would >be nice for prototype systems and/or test-driven development, without >the overhead of having a living SQL server >somewhere. =================================== This list is hosted by DevelopMentorR http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 26 Jan 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor(r) http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 26 Jan 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorR http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 26 Jan 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor(r) http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 26 Jan 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 26 Jan 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com
