Use Mssql like Access
-
Hello Friends, I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible? If it is, how can it be? Thanks for your helps? Best Regards Eray
-
Hello Friends, I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible? If it is, how can it be? Thanks for your helps? Best Regards Eray
It's kind of possible, but the only way to make it work is if the machine has SQL Server Express installed on it. You simply cannot get around that requirement.
Dave Kreskowiak Microsoft MVP - Visual Basic
-
Hello Friends, I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible? If it is, how can it be? Thanks for your helps? Best Regards Eray
If you absolutly can't run SQL Express, have you looked at SQL Server Compact Edition[^] http://www.microsoft.com/sql/editions/compact/default.mspx[^]
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
-
Hello Friends, I develop a project and i use mssql 2005(express) and i want to use project in another computer that has not have sql server. (actually i mean i want to use sql server mdf file like access) Is it possible? If it is, how can it be? Thanks for your helps? Best Regards Eray
The whole purpose of Sql Server is to have data developement projects move out of the amateurish world of Access. What you do is the following: The application would go on any machine but you create a connection string in the app.config that contains all of the connection data. Now in your connection string you specify some url "\\DevelopmentServer" for example. Whatever you do -- eliminate all existance of localmachine from your connections!!! Now on the development machines you modify the hosts file as follows your machine : DevelopmentServer 127.0.0.1 others machine: DevelopmentServer {your ip address} The only downside to this approach is that any time your IP is reissued via DHCP you need to have the others update their hosts file. The other possibility is you have your engineers give your machine a fixed address until you can deploy a real database server with a fixed address.