|
I am glad that helped. I have done that same exact thing. 
|
|
|
|
|
Please check all the components and reference u have add to the projects before creating EXE.
|
|
|
|
|
hi,
i would try to register the .exe first and then expect the changes to appear IF running it from outside of Visual Studio
|
|
|
|
|
Thank you.
The exe was designed to be called from the Run tool and pass some parameters as argument to it.
By mistake I renamed the exe and put a space in its new name. then I figured out that the run command utility doesn't support having space in the exe name and kept calling old exe
|
|
|
|
|
Hello
I am trying to add a service reference to my solution but it propmpts me errors I use the Ip address with web browsers and it works but when i add the service to my solution it gives me this error
the IP address is MYIP:88/sapco/sapcoservice.asmx?wsdl'
Metadata contains a reference that cannot be resolved: 'http://MYIP:88/sapco/sapcoservice.asmx?wsdl'.
There was an error downloading 'http://MYIP:88/sapco/sapcoservice.asmx?wsdl'.
The request failed with HTTP status 404: Not Found.
Metadata contains a reference that cannot be resolved: 'http://MYIP:88/sapco/sapcoservice.asmx'.
Metadata contains a reference that cannot be resolved: 'http://MYIP/sapco/sapcoservice.asmx'.
|
|
|
|
|
I want to develop a program that contains a table so that first column contain names ,second marks third ,Grade and a command button with caption "Provide Grade"
In Grade column will be displayed grades when Provide Grade"is clicked
above 80 grade A
70 to 80 grade B
60 to 70 grade C
50 to 60 grade D
Under 50 grade E
|
|
|
|
|
Its been a long time since I have had VB6 installed so can't remember the exact name of the controls, but in the toolbox there is a grid control.
Then, the docs are your friend (and google).
|
|
|
|
|
Tpaci wrote: I want to develop a program
If this is a new project for you then STOP . Download the .net express version and use that. It is free and supported.
VB6 is no longer a supported product and has not been for some years. If you are working on an existing app then you have my sympathies.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But it will be bether to do it in a dotnet environment
Sub MakeDB()
Dim WrkSpace As DAO.Workspace
Dim db_Temp As DAO.Database
Set WrkSpace = DBEngine.Workspaces(0)
Set db_Temp = WrkSpace.CreateDatabase("C:\Documents and Settings\XP\Bureaublad\test\test.mdb", dbLangDutch, 256)
Set CdInfo = db_Temp.CreateTableDef("CdInfo")
CdInfo.Fields.Append CdInfo.CreateField("SerieNR", dbText, 50)
CdInfo.Fields("SerieNR").Required = True
CdInfo.Fields("SerieNR").AllowZeroLength = False
CdInfo.Fields.Append CdInfo.CreateField("Titel", dbText, 51)
CdInfo.Fields("Titel").Required = True
CdInfo.Fields("Titel").AllowZeroLength = False
CdInfo.Fields.Append CdInfo.CreateField("TypeID", dbLong)
CdInfo.Fields("TypeID").Required = True
CdInfo.Fields("TypeID").AllowZeroLength = False
CdInfo.Fields.Append CdInfo.CreateField("LabelID", dbLong)
CdInfo.Fields("LabelID").Required = True
CdInfo.Fields("LabelID").AllowZeroLength = False
CdInfo.Fields.Append CdInfo.CreateField("PlaatsID", dbLong)
CdInfo.Fields("PlaatsID").Required = True
CdInfo.Fields("PlaatsID").AllowZeroLength = False
Set CDMulti = CdInfo.CreateField("Multi", dbBoolean)
CdInfo.Fields.Append CDMulti
Set CDReeks = CdInfo.CreateField("Reeks", dbBoolean)
CdInfo.Fields.Append CDReeks
CdInfo.Fields.Append CdInfo.CreateField("Prijs", dbCurrency)
CdInfo.Fields.Append CdInfo.CreateField("KoopDatum", dbDate)
CdInfo.Fields.Append CdInfo.CreateField("File", dbBoolean)
db_Temp.TableDefs.Append CdInfo
End Sub
|
|
|
|
|
|
Hello !
i'm working on a vb.net 2010 project that use sql server 2008r2 database.
i want to backup database .i'm using this code :
path="c:\\users\user\desktop\backup.bak"
cmd = New SqlCommand("backup database MYDB to disk='" & path & "'", con)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
... but i'm getting an error
Cannot open backup device 'c:\\users\user\desktop\backup.bak. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
if i change the path to "c:\\bck\backup.bak" , everything works fine.
But i want to backup my database on every destination that i can select.
what can i do ?
|
|
|
|
|
Can you access the user\desktop folder by navigating to it?
This may be a permission issue where you do not have access rights to any files or folders for a particular user - in this case, "user".
|
|
|
|
|
yes , i can access user\desktop folder by navigation
the user that i'm using to test the program is with administrator rights.
|
|
|
|
|
alejx wrote: path="c:\\users\user\desktop\backup.bak"
Why do you have a double backslash after c:, but not after the other parts of the path?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
i try all
c:\\users\user\desktop\backup.bak
c:\users\user\desktop\backup.bak
c:\\users\\user\\desktop\\backup.bak
....
not working
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
