I've been Installing/configuring MSSQL with TCPIP and accessing it just fine in C#. But I've seen references that make me believe that it's possible to access a MSSQL .mdf file directly and not using named pipes or TCPIP. Is this true?
It's come more to light while working on my install routing using innosetup. In one of the examples I was referring to it appears that innosetup creates the DB outside of mssql 2008 express after mssql 2008r2 express was installed.
Then in another part I saw some code prototyping that appeared to access the MDF file directly. Is this still using MSSQL 2008 just not the server or what?
Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Databases\test.mdf";User ID=sa;Password=123;Connect Timeout=30;User Instance=True
i think it does not use TCP/IP or Named Pipes and so it fullfills
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.