Search results for query: *

I'm getting closer to my performance problem in another post --- I think ---- I think that I have some indexes in this database which are "btreive only" and don't come over to the relational side, probably because all the utilities that the application uses are still in cobol. How do I tell...

Oh yes, before I forget: 1) Pervasive 9.5 client & server 2) Database box is dual xeons with 4gb of RAM with RAID-5 on the database volume and RAID-1 on the OS volume with physically separate discs (obvivously); The box has the capability to be multi-homed but is not, using one connection to...

Howdy, I have what should be an easy query to execute but alas, it takes 30-40 seconds to actually run; lacking good analysis tools I'm having to make some guesses about where the fallbacks will be: Guess 1: One table has three fields (well a lot more, but only 3 that I am concerned with...

tc3596 --- can't help you out I'm fighting with psql myself; but I feel your pain bro, I'm a MS-SQL guru ML

Before I spend a while working out a query, does Pervasive support left and right outer joins? ML

does PSQL have a TABLES datatype that can be used in place of a temp table?, I thought I saw a tempdb on my pervasive system, what is the role of the tempdb database in Pervasive? ML

aaaargh! they're killing me!

In the Eclipse based PCC for 9.5, where did the query builder go, I can make a new SQL document and am good at SQL but the query builder sure speeds some things along.

I'm on 8.5 now, and I have about 58 clients in 2 buildings to upgrade tomorrow morning to 9.5 **adds to his list of reasons not to use pervasive** ML

Has anybody ever pushed out a pervasive upgrade through a GPO SW installation policy? If so, how did it go? Any trouble? ML

> It just sucks at running queries on large dbs. Anything will work faster when it just has to display data; but that doesn't do much good when you need dynamic reports and everything else in near real time without a lot of steps or needing a programmer/analyst involvement. I've used crystal...

Thanks, I'm reading the query analyzer docs you sent the link for.......initial thoughts are making me think I need to find a new job

Mirtheil, will running check database potentially harm anything?

I'm not working on crystal reports yet but I'm having dreadful query performance through ODBC for what should be a simple query (and I've not put the first join in it yet either) but since the schemas of the database are a 2NF at best and attempted 3NF showing a sequence of development over...

Howdy All, We are upgrading our credit card processing system to the enterprise based product, however, the product does not have modem failover if the internet is not available for processing. As such we are going to be upgrading our network to use a DIA circuit instead of DSL since it has...

do you have exchange running with SBS and are your users using exchange (its unclear from your post)

> If there was a function somewhere that would > enumerate the users in an OU, and another > function to check whether or not a user account > was logged in, this would be totally do-able. Anyone > know of those functions? Anyone? Anyone a command line dsquery command can find the users...

Remove the old driver and then reinstall either of them. I'd recommend a reboot if possible after you remove the old driver.

....things to watch out for ....compatibility issues ....security chagnes to keep in mind? any gotchas etc

Howdy All, We've been advised by our point of sale vendor to upgrade from Pervasive 8.5 to 9.0 (or whatever teh latest one is). I can't find any docs that really describe how to upgrade, just a lot of stuff telling me if I have files over this size then they'll be able to get to this other...