Recommended Application(s) To Test SQL Server 2008 Queries For Application?
Apr 11, 2012
I am new to working with SQL databases (and databases in general) so I do not have a lot of experience with how queries work and how I can practice them. When I was first learning xml and XPath, I found XPath Visualizer incredibly helpful after someone on stack overflow mentioned it to me.Due to this, I am wondering if a similar tool exists for SQL databases?Basically a tool that will allow me to connect to a database,enter queries and see somehow what the results would be like.
I have looked online a bit, however I have found relatively few options in terms of any utility that would do what I want, and that looks reliable.I will ultimately be writing an application to interact with an SQL 2008 server in vb.net, however for now I am just experimenting so I will know what I am doing when I actually want to create my application.So far I have managed to connect to the database using an OLE DB connection, but I am now looking for a way to experiement with queries without just querying and figuring out a way to interpret the results in my program. Basically I want to be able to remove the programming aspect of things so I can experiment with queries without needing to question anything in my code that is unrelated to the specific query.
I have an application that works together with a SQL database. This database has more than 40 tables and my applican has to extract different situations from those tables.
I have predefined some queries for the situations that I know they need to be in the application.
The idea is that I need kind of a module in which an user can create his own situation based on the tables, views, functions and procedures that already exist in the database. Something like it is in SQL. There has to be a library or something which will read my sql database directly from my application and which allow the user to create his own queries and situations.
i'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?
I have a problem related, not only to VB.net, but also Oracle.I have a simple application that runs queries from an Oracle db (Oracle 9i) and creates reports from it. I am using the official oracle.dataAccess component.I need a very simple report that returns a list of usernames. Something like "SELECT userName FROM users".(userName field is a VARCHAR2).Problem with this query:The top 50 rows are OK.All the remaining are strange characters.
I am sure some of you have seen this project before. I need to create an application that queries customer name (first and last) and there addresses. I need more than that but once I figure what i am doing wrong with that, I should be able to figure out the rest on my own. I am using VS 2010. I can not figure out the proper syntax for String.Format. I can only get it to display the first and last names of the customers.This is the code I have so far:Public Class Form1
I'm building an application that will be using several (7) SQL queries, I'm wondering whats the best way to approach this since I've never built an app with this many queries in it. These queries really won't change, just the start date and end date and I have query in my first form that finds out the next available date by checking a table. What I'm wondering is if it would be better to construct these queries in my application or if it would be better to use stored procedures on my sql server to do the same thing and not have the application carry the load of the queries.
I'm developing an application with Visual Studio 2008 (with visual basic), first of all, I'll give a brief of what I'm planning this module will do.
It's an accounting application, that I use to administrate some of my company's movemets. The application links directly with MS SQL server 2005, and sends queries to the database like: client name, employee Id, transacion type etc. Right now I'm developing a contracts module, wich is intended to be used with Microsoft Word 2007. We want the module to do the following: (It's a contract document; the document should get the variables from the application like contract type [that would change the template of contract used in microsoft word depending on the type], Client name, Salesman name, today's date, name of the company's representative)
1) After the data has been captured from the application (the application has a capture module that sends the info to the database), instantly send the capturer to microsoft Word, to a layout that has variable fields that should fill themselves with the database information ( I don't have a clue on how to do that )
2) The capturer should be able to change text in the contract layout and fix the variables info in case they were misstyped, adn when he/she saves the document; if there were any variables edited, they should get updated in the database; and the application should be saved with a name that has variables on its name ( 1)today's date in DDMMYY format, 2)First 2 letters of the client's name, 3)last 3 digits from tye contract number), save the file in a directory where all contracts are in .docx format (could use any frmat, it actually doesn't matters), and send the file location to the databse; to a table field named "file" wich only has the file's route.
3)From my application, when consulting the data, give the app access to the file directly; simply by getting the query form the database.
I am trying to run simple application (e.g. generated from template by VS.NET 2010) on IIS6. I changed it to run with .NET 4.0 (its application pool) and checked with regiis (this pool has 4.0). I also changed all possible httpHandlers (svc etc), to run with NET4.0. All possible rights are checked (i think so). Almost every request results in "Server Application Unavailable" (sometimes it is empty page with -2146232576 (0x80131700) value) and "...Please review this log entry to discover what caused this error to occur." but EventViewer and IIS Log are empty.
I am having some difficulty with an xPath expression. I am using an XML document to store queries / stored procedure names in an ASP application. I use a utility function to load the xmldocument (if it isn't previously loaded) and I am attempting to select the node set from the document that matches an Id element. [code] the node variable only returns the first element. I have verified the that the qry string that is used to SelectSingleNode IS the correct Id value (i.e. USER002) - however the node is getting loaded with the USER001 element. It is obviously the xPath expression that is messed up. What do I need to tweak on the xPath expression so that I can return the correct <Id> element and corresponding child <Sql> element.
I have wrote an Application for a organisation and they had let the app run in their lan using Samba, it worked perfect. Now they want to work over the internet.The Problem is that I have written this app with Sqlite, that means its currently working so:They have a exe and the sqlite dll and the sqlite database on their samba server and they connected a network drive on their windows pc to run it. So that means every pc is writing over samba to the sqlite database.
I tried it over the internet, but like i thought sqlite is a local database and its very slow, even if the ping is under 50ms. I could create a tcp server, that handles all and writes all to the sqlite database, but I have already written around 20.000 code lines for the project, so that would be not the best option for the lazy me. I have used only one sqlite class in my client for querieng, so I thought that it could work without much work, if i would replace the sqlite database adapter with the mysql database adapter, since sqlite has nearly the same syntax then mysql.
Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.That is working, so, so far so good.My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?
I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there The nonplusultra would be that it only starts the server when you click on the shortcut.
I am looking for some advise, I currently have a VB.Net application using .NET frameworks 2 written in VS 2005. One of my clients wants to know if the application works with Unicode, at the moment I have not tested this and what I am looking for is some advise on how to do this e.g.
1) Does anything need to be added to my project e.g. code to allow this functionality. 2) Is there a way that I can easily check to see if my application can work with Unicode? 3) Advise on how other people test for this? I know it is a bit general, but as I have not done this before I am obviously trying to build my knowledge and get it right with regards to testing etc.
I am looking for some advise, I currently have a VB.Net application using .NET frameworks 2 written in VS 2005. One of my clients wants to know if the application works with Unicode, at the moment I have not tested this and what I am looking for is some advise on how to do this e.g.
1) Does anything need to be added to my project e.g. code to allow this functionality.
2) Is there a way that I can easily check to see if my application can work with Unicode?
3) Advise on how other people test for this?
I know it is a bit general, but as I have not done this before I am obviously trying to build my knowledge and get it right with regards to testing etc.
It apparently came to my mind to test my eyeBlink using an application. Through the use of my webcam, I want to perform some commands. For eg: When I blink my eye, it should open notepad. How can that be done?
the system is going to have two front-ends - one web application and one desktop application.The desktop application is going to be coded using VB.NET, and the web application in PHP. There's really no reason why the desktop application can't be replaced by a web application as well - except that one of the programmers seem to really want to code it in VB...However none of us have experience working with either of these pairs .
P.S. hosting service will be gotten from some provider and not be on the client's own server.
I am currently going through Murachs Beggining .net programming book. I am trying to implement an application for an exercise at the end of chapter 5. The application specification is as follows.
I'm doing a project in VB.NET, in which the application will interact with SQL Server 2008 database. I know how to develop that application. But after created executable version of that application(.exe) i will install it in another machine. How will that application interact with database at that machine??
how to develop unicode application in vb.net and sql server 2008 ?how to start develop and what are the things i have to consider to develop effective unicode application ?. this application should support japanees and english language based on user selection.i took steps but i don't know it is correct.
1. i created tables in sql server with fields, for strings - NVARCHAR, for integer INT, for datetime DATETIME,for numeric NUMERIC.
2. i created another setting-table to have all screens name,label names ( for labels and grid column headers ) and corresponding japanees display names and another column for english display text.
so i'm just going to fetch Japaness/english display names from setting-table on form load and change the labels.Are these correct ? or anyother way to do unicode application effectively ?
I'd like to create a simple application to determine the writing speed. In this application I want to view a line of text (may be more than one line) to the user to write it. And I want to select (higlight) the character the user pressed in my line and to move like a cursor to the next character (or to put underline under the current charater). How can I do that? and what is the object or component i must use to insert the text. Finally, if I want to make it multiple lines how to determine the enter key pressed by the user and how to move the cursor to the next line?
Currently I'm writing a VB.NET app and it's getting big, resulting in its become very slow.Is there any application (or plug in) that can test the performance in seconds?I mean, when I click a button and it displays a product, I want to know exactly how long it is gonna take.
my friend is currently development an application using SOA Architecture, He sent me a picture with a lot of layers (10 almost) and he is worried about performance issues, the application is development on VB.Net 2.0 & 3.5 (some libs).
I am developing an application which will be used to scan the barcode from a particular document, as i am just developing who i will get know that barcode scanning is working i dont have device at the moment
I am trying to deploy an application that uses SMO on a workstation without SQL Server installed on it. The instance the app is connecting to is SQL Server 2008. The application is failing with:Could not load file or assembly 'Microsoft.SqlServer.Replication, Version 10.0.0.0, Culture=neutral,PublicKeyToken=89845cdc8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.
The assembly in question is in the same path as my application as well as system32. I am running this on a Windows 7 64 bit box. I have run SQL Native Client, CLR, and SMO MSIs from the 2008 SMO redist download page.This app worked fine when connecting to SQL Server 2005.
I am trying to deploy a VB.net application that is currently using SQL Server 2008 as its database to connect to.I need this application to be able to include a copy of its data so that wherever I install the application there is no need for them to install SQL Express.
What i have been reading is that I should of been using SQL Server Compact Edition to do this. Is there any way that I can do this with using an .MDF file?If not, is it possible to convert an .MDF file to .SDF and then just include it in my vb.net app?
I packaged a VB 6.0 application using the Package and Deployment Wizard. After that I executed setup.exe in the package to setup the application. On Windows Server 2008 (32 bits), however, I received the following error when processing the setup:
I need some pointers on which .NET technology to use for a project I'm working on. I'm building a "dashboard" digital signage WPF program that will display various things on a large monitor mounted high up in the ceiling of my office.What I need to be able to do is control certain aspects of this program from my desktop. For example, there will be a TV window in the application with signal being provided by a TV tuner on the mini-computer connected to the monitor in the ceiling. What I want to be able to do is make a remote control to be able to change the channel etc. I'm confused at what technology to use. I've read about remoting, WCF, and simple TCPclient classes but I'm confused at which one would be better. I'm thinking it may be better to use WCF because what I think I need to do is make a function that will change the channel and accept channel numbers, etc from the remote control program. Am I on the right path?
