|
it does not really matter, you can have as many as you like, up to the point of exceeding the maximum path length.
Remember this is VB, anything goes, and there's no escape in this world.
|
|
|
|
|
Your code is giving you Access Denied because either the path is wrong or the user running your app doesn't have permissions to the specified path. Also, if the SQL Server is not running as the user, it will NOT have permissions to the users folders.
|
|
|
|
|
- the path is ok , and the code works on other folders for example c:\backup\database.bak , doesn't work on folders like c:\users\user\xxxxx... , or directly on c:\ .. etc
- the user that run application has administrator rights
- i don't understand - "if the sql server is not running as the user ?....". Can you explain please?
thank you.
|
|
|
|
|
alejx wrote: - the user that run application has administrator rights
Yes, but is he using them? On Vista and 7, by default, all users, including admins, DON'T use their admin rights unless they are called for.
alejx wrote: - i don't understand - "if the sql server is not running as the user ?....".
Can you explain please?
What account does the SQL Server service run under?? If you don't know, open Task Manager and under the Processes tab, find sqlservr.exe. Next to that, you'll see a column labeled User Name. Which account is the service running under?? I'd be willing to bet it's NETWORK SERVICE, which doesn't have permissions to any user folders...
It's not the user making the backup, it's the SQL Server. The user is just sending a command to the server to do the backup.
|
|
|
|
|
Thank you !
I'm using windows 7 and my user have administrator rights and use them.
on task manager sqlservr.exe process , has Network service on "User name" column.
what can i do , because is very important for my application , to make backups on every local directory or removable media that user select.
Thank you !
|
|
|
|
|
Are you saying that you have SQL Server stored procedures or other SQL Server code making a backup of user files??
|
|
|
|
|
i have a backup form in my application(vB.net) , i choose a folder ( with a folder dialog) and i want to backup sql database in that folder.
The code that i have in my first post , works for some folder but doesn't work on folders like c:\ , c:\users\... etc.
What can i do to backup sql database on every folder i choose.
Thank you.
|
|
|
|
|
I personally would use SMO objects to make your backup rather than sending a query to the database to perfom the backup.
For further reading Creating a SQL Server backup[^]. I know the example is C# but it is very easy to convert.
But as Dave has stated the key to the backup is making sure the user permissions are set up correctly.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
ok , but what should i do with user permissions ?
|
|
|
|
|
i'm using NET 4 , and can't use SMO.
|
|
|
|
|
I have a Question for you guys:
Can you guarantee that database can be completed one till date 
|
|
|
|
|
Hi
I have Mdi screen in my project and many mdi child screens,one of these is set to allow maximize as true,after i open this screen and maximize it and then open another mdi child screen , the last screen is maximized automatically but i set the maximize property for it to false.
Any one can help me
|
|
|
|
|
If you maximize one MDI child, ALL the MDI children become maximized. There is no way to change that behavior. The Multiple Document Interface was designed so that your child forms are all the same form editing the same type of documents.
Chances are you're using MDI for a purpose for which it was not designed.
The only way to pull off the behavior you want is to alter your child forms so that instead of maximizing when the button is clicked, they instead resize themselves to the same size as the MDIClient control of the MDIParent form.
|
|
|
|
|
gimana yah cara buat print faktur...tolong ya...pemula nih 
|
|
|
|
|
adizi, This site's main language is English. So please post your question in English. At the very least, use google translate[^]
Translation: adizi, Site ini menggunakan bahasa inggris sebagai bahasa utama. Tolong tulis pertanyaan anda dalam bahasa inggris. Paling tidak, gunakan google translate[^]
OT:Check How to Print Invoice using VB.NET?[^] (google[^]'s first hit)
Oxfords English < Official CCC Players Dictionary
Excuse me for my improper grammar and typos.
It's because English is my primary language, not my first language.
My first languages are C# and Java.
VB, ASP, JS, PHP and SQL are my second language.
Indonesian came as my third language.
My fourth language? I'm still creating it, I'll let you know when it's done! 
modified 27-Oct-11 2:13am.
|
|
|
|
|
HI, James my name is, india i am from. I want to make an 'operating system' (like windows 7) with visual basic. i know do not visual basic, i is willing to learn. Time i do not have, and i cannot spend more than day on tis project.
/james - the master of kolkata
|
|
|
|
|
You'll have quite the busy day then...
I think you need to research what an operating system is, and how it works.
Plus, while I have no issues with VB, it's def the wrong tool in this case.
|
|
|
|
|
Why do I get the feeling that this is a troll? Doesn't make any sense at all. First you want an operating system, like Windows 7 no less!, and then you can't spend more than a day? An operating system takes months/years of development work, let alone testing, creating device drivers, low level controllers, etc...
Definitely a troll. "KILL HIM!"  I'm kidding! REALLY! Sheesh! 
|
|
|
|
|
Can't be a serious question...
I vote for a troll, too
|
|
|
|
|
i am no troll. trying to mske an operating system for my friend sanjay. i thought maybe the code project would give help to me as i am a bit of noob
|
|
|
|
|
In that case, you have no hope at all of make an operating system in VB6. It simply isn't possible.
|
|
|
|
|
One thing you have to realize : building an OS isn't a noob task at all.
It would be as willing to cross Atlantic Sea by swimming without knowing how to swim...
No memory stick has been harmed during establishment of this signature.
|
|
|
|
|
james midget wrote: Time i do not have, and i cannot spend more than day on tis project.
You are like kidding right? Operating Systems are not something you can build in a day, a week, or even longer. There is a lot that is involved, just to start File I/O, GUI, Memory Management, etc. Give this food for thought, think about how long all of the major OS manufacturers have been in business and the time it takes to roll out a new product.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
It takes them so long because they have to do marketing. The programming usually only takes a month or so
|
|
|
|
|
Shhhhhhhh don't tell the troll that
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
