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 Jsteph All ADSTools is an Alternate Data Stream Editor. I cant figure out how you can use this to Query Active Directory. Cheers Djbell

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...

Ok I am a little further on, I have an external 12v power supply to run the sensor. If I connect the normally open (Black wire) to either an input on the serial or parallel, would this be detected or is there more to the inputs on the these ports?

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 Thanks for the reply. How do I use these functions to populate a query? Also how do I use the drive information function to connect to other PCS on the netwrok and get the drive information on them. Cheers Dougie

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 Mirtheil Sorry for the late reply. Both the clients and the server are sitting on version 9.50.077.002. To be honest I never checked if there was any errors after upgrading to 9.71, I was in too much of a rush to get the server back up and running, I will schedule some downtime again and try...

Thanks for the reply Mirtheil. I tried installing the hotfix PSQL v9.71 onto our system and it killed the server, the Pervasive.SQL (Transactional) and the Pervasive.SQL (Relational) just refused to start. I had to restore my server back before the update. I thought at first I had to install...

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 Guys Thanks for the replys. @Mirtheil to answer your questions. - How many records does it retrieve? Its not many records, its only around 120 records, but it is updated nearly every second with new data (The database is the backend to a Data Collection System, my program takes this data...

Hi Thanks for the reply, but as I said I have never used Pervasive before so I really have no clue, a little more explanation into triggers and what they are would be great. Regards Djbell

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 Borislav Thanks for the reply, I did manage to get to this point on my own, although my query is about 3 times the size of yours and I also had to use the same table twice with an alias. Needless to say I have changed to your code as it is much more efficient. Cheers Djbell

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 Christiaan Thanks for the reply, wish I knew how to do that ealier. Regards Douglas Bell