Connect to mdf database using an IP-Address

Question

0.00/5 (No votes)

See more:

So I mostly finished my application and I'm ready to test it on other computers.
Problem is that my connection string has the . for the localhost and I don't know exactly what I should put in there.

What I want is the following, I'm going to create a wireless access point on my computer with the following code on the prompt:

netsh wlan set hostednetwork mode=allow ssid=YOURFRIENDLYSSID key=SOMEPASSWORD 

netsh wlan start hostednetwork

This will make my machine the server, and I want to make the other machines connect to that wireless network and connect to the .mdf that is inside a folder in my desktop.

In terms of code for C#, how should I implement this in the connection string?
And I also don't know which IP to use in the ipconfig, is it my wireless adapter?

Thanks in advance!

Posted 28-Feb-13 0:27am

Steven Borges

Add a Solution

Comments

Steven Borges 28-Feb-13 6:29am

Atention that I don't want the program to connect to the wireless network, what I want is to place there my IP and go to the folder that has my database file.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-02-28T00:39:00

If you are operating on a wireless network, then I wouldn't do it this way.
The first reason is that the IP address will depend on your DHCP controller - normally your router or a network switch and they can be configured in two distinct ways - static IP and dynamic. In static mode, your PC will always receive the same IP address, but in dynamic it will recieve the next available when it ties to connect. It may be possible to fix some addresses in a dynamic network, but that depends on your DHCP controller (Netgear routers do, Belkin generally don't).

So if you change your network slightly, your system may fall apart without you having a clue why!

The second is that there is a better method - use named hosts and named shares instead.

If you share a folder out on a windows PC, you can assign it a name and connect to that via the PCName/ShareName combo, and the DCHP will sort out the IP addressing for you. So if your network changes (or you want to move the DB to a different PC because yours is getting slugged by all the accesses) you can just move the share (and potentially the pc name) to a different machine and everything continues to work unchanged.

But to be honest I wouldn't do that either. MDF files are not good when used multiuser - it can give horrible problems if things happen at the wrong time. I would recommend that you attach the MDF file to a SQL Server instance and use that instead.

"Last time I gave up using SQL-Server Express because it didn't load the tables and data from my MDF, it would load the database with no tables at all!"

Um - I think you did something wrong! Load the DB into SQL server by:
1) Open Sql server Management studio, and create a new, empty database.
2) Right-click the database in the Object Explorer.
3) Select Tasks | Import Data... from the context menu.
4) Change the data source to Microsoft Access.
5) Browse for the file name.
6) Click Next...
7) Select your new database as the destination. Click Next
8) Make sure that "Copy data from one or more tables or views" is selected, click Next
9) Put a tick in each table you want to include. Click Next
10) Ignore the "you can't save this" warning. Click Next.
11) Press Finish, then Close when complete.

You now have the complete table structure complete with data as an SQL database.