make database in drive c

Question

1.00/5 (3 votes)

See more:

hi.
i want make database in path "c:programfiles\winreg" . i use this code but i have error:

VB

System.IO.Directory.CreateDirectory("C:\\Program Files\\WinReg;)

      Dim con As New SqlConnection("Server=.\SQLEXPRESS;Trusted_Connection=True;")
      Dim cmd As New SqlCommand("CREATE DATABASE [Student] ON  PRIMARY" +
    "( NAME = N'Student', FILENAME = N'C:\\Program Files\\WinReg\\Student' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )" +
    "LOG ON " +
    "( NAME = N'Student_log', FILENAME = N'C:\\Program Files\\WinReg\\Student1' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)" +
    "COLLATE Persian_100_CI_AS_KS_WS", con)

      con.Open()
      cmd.ExecuteNonQuery()
      con.Close()

but in path "c:winreg" i have no error.
what should i do?????

Posted 27-Sep-14 1:03am

Mohammad Hasanpoor

Add a Solution

Comments

[no name] 27-Sep-14 7:22am

And what the error is?
N.B: Since about xp c:\program files\.... should not be used to save app data

Mohammad Hasanpoor 27-Sep-14 7:25am

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'C:\\Program Files\\WinReg\\Program\\DbSt\\Student'.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

[no name] 27-Sep-14 7:28am

Yes, because apps should not save data in c:\program files\....
The dirty way is to give access rights for 'C:\\Program Files\\WinReg' (and Sub Folders) to whom it Needs.

The clean way is to use appdata folders

Mohammad Hasanpoor 27-Sep-14 7:29am

and now what is answer? how can i do this?

[no name] 27-Sep-14 7:31am

the dirty or the clean way?

Mohammad Hasanpoor 27-Sep-14 7:32am

i mean how can i change this code for answering?
System.IO.Directory.CreateDirectory("C:\\Program Files\\WinReg\\Program\\DbSt")

[no name] 27-Sep-14 7:38am

I'm confused now ;)
Maybe give a trial to do it in System.IO.Directory.CreateDirectory("C:\\temp\\")

Mohammad Hasanpoor 27-Sep-14 7:41am

im so sorry.
but you did not understand my question.
i must create folder in "c : programfiles".
now do you have any way for this problem?

[no name] 27-Sep-14 7:52am

In case you Need to do it in "c:\program files" (how ever why) than try as a first solution to give full accesto to anybody for "C:\\Program Files\\WinReg" and Sub Folders.

btw that is the dirty way

and btw "but you did not understand my question": hmmm, I think I understood...

[no name] 27-Sep-14 8:03am

He understood your "question" it is you that apparently does not understand paths, folders and access rights.

Mohammad Hasanpoor 27-Sep-14 8:09am

thanks

[no name] 27-Sep-14 9:08am

Thanks Wes Aday for the moral support

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2014-09-27T04:19:00

Bad idea. There are no cases when a hard-coded path name can be useful (except maybe some preliminary experiments).

Such names should always be calculated during runtime based on user input, some configuration files and/or environment, such as "special folders" set up per each user account of for "all users".

You cannot guarantee that the directory you hard-coded will exist. In fact, nothing can guarantee you that even drive "C:" exists. Another problem is permission. In NT-based OS, you will need permission set up for such arbitrary named directory. Instead of doing some changes in system administration, it's always the best to avoid such directories.

—SA

Dave Kreskowiak · Answer 2 · 2014-09-27T06:52:00

Error 5 is "Access Denied".

You're trying to create a file that in a location that is "ReadOnly" to normal users. All folders and files under Program Files are ReadOnly. You can't create your database under that folder.

Put your database in a more appropriate location, such as in a folder under CommonApplicationData[^].

make database in drive c

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0