How To Setting The SQL Server
Dec 8, 2011how to setting the SQL Server
View 6 Replieshow to setting the SQL Server
View 6 RepliesI am trying to make a little app that will tell me if my servers are online or offline, currently I am using my LAN to test my servers when this app is working then I will be adding IP Address from other hosts that are not on my LAN First of all I have got this working fine if I use a button for every server test but I don't really want that I want them all working from one click
[code]....
I have a need to create an app that can automatically switch it's LAN settings over to a proxy server from time to time.....can anyone start me down the right path to which class I should be using to create this monster?
I'm not looking for the entire code just the door would be a nice start.
I'm trying to set up an installer to register a web site. Currently, I've got it creating an Application Pool and Web Site under Windows Server 2003. Unfortunately, whenever I try to modify the ServerBindings property to set the IP Address, it throws an exception at me. I first tried this because the documentation here told me to [URL]. I'm currently using VB.NET, but C# answers are okay too as I need to switch it over to using C# anyway.
[Code]...
I tired the following Query to access my SQL Server database. It returns an error. SELECT Name, Address, PhoneNo FROM dbo.tblContacts where name=?
[Code]....
I Downloaded MySQL Connector (the latest, 6.1.X), and i cant really understand how to use it in VB.Net... I Added it to references. All what I need to know is what imports to use, how to set connection with remote server and how do I select and insert to tables.
View 6 RepliesI have a process that sets the Terminal Server properties on AD users. It has been working fine against Windows 2003, but since trying to run it against Windows 2008, it is failing with "Access Denied" errors. I am using...
View 6 RepliesI am a newbie in VB.NET I am using Sql Server Express 2005 as my database.I am currently working with my THESIS. A Human Reources Information System that concerns only with the file and record management of the employees. With two modules.a. Administrator for HR Manager (w/ installed vb.net and sqlserver express 2005)b. Staff for HR Clerk(w/ intalled vb.net)
Here is my problems:
1. I want to learn how to connect my vb.net application in each other using TCP/IP or any network connection tips.Scenario: If the client Save/Edit/Delete/ a record automatically it will saves on the admin sql database.
[Code]...
For example, a user logs in and sets his status in SQL Server to active. While using the program, it suddenly blacks out. The status in SQL Server remains active. When the user logs in again, he can't access the same account in the program because in SQL Server the status remains active. How can I set the status to inactive during blackouts?
View 1 RepliesI have a little problem with application setting in VB.net 2008. I want to switch main server and backup server connection string with combobox. [Code] It did change the Application Setting connection string in the main form when combobox1 was changed. But the problem comes, when child form was called. On the child form there is DataGridView with Dataset using application connection string. Even the Backupserver was selected on the main form, child form dataset connection string doesn't change. I don't know how to pass the current connection string to child form dataset although it is set to use application setting.
View 6 RepliesI am currently adding keyboard shortcuts to our web application, so from JavaScript.So far, it has consisted mostly in triggering the click events of buttons already exposed in the user-interface.Now, I would like to add another one which redirects to another page.The new page URL needs to be generated based on elements from the source page query string.Basically, I have a date in the query string and I want to generate a new URL for the next day.
View 1 RepliesI need help and wondering if you can help me to get my first project...it's a hobby and wondering if you can get me code for this so i can see how it does it* Evaluate( ) Prints the evaluation of the hand to the evaluation Label.
o If IsFlush( ), prints "flush; "
o calls SetPipArray( )
o Uses a For Loop to go through pipArray. For each element, uses a Select Case statement to
[code]....
In our projects we use setting variables to store user setting for the applications. Moreover, with every latest version of the applications, we upgrade these variables to retain user settings.Normally, this works fine, but recently one of my end user reported an error i.e.Configuration System failed to initialize". The error is related to user.config file. Therefore we requested the user to send us his file.After received the folder, we noticed that it contains 3 files (3begfjb.newcfg,3begfjb.tmp and user. config). 3begfjb.tmp is an empty file, while 3begfjb.newcfg and user.config are identical files. We tried to open these files but the data in user.config isn't proper xml rather its unreadable formatted file.Do any you guys had experienced this sort of issue or any ideas how and what may have created these files and corrupted user.config file.
View 3 RepliesI am using stored procedures in my application using vb.net, while executing stored procedures on mysql database server thru application, the response time from the server is more. Is there any settings that i need to set on mysql db server or any changes in connection string or in code.
View 14 RepliesI have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 RepliesI am writing a custom application for IMAIl express 11.5 using IMAIl Server API for .Net
I am using the following code:
Dim DomData As New DomainData()
DomData.Aliases = "TestALias"
[code].....
I have a server which has around 300+ users on it. Though the problem is that its coded in VB6, and if somebody has a bad ping, everybody has a bad ping. I need a tunneling server which will tunnel the incoming and outgoing connections and make there ping appear to be 0 in the server. Client to Server, Server to Client.
View 1 Repliesi'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 RepliesMulti-User Chat Program (Server & Client) with Main Server?
View 1 Repliesi have 2 application clinet/server the server broadcast media files to client i used tcp/ip protocol the server code is work good but i have a problem in client code i need ineed someone to correct the code .iwll show where the error is in the code note: i call the class in the main form dim a as recive in the starter of the main form class to be gloable .
[Code]...
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
I have a client/server application set up that the client sends a word file to the server and then the server converts that word file to a .TIF and sends the image back.The stuff I have now works.Say if I sent the size of the file and the actual file byte() to the server back to back, would the NetworkStream contain both back to back? This what I though would happen. So I implemented a kind of 'turn' based interaction during the duration of the conversion process.
[Code]...
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesI planing to develop an application which can connect any remote server and pick the configuration information from server and show it in my desktop.
View 4 RepliesThis emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
An application loaded on a citrix server executes with no problem. When we try to run the same program files on a virtual server, we get silent errors and we do not even see the application window appear. The program runs for a moment in task manager, but then closes down. BTW other .net apps run on the virtual server. Here is the error we see in the event viewer application logs[code]...
View 2 RepliesHow can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI wrote a VB code to call a sp in sql server 2005, which returns a recordset as follows:Dim objRecordset As ADODB.Recordset Set objComm = New ADODB.Command
Set objRecordset = objComm.Execute If Not objRecordset.BOF And Not objRecordset.EOF Then
Set objRecordset = objRecordset.NextRecordset I need to continue to get next recordset since there are many select statements inside the sp which I need to get the data. The code works fine when I create the DSN using SQL Server but it does not work when using the connection string or SQL Server Native Client DSN. It either breaks at Set objRecordset = objComm.Execute ( connection string )or at If Not objRecordset.BOF And Not objRecordset.EOF Then(SQL native client )
I have worked on this for a couple of days now and could not figure it out.Is this a bug in SQL Native Client or something related to some configuration on the database side? IS there a way I can change the connection property to get this working using SQL native client or connection string?