hi all, i have a doubt about the DST. I want to ask whether DST is related to State or Country? Please guide me or provide some helpful link
sunil goyalG
Posts
-
DST(daylight saving time) -
whether or not Save Credit Card Info?hi all, i want to just ask whether or not save credit card info of any customer in database?
-
Copy file from and to from VISTA give problemhi all, i am simply copy a file from one computer to other.i use following command
File.Copy(BakFileName, "\\" & mdChecking.PublicServerName & "\" & shellCommand.Trim.Replace(":", ""), True) 'mdChecking.PublicServerName is computer name.
above code works well when i copy file from XP to XP, VISTA to XP but fail when i copy from XP to VISTA and give error "Login Failure:unknown user name or bad password" Please suggest how can i resolve this error? -
Create backup of Database of SQL server from Client and serverone more silly question
scottgp wrote:
does the Network Service account have access to whatever RootPath1/DestinationPath is in your code? Is DestinationPath on a network somewhere?
how can i find whether it is have access to given path? however an Access denied message is appear when i select any path except Backup folder of SQL Server
-
Create backup of Database of SQL server from Client and serverscottgp wrote:
I believe the backup is actually executed by the account that the SQL Server service is executing under
how can i get the information about the account?
scottgp wrote:
If it's 2005, you can use the SQL Server Configuration Manager to view and change what account it's using,
yes it is, It is Built in Account under which network service is selected.but how it affect backup process?
-
Create backup of Database of SQL server from Client and serverscottgp wrote:
Are you sure that the account that SQL Server is running under has write permissions to wherever you are trying to back up to?
no idea about this thing. How can i find that whether any account have write permission? BTW i use sa account for create backup
-
what is the best method to install SQL server Express 2005 programmaticallyhi all, i want to install SQL server Express 2005 programmatically. so i use following statement
str = Application.StartupPath & "\SQLEXPR32\setup.exe /qb ADDLOCAL=ALL INSTANCENAME=" & InstanceName & " SECURITYMODE=SQL SAPWD=password DISABLENETWORKPROTOCOLS=0 " Shell(str, AppWinStyle.Hide, True)
above code works well. but when i try to Create backup pro grammatically, then it create backup only in Backup folder of SQL server. if i specify other path(other then Backup) then Backup process failed. Please suggest -
Create backup of Database of SQL server from Client and serverhi all, i want to create backup of my database (related to SQL server Express 2005) from .NET application. Application is install on SERVER and some Client computer(which is connected to SERVER). I want to create backup from SERVER and client. for backup purpose i use following statement
Dim cmd As SqlCommand cmd = New SqlCommand("Backup Database abc to disk = @BackUpPath") cmd.CommandType = CommandType.Text Dim RootPath1 As String = DestinationPath 'Path for create Backup Dim shellCommand As String = RootPath1 & "abc.bak" cmd.Parameters.AddWithValue("@BackUpPath", shellCommand) ExecuteRestoreCommandQuery(cmd, "master")
and this is the procedure ExecuteRestoreCommandQueryPrivate Sub ExecuteRestoreCommandQuery(ByVal comm As SqlCommand, ByVal DatabaseName As String) Dim con1 As SqlConnection = Nothing Try con1 = New SqlConnection("Data Source=" & PublicServerName & "\" & PublicInstanceName & ";Initial Catalog=" & DatabaseName & ";User ID=sa;Password=password") comm.Connection = con1 con1.Open() comm.ExecuteNonQuery() con1.Close() Catch ex As Exception msgbox(ex.Message.ToString) If con1.State = ConnectionState.Open Then con1.Close() End If End Try End Sub
but when i run above code then it Gives error "Can not open backup device" path ... Operating System Error 5(Access is denied.). BACKUP DATABASE is terminating abnormally." so how can i create backup from application which is installed on SERVER and CLIENT. -
How Font is related to Character setAndy Missico wrote:
A Font (font set) displays a set of characters. The characters can be from one or more "Character Sets". For instance, the font Arial has 24 character sets
whether you mean Arial supprort 24 type of character set like unicode,ascii etc? if yes then how can i find that which font support which type of character set(for example how many character set is supported by Font "Courier New")
-
How Font is related to Character setComputafreak wrote:
A font is a complete character set of a single size of a particular typeface
can you explain little more this thing. and what is the typeface
-
How Font is related to Character sethi all, i am very confused about the relation between Font and character set. can any body provide some information(or useful link) which can describe the relation between Font and character set. Actually i want to know that what is role of Font for any character set?
-
Character Set Questionhi all, i am very confused about character set. Can any one provide some useful link which describe the evolution of different type of character set and show related drawback and feature of each character set
-
How OOPs is better than Proceduralhi all, i am very confuse about OOPs . Anybody can provide a good link which decsribe each OOPs concept and prove it is better than procedural with example (for example compare C and C++) or we can do work in more efficient way in OOPs compare to procedural language
-
install the OSQL tool on the client machinehi all, i want to execute following on command propmpt
osql -S test\instance -U username -P password -Q"BACKUP DATABASE databaseName TO DISK='C:\My.bak'"
this command require osql tool(client tool) must be installed on client machine. I do not want to install sql server. Sql server is install on test machine .I want to install only minimum tools to use Osql.exe so i want to ask that which tool must be installed on client machine to execute above command -
How to move a directory between two different volumesThanks a lot sumit 5 from me
-
How to move a directory between two different volumeshi sumit,
sumit prakash sharma wrote:
first copy all the subfoloder and files in new drive location
how can i copy folder from one drive to second
-
How to move a directory between two different volumeshi all, how can i move a directory (also sub directory and files) from one volume to other volume ?
Directory.Move
function fails when source and target drive are different. Please suggest -
SQL query problemThis solution is not works for me. query is failed. I am using SQL Server Express 2005
-
SQL query problemhi all, i run a query which update a field , is failed when it contains single or double quote.Otherwise it is running successfully. sample query is following
update table1 set name='abcd'efg'
please suggest how can i solve this problem ? -
draw series of point into formhi all i want to draw some couple of point into form(or picture box). sample coordinates for some points are following
PointNo----- X----- Y 1----- 0.4064 ----- 7.4848 2----- 2.5184 ----- 7.4848 3----- 6.3904 ----- 7.4144 4----- 9.5584 ----- 7.344 5----- 5.44E-02----- 4.176 6----- 2.8704 ----- 3.8944 7----- 6.9536 ----- 4.3168 8----- 9.7696 ----- 3.6128 9----- 1.1104 ----- 1.2896 10----- 5.616 ----- 1.0784 11----- 9.84 ----- 0.8672 12----- -1.05 ----- 8.603703704 13----- 2.209259259----- 8.603703704 14----- 7.994444444----- 8.685185185 15----- 10.60185185----- 8.603703704 16----- -1.05 ----- -0.603703704 17----- 5.142592593----- -0.603703704 18----- 10.68333333----- -0.359259259 19----- -3.16347308----- 10.54256687 20----- 2.377079047----- 10.3067987
Problem is that some value is negative and so small. So how can i draw the point on form which contains negative value. simply i want to ask that how can i calculate scale for X and Y axis so all of my point is easily visible on form or picture box.