shrimant
Last Activity: Mar 9 '20, 05:54 PM
Joined: Sep 26 '07
Location:
-
Hour(DateTimePi cker1.Value) -
- Turn off all firewalls, with WIn XP and up, by default the firewalls are turned on.
- First of all try connecting to the SQL server on the SQL server machine, the simplest way would be to create a ODBC and on the last step click the test connection button on the ODBC interface.
- A typlical SQL server connection string for .NET should look like this: [connectionStrin g="Data Source=<SQL SERVERNAME/IP ADDRESS>;Initia l Catalog=<DATABA SE>;User
Leave a comment:
-
Using a Mapped drive should increase performance, as with any network resource the network access credentials does matter and when you use a mapped drive, the access credentials are already established.Leave a comment:
-
Either Use
Dim ComAdm As New COMAdmin.COMAdm inCatalog
Or
Set ComAdm = CreateObject("C OMAdmin.COMAdmi nCatalog")
You cannot use both on the same variable, the first statement is an early binding and the second statement is an late binding, since the same variable is early binded, you cannot use is for late....Leave a comment:
-
Make a batch file with ".cmd" or ".bat" file and cut paste the following into the batch file with appropriate obvious changes. SQLMAINT is a Sql Server command line utility, which you could make use for UR purpose
"C:\PROGRA~1\MI CROS~3\MSSQL\Bi nn\SQLMAINT -S "Servername " -U "DBusername " -P "passowrd" -D "Databasena me" -BkUpMedia DISK -DelBkUps 2weeks -BkUpDB "D...Leave a comment:
-
Naote that "C:\PROGRA~1\MI CROS~3\MSSQL\Bi nn\SQLMAINT" would change bepending on your SQL server anf binn path.Code:C:\PROGRA~1\MICROS~3\MSSQL\Binn\SQLMAINT -S "Servername" -U "DBusername" -P "passowrd" -D "Databasename" -BkUpMedia DISK -DelBkUps 2weeks -BkUpDB "Drive:\BackupFilePath"
Leave a comment:
-
I did not get UR point , Dasa Babu? Kan Kahu cha tike bujha padila ni...
It is a regular trend In US schools to convert all class project presentations into PDFs , coz the point is copyrighting. Animation is just a part of PPTs, even the professors stress that the all soft copies be presented as PDFs.
Else why would one try to make a PPT non editable if it was to be used in his own laptop to be presented by him only?...Leave a comment:
-
Modify the following piece of code to fit your requirement, it saves the Gridview contents to an Excel. Id you have sorting or Paging or other customization.. .as you see below you need to turn them off before you could save the entire content. There is also an restriction of Max 65536 rows...due to excel.
...Code:Protected Sub ImageButton2_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton2.Click
Leave a comment:
-
Leave a comment:
-
...Code:Sub Main() Dim Output Set objShell = CreateObject("WScript.Shell") Set objExecObject = objShell.Exec("%comspec% /c ipconfig /all") Output = objExecObject.StdOut.ReadAll() Set objExecObject = Nothing DNS = Trim(Replace(Mid(Output, InStr(InStr(1, Output, "DNS Servers"), Output, ":") + 1, 15), Chr(13), "")) End SubLeave a comment:
-
Use the Save as dialog and save it as a PDF, in Office 2007 there is also a default menu item within the Save As called "Save as XPS or PDF"...Leave a comment:
-
Well without looking at the contents it is really difficult, but definitely, it's doable with the following VB functions string functions "INSTR" "INSTRREV", "MID","LEFT " ,"Right", "split" etc. Moreover do you really need to save the HTML file? If not I would suggest using the XML parser get it to a local variable...and that way you wound be free from the extra over head of FILE I/OsLeave a comment:
-
I beleive the project file ".VBP" , has been corrupted, why don't you try creating a new project and try adding your exixting modules to the new project , before the re-installation.
when you open the ".VBP" file in a notepad, there would be a line something like below:
Module=EmailTem plateContractMf r; EmailTemplateCo ntractMfr.bas
Check to see if that line or it's neighbouring...Leave a comment:
-
where ever you are using Order except for "Order by"enclose it with square braces like below:
[Order]
ORDER is a SQL KEYword...and that is where you are having problem...Leave a comment:
-
Iwas wondering why would you go for such a hastle when the file Upload feature is inbuilt in ASP.NET
On the Page itself No Form Declaration is Required only a ine Liner as below:
On on the VB File:Code:<asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="Button1" runat="server" Text="Upload File" />
...Code:Protected Sub Button1_Click(ByVal
Leave a comment:
-
As killer said Split is the best bet..Mid would make it too complicated,
...Code:str = Split(s,space(1))
Leave a comment:
-
Create a View with selected columns and link to the View...Leave a comment:
-
Sorry xxoulmate...I don't even have a 98 installation around to re-produce the error, I have XP and 2003 servers around me.
Try Putting a set statement in your AutoExec.bat file something like below make sure the path of the Command.com file is correct:
Set COMSPEC=C:\WIND OWS\COMMAND.COM...Leave a comment:
-
If the DB is Oracle or SQL server You can just Backup the Transaction logs and from the Transaction log itself you could restore each and every piece of activity. There are professional tools available to restore from Transaction log one example is Lumigent Log Explorer.
Since your DB is Access you can use install the Free SQLServerExpres s version and then from within Access Upsize Access tables to SQL Server. Download it from the...Leave a comment:
-
Add some Error Handler to the code and make sure to add the Keyword Doevents insede the loop....Leave a comment:
No activity results to display
Leave a comment: