Sql Server - Strategies For Testing Against A Live System?
Dec 1, 2009
Let me describe the scenario:Our VB.NET web application talks to a third party data provider via webservices. It also saves data in a HUGE SQLServer database which has extensive business logic implemented in stored procs and triggers. The webservice provider also employs convoluted business logic which is quite dynamic.
The dilemma is that both the webservice provider and the sqlserver are essentially live systems and our company has no access to them outside of normal operations (web and SQL calls). Neither offer helpful support on their end.Additionally, the webservice has no 'test mode' and all calls are treated as live transactions. It is not possible to mimic the logic in either of these systems, nor is it possible getting a copy of the sqlserver DB.
So, my question is:How do you do any kind of testing (manual or automated) of our VB.NET application against these live systems?
View 2 Replies
ADVERTISEMENT
Aug 1, 2009
I often get calls from a friend of mine's company saying "ahhh our email is not working!". I thought I could write a program that would test a few things that they could run and have easy answers to my questions when they call. Things like "Is your internet connection alive?", "can you send mail but not receive it?", etc.
[Code]...
View 11 Replies
Apr 21, 2011
Having recently installed IIS Express I was hoping that it was going to make life easier for me, but I've run into a problem almost straight away.Consider the following which is representative of some live code:
Public Shared Function GetServiceId() As String
Dim principal As MyCustomAuthentication.Principal.MyPrincipal
principal = CType(Thread.CurrentPrincipal, MyCustomAuthentication.Principal.MyPrincipal)
[code]....
Running the code under the ASP.NET Web Server (Cassini) everything is fine and I can see that Thread.CurrentPrincipal is of type MyCustomAuthentication.Principal.MyPrincipal.Running under IIS Express this same line throws an InvalidCastException and checking the type I find it is now of System.Security.Principal.GenericPrincipal which is confusing as nothing else has changed.I can confirm that MyCustomAuthentication.Principal.MyPrincipal implements IPrincipal and remember this is Live code, it is currently deployed and working.
View 1 Replies
May 8, 2009
I have developed an application in VB.NET. Now I wanted to know how can we create automatic testing for this application. If VB.NET doesnt suppourt this , then can you tell me the best way to go ahead for testing the application.
View 6 Replies
May 15, 2009
I'm looking into adding some unit tests for some classes in my data access layer and I'm looking at an update routine that has no return value.It simply updates a row based on the id you provide at whichever column name you provide.Inside of this method, we collect the parameters and pass them to a helper routine which calls the stored procedure to update the table.Is there a recommended approach for how to do unit testing in such a scenario?
View 4 Replies
Aug 25, 2009
I use VS team system 2008. At the moment i need to test some business classes, i have found two kinds testing NUnit and the unit testing provided by the VS team system. what are there differences?
View 1 Replies
Feb 9, 2011
Consider the following method that stops a service:
Public Function StopService(ByVal serviceName As String, ByVal timeoutMilliseconds As Double) As Boolean
Try
Dim service As New ServiceController(serviceName)
Dim timeout As TimeSpan = TimeSpan.FromMilliseconds(timeoutMilliseconds)
[code]....
I agree that for domain model code that using the "traditional" unit testing approach makes the most sense as this would lead to a design that is easiest to maintain. However, for code that deals with the .net implementation of Windows API related stuff (file system, services, etc), is there really an advantage to going thru the extra work to get "traditionally" testable code?
It's hard for me to see the disadvantages of using Microsoft Moles for things such as ServiceController (or the File object). I really don't see any advantage of doing the traditional approach in this case.
View 2 Replies
May 13, 2010
I'm building an Active Directory wrapper in VBNET 2.0 (can't use later .NET) in which I have the following:
IUtilisateur
IGroupe
IUniteOrganisation
These interfaces are implemented in internal classes (Friend in VBNET), so that I want to implement a façade in order to instiate each of the interfaces with their internal classes. This will allow the architecture a better flexibility, etc.Now, I want to test these classes (Utilisateur, Groupe, UniteOrganisation) in a different project within the same solution. However, these classes are internal. I would like to be able to instantiate them without going through my façade, but only for these tests, nothing more.
[Code]...
View 1 Replies
Mar 4, 2010
Here is the code for the button click event;
Protected Sub CompetenciesButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CompetenciesButton.Click
Dim con As String = WebConfigurationManager.ConnectionStrings("foo").ToString()
[code].....
View 1 Replies
Aug 20, 2011
I am wanting to create a logon similar to the Windows Live logon, so in other words. user has frmLogon and is located in Australia. The user enters his/her details and then the program connects to a server in the United States and checks the Username and Password to make sure it is correct if it is correct it allows the user to logon and move to the next stage, if it is wrong it will give him an error message. I am wondering if anyone has a tutorial or source code laying around that I can rip apart and see how it works. I want to put the database on my server and connect to it from my desktop using the logon form.
View 3 Replies
Feb 28, 2009
I am trying to verify connectivity from my application to various servers - For now I am only concerned with mail servers... (later SQL etc)Before anyone gets all upset and thinking this is for SPAM - wrong - these are to confirm connectivity from the application for sending logs OR to ensure the SQL conneciton is working appropriately - Those that want to SPAM can do this simply by getting LINUX and doing it for free with ANY mail client (I add this ONLY because MOST SMTP threads go unanswered... which is silly... there are MANY good reasons to work with mail within an application.....)So what I have tried is opening a telnet session, grabbing the output, and going from there...But it is not working.... the output contains nothing specific to the telnet session I initiate - and.... of course from the command prompt manually i DO get the proper responses
[code]...
I get the command prompt header, I see the commands... I see the prompts... but after the telnet command there is nothing I am assuming there is an issue redirecting telnet info and the telnet session terminates the second I try to read the data
View 3 Replies
Jan 28, 2010
I have a utility that is a simple exe that is not installed compiled with VS2005 and works well. But when I upgraded to VS2008 the utility can no longer locate files in the active system folder. I have UAC turned off and am logged in as the Administrator and it still can not locate a file that I can see in Windows Explorer. The file I am looking for is PakMgr.exe.
View 1 Replies
Jun 3, 2011
how to build system inventory that multiuser..1 server and 1 more is client using lan connection..i dont no keyword to search in google..
View 3 Replies
Jun 16, 2010
I want to make a database of all the xbox live arcade arcade games on the xbox live marketplace, I need to parse an xml file and add the needed data from the xml node into a datagridview.Here is the xml file i need to use to grab links and other data about the game:
[URL]
Being the noob I am it took me about 6 hours to figure out how xml works and to write some code for what i need to do.
Here is what i came up with:
'for grabbing the name of the update
Public Sub updatename()
Dim xmldoc As New XmlDataDocument()
[code]....
That code works fine.Now when i add another column to the datagridview called "update size" i want to know how to add the grabbed data from another sub i made to the new column.What would the code be for adding the strings for the new sub into the seconds column? the first was, DataGridView1.Rows.Add(str)" . So what would the second be ?Also another question i have is how do i put an image in an imagecolumn by a web link, not a local picture.
View 5 Replies
Dec 13, 2009
i want to set the system date of my a client pc based on the system date where the sql server reside.In short i want to sysncronize the date between the client and server.I have a working code in vb6 but i dont know how to do it in vb 2008.
dim RstDate As ADODB.Recordset
Set RstDate = New ADODB.Recordset
RstDate.Open "SELECT GETDATE() as ServerDate ", CnAP
[code]....
View 5 Replies
Feb 5, 2010
Vb.net and sql server help?
My application (exe) is made
Using .net (vb.net)
And Backend-sql sever
After making it into package and my client install it into his pc See pic here- the computer name I m talking about Suppose my client machine name is-hcl And I already made all connections string with hcl\sqlexpress using windows authentication in app.config And after sometime he formats his pc and changed his pc name to= hcl-2? Now the problem Is there any way to get the new system name ???? to make connections bcuz its not worth it to always making a new exe and giving it to him when he formats his pc?
View 3 Replies
Jul 21, 2010
how to set the pop3 server in my system?
View 4 Replies
Apr 30, 2010
I am trying to make an Instant messaging program for work purposes, and have decided on creating a server and client based system, but I dont have much experience with the namespace system.net.sockets. could anyone possibly link me to some source code or give an explanation of how this namespace operates and put me on the right path?
View 2 Replies
Aug 2, 2010
I have an application that I'm writing that needs to run 3 different Timers. One that will run every 5 minutes, 1 that will run every hour and 1 that has to run once a day sometime after 5:00 P.M. I know that I can seperate the application into 3 seperate applications and use Windows Scheduled Tasks to perform this however I would prefer to have everything in 1 application and just run the different Sub/Functions off of the appropriate Timer. I'm trying also figure out a way to avoid 2 timers firing at the same time.
What i would like to do is tell the 5 minute timer to run say 2 minutes after every 5 minute mark in the our so the first one would be at 12:07 and then the next would be at 12:12 and so on. The hour timer should run sa at 12:20. The daily one run at say 5:31.Is it possible to use the System.timer or the System.Threading.timer in this way?
View 17 Replies
Aug 3, 2011
i'm creating an IRC server and I already have a few base classes complete like logging and Config. I was about to start with programming the socket class(es) when I realized that I have no idea how to make such a complicated socket system. I do not under any circumstance want to use any other code than my own since that would not help me learn sockets. I am familiar with a single connection socket system like most tutorials use.
[Code]...
View 2 Replies
Feb 11, 2009
I want to watch a folder which is in a server (LAN) from my system. I have done it for the local system and it is working fine but I want watch a folder in a server.
View 3 Replies
Mar 26, 2011
I'm trying to filter submitted web sites by attempting to browse them while bouncing the request off of OpenDNS. If the page received is the OpenDNS page, I'll assume the page shoudld be blocked.
How might I accomplish this task using the System.Net.WebClient class?
View 1 Replies
Feb 26, 2009
How I Can Download The File Into The Server To Client System In Vb.Net Appliction
View 1 Replies
Dec 21, 2010
anyone can teach me how to make billing system which is server - client.i will put the sql database to one pc then clients - the gui system.i want to run may system from other pc then connect to sql database which in another pc..
View 1 Replies
Aug 30, 2010
My System gets restarts When i Install MS SQL SERVER 2005,
View 2 Replies
Sep 16, 2010
So upon a method call to a webservice, I'm getting this error:
"System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true,
[code]....
What could this possibly be? At first I thought it was coming in locally, but someone below pointed out since the error is wrapped in a ServiceModel.FaultException, it might be on the host end. Is it definitely on their end? Or are there any possible ways this could be on my end?
View 3 Replies
Dec 15, 2010
I am trying to build a windows app that uses a remote SQL server to login to the system. I have setup the SQL server on a vmware machine all the conections work fine I have created a form Login with TextBoxUser and TextBoxPass and a submit button.I have added the database conection and created a query called Login
SELECT COUNT(*) AS Expr1
FROM Users
WHERE[code]....
View 2 Replies
Apr 19, 2010
1- I've a database access without password on the Server.I've created forms by vb.net to connect to database through OLedb Connection *like this
PHP
Dim Connec As New OleDbConnection("provider=microsoft.jet.oledb.4.0; data source = \Serverc$xDB.mdb;")
my problem is : I worte : if I want to connect to database from any pc I must save Username and password to control userpasswords2 (soted user name and password from User accounts)that's big problem , so I must save this to all client pc and the client can access Server system Drive there are no security ,this is the fifth day to find a way to connect to my database from server without share system drive.I tried to used it but not working.where can I write server name and path database and server's User-name and password.I've an exe file on server drive like this \Serverc$1.exe
I want some client to run this file with out share the file.If I can to creat a form by vb.net has a Username and password to run this exe without client know the userName and password.I'found map network , but is not ok for me.If I mapped network drive to client, then he can copy files and read some of security data.Is there a way to access this file from server without mapping or sharing folder for public ?
View 4 Replies
Jul 2, 2011
I'm developing a online document management application for my client using the following technologies
Front End - VB.Net 2010 (Windows Forms)
Back End - SQL Server 2008 R2 Express (FILESTREAM enabled to level 3)
I wanted to store the files (*.pdf, *.doc, *.exe, .) using the FILESTREAM feature in SQL Server 2008 R2.I prefer FILESTREAM because sometimes the file size exceeds 2GB.I'm able to save and retrieve file with FILESTREAM (using Windows Authentication/Integrated Security).But my client wants to save or retrieve the file from different PC.So I'm in need of accessing the FILESTREAM BLOB from remote systems.
View 1 Replies
Jun 3, 2010
I have made a project in vb.net 2008 and used sql server 2008 for database and how to make the setup that need to be deploy on those system which do not have sql server on their system .
View 9 Replies
