sharing sql server without client installation
-
hi, I want to know is it possible to access sql server db from client machine without the client sql loaded?? thanks in advancd regards mamatha
-
hi, I want to know is it possible to access sql server db from client machine without the client sql loaded?? thanks in advancd regards mamatha
mamatha_raghu wrote:
without the client sql loaded
What is client sql?:confused: What exactly :confused: you want to do?
-
hi, I want to know is it possible to access sql server db from client machine without the client sql loaded?? thanks in advancd regards mamatha
-
Yes you can access it without the Sql Server Native Client installed, but with reduced functionality. Here's what you get for using it: http://msdn2.microsoft.com/en-us/library/ms131456.aspx[^]
hi, thanks for the reply but iam very sorry i did not get any information about my question plz provide any clear information and my question was is there any possibility of accessing and sharing data of sql server from a client machine on which there is no sql client installed? regards mamatha
-
hi, thanks for the reply but iam very sorry i did not get any information about my question plz provide any clear information and my question was is there any possibility of accessing and sharing data of sql server from a client machine on which there is no sql client installed? regards mamatha
I thought I was quite clear :/ By the Sql Client you mean the Sql Server Native Client? If not what are you on about? "Sql Client" could mean alot of different things. If you are on about the Sql Server Native Client then my original answer still applies. Read the link. Yes, you can access Sql Server without the Sql Server Native Client installed, but with reduced functionality. Here's what functionality you get for using the Sql Server Native Client: http://msdn2.microsoft.com/en-us/library/ms131456.aspx[^]
-
hi, I want to know is it possible to access sql server db from client machine without the client sql loaded?? thanks in advancd regards mamatha
The SQL Server OLE DB provider and ODBC driver, plus associated network libraries, are part of MDAC (Microsoft Data Access Components) for SQL Server 2000 and earlier. At least MDAC 2.6 is required for accessing SQL Server 2000. Since Windows 2000, MDAC is part of the operating system. Windows 2000 shipped version 2.5 so requires updating to access SQL Server 2000. Windows XP SP2 ships the latest redistributable version 2.8 SP1. Windows Server 2003 SP1 ships with MDAC 2.8 SP2 which is not available separately. Basically, on Windows XP or later you don't need to install extra software to access SQL Server 2000 or earlier. The .NET Framework implements the SQL Server access protocol natively, but requires the network libraries from MDAC. You can access SQL Server 2005 using the SQLOLEDB provider for ADO/OLE DB, SqlConnection from .NET 1.1, and the SQL Server ODBC driver. However, the old provider does not support many new features of SQL Server 2005. To get full functionality, you need to install and use SQL Native Client (for ADO/OLE DB/ODBC), or use .NET Framework 2.0 or later. For ADO/OLE DB, specify SQLNCLI rather than SQLOLEDB. For ODBC, use the 'SQL Native Client' driver rather than the 'SQL Server' driver.
Stability. What an interesting concept. -- Chris Maunder