What would be the code from the side of the database if someone writes the code of connecting string in C# ?

Question

1.00/5 (2 votes)

See more:

suppose I am the database and one c# or vb.net developer wants to connect my database
using Oledb.
so he would write
oledbConnection con=new Oledbconnection();
con.connectingstring =d:\mydb.dfv;

Now upto this coding i have done . one could write this much of code in c# and connect to my database.

now if someone sitting on different computer in LAN or MAN and wants to connect my database what will be the code on my side (i am the database )

What I have tried:

not very sure about the coding

Posted 13-Feb-21 21:15pm

Member 12712527

Updated 13-Feb-21 23:39pm

Add a Solution

2 solutions

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 · Answer 1 · 2021-02-13T21:25:00

The DB isn;t in control of what the user needs to enter as the connection string: he needs to identify the computer, the type and version of engine that can open the file, the share the file is under, the path from that share to the actual file, and some security information to allow him to access your computer to do that.

The later bits are the difficult ones: you need to ensure that the file is available, and that his user details will allow him access - and we can't even begin to check that!
It is unlikely that holding the file in the root of any drive is going to be a good idea: security on root folders is tight, and getting tighter - so what works today, probably won't work tomorrow!

Plus, two other things:
1) I have no idea what a DFV file is, or what kind of engine would open it - it's not a familiar extension - so you will probably need to provide engine files / installer before any other user can access it.
2) Multi-user access to database files directly is always a poor idea - it leads to a lot of hard to pin down (and harder to fix!) problems once it gets out into production. I would strongly recommend that a multiuser DB system such as MS Sql or MySql is used instead.

Richard MacCutchan · Answer 2 · 2021-02-13T23:39:00

Solution 2

All of your questions relate to the same thing which you still do not seem to understand. You were told yesterday how a client can connect via a network using sockets and TCP/IP. It is your job to write the code that manages that connection. So you need a client application which the user will install on their system, and a server application which will run on the database server.

The user should only need to know the IP address, or network name, of the database server, and the name of the database file. The driver software (all of which you will write) will create the connection and manage the transfer of data in response to the client's requests.

Posted 13-Feb-21 23:39pm

Richard MacCutchan

Comments

Member 12712527 14-Feb-21 5:52am

sir sorry believe me i don't know client server architecture

Richard MacCutchan 14-Feb-21 6:12am

Then you should forget this whole idea (whatever it is). Unless you have a good solid understanding of client server and network protocols you will never make any progress.

Member 12712527 14-Feb-21 6:22am

thank you sir my further questions will be on this only

Richard MacCutchan 14-Feb-21 6:32am

You are wasting your time posting these questions here. This forum is for helping people with actual code that they have written. But your questions are on research into a number of subjects. So you need to start doing the research and find articles and tutorials on the subjects I have mentioned, and actually learn how these things work. it is impossible in a forum like this to provide anywhere near the detail that you are asking for.

Member 12712527 14-Feb-21 6:43am

sir sir sir i am a shop keeper and you say i am researching !!!!
i have interest about this application c#
what do you think of me

Richard MacCutchan 14-Feb-21 7:33am

I think you will not make any progress until you accept the advice I have given you and do your research and studying.

Member 12712527 14-Feb-21 6:45am

sir now I will leave for a moment because i have to go to the market

Member 12712527 14-Feb-21 6:23am

thank you for helping me

Member 12712527 14-Feb-21 6:03am

the example sighted might be from client call to server --connection status .how will the database present in the server know which client is connecting it if it's not clear
then can i ask for further help

Member 12712527 14-Feb-21 6:08am

no more questions sir sorry ...