The Tabular Data Stream (TDS) protocol is proprietary. Thats going to be your biggest hurdle. There is an open-source version called FreeTDS (http://www.freetds.org/). The problem is that it is likely to be out of sync with the latest version of SQL Server. I had to do some TDS programming in the mid 90's and it was a pain in the ass.
I second the recommendation to use MSDE. Its free and low overhead. -----Original Message----- From: Moderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of SteveC Sent: Tuesday, January 06, 2004 7:20 AM To: [EMAIL PROTECTED] Subject: [ADVANCED-DOTNET] SQL Server Emulator? 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 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 =================================== 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