Search results for query: *

Hi All I am using the integrated Crystal Reports within VS Studio 2005. I have 3 views in my MS SQL Server View1, View2, View3, View1 and View2 consolidate data in 2 tables, View3 combines the data in View1 and View2. My Crystal Report is based on View 3. After trying various permutations in...

Hi All I use Access 2007 and I am also a domain Admin. I have created a database that basically takes a file created from a program called dumpsec and restructures it into a readable table. I also have 2 other tables, 1 called Users and 1 called groups, at the moment I manually fill the...

Hi All I have a SICK WL12-2P430 sensor, it has 4 wires. Brown - Live Blue - Ground Black Input High White Input Low Voltage DC 10 - 30v What I would like to do is connect this via my RS232 port and detect an input on the Black wire. My initial thoughts were connecting Brown to RTS, Blue to...

Hi All I am looking to create an application that monitors production. The application itself is not a problem to code, what I am stuck on, dont even know if its possible is how to detect the products. I thought of 2 ways, a standard 12v Photosensor, but not sure how I could wire that up to...

Hi All I am looking to implement a backup solution for my new servers, but I havent done much with backups for a while, so looking for advice. There will be 3 servers to be backed up, A Lotus Domino Server, A SQL Server and a File Server, the total data amount to be backed up will be around...

Hi All Is it possible through coding to get a query to do the following? Query 1 List the contents of a specific folder on a computer which displays the following. Name / Size / Date Modified (Basically Like the Details view of a Folder) Query 2 List Drive Information So basically a Query...

Hi all I am running Pervasive SQL 9.10.020 database on a Windows 2003 server. I have 4 clients that pull information from the database using ODBC every 5 seconds using a select query (Clients are a custom VS2005 application) the select query is a simple query just pulling out some figures...

Hi All I have been left in charge of a VB.Net program that pulls data form a Pervasive 9.1 database. The program pulls data from a View in the Database, unfortuantly this view isnt the fastest in the world and it hangs the VB.Net program while it pulls the current data. My thoughts were to...

Hi All I have a table that looks like the following. Name |ID|DATE |PAYCODE|HOURS|MONEY J DOE | 3|01/01/08 |Hours |7.25 |NULL J DOE | 3|01/01/08 |Money |NULL |26.75 J DOE | 3|01/02/08 |Hours |7.5 |NULL J DOE | 3|01/02/08 |Money |NULL |28.95 J DOE |...

Hi All I have a table like the following. Name||||Hours||||StartDate||||EndDate Dougie|| 8 ||||01/11/2008|||01/11/2008 Colin ||| 5 ||||03/11/2008|||03/11/2008 Frank || 39 ||||05/11/2008|||09/11/2008 I would like the query to do the following. Name||||Hours||||StartDate||||EndDate...

SQL Version: 2000 Hi All I am trying to set up a linked server in SQL with a product called Sage Line 100. I go through the wizard and set up as it should be, but I keep on getting authentication errors and cannot browse any tables. I have set up other linked servers before without any...

Hi all I have a VB.net frontend that writes to a SQL Server 2000 database, one of my fields on my form is just a text box that a user type whatever into. I am using just the basic INSERT INTO SQl command to post to the SQL 2000 Database, unfortuantly I get SQL errors if a user uses any...

Hi All I am new to SQL 2000 after coming from Access DBs, I am trying to create a query that is based on two tables. Tabel1 = ProductionMain Table2 = ProductionDowtime Both these tables have a field called ProdcutionID, this is the primary key field for the prodcutionMain table. What I want...

Hi All I have a SQL Server 2000 database that I would like to link to an external apllication (Sage Line 100) The Sage Line 100 link would be via ODBC. What I want is I want to create an SQL query that links one of my SQL tables with one of the tables in Sage Line 100, but I cant figure out...

Hi All I have a Snap Server 1000 that has just suddenly stopped responding, the only light that is on is the System light that flashes once every second, no other light is available, Snap Assit or Manager can no longer see the SNAP server. This is causing me huge issues as I need the data that...

Hi All I have a database that was created to collect Asset information, on the asset information form I enter a user that is responsible for the asset. Each user has an asset view that allows them to see what assets have been assigned to them, but for some reason all assets that I have created...

Hi all I just recently had to move my pervasive 9.1 server from a Windows XP machine to a Windows 2000 machine (This was due to the client connection limitation of 6 users on an XP machine) every thing works fine except that the speed of clients accessing the database has dramatically decresed...

Hi All Just been reading the previous post, although it sounds good Ghost seems to be way overkill for what I am looking for.. All I want to do is shutdown my servers load a Image Boot CD, take an image copy of my server boot drive (SCSI, Windows Server 2000 and 2003) and store it on a...

Hi All I have a table in my MS 2000 SQL Database server called employees. In this table I have 4 fields and data as follows.. Name Clock Hours Absent D Jones 001 10 14/08/2007,15/08/2007 D Smith 002 18 13/08/2007,14/08/2007,15/08/2007 What I would like is to create a...

Hi All Just new to the VB.Net stuff, so ave been asking some questions lately, thanks for yer replys its been great help.. So onto my question.. I would like to create a small application that i can type a start IP / End IP and subnetmask. I would like the app to scan the network for all...