Search results for query: *

Hi mirtheil Then I have to go the unconftable way... As we change to another system, we will not upgrade pervasive anymore. Thank you!

Hi I'm currently looking for an option to select the first 50 rows from a table. Within MSSQL the appropriate query would be: SELECT TOP 50 * FROM table But as i have Pervasive 7.9, this is not supported. Does anybody has a workarounde? Thanks very much

Now, i get all the property informations but still the same errors on open or export...???

Ok, so if I am right, the access method from the clients and the one from the PCC has nothing to do whitch each other, right? So, then I could try to copy those data files to the directory, which is given in the table property within PCC. Just tu be sure that nothing is gonna change for client...

Actually I don't know how the application is going to access those files. Is there an other possibility to export Data from those tables without changing anything on the current configuration? I know where the data files are but I cannot access them whith PCC. Thanks

When i move the data files or change the data path, can clients still work with it? This is the productive environment and must be available all the time. How manage the clients by now to access those data in this tables? Many Thanks

Hi, it's a windows server 2003. I've also just recognized, that all tables which cannot be accessed, have another (wrong) "Table Location" than the once which work. But i do not understand from where this information come from and why the clients are able to work with it. thanks med

Hello my company is using a very very old dos-base system which runs on a pervasive sql database. Now i have to provide dataexports for migration into a new system. On the DB-Server itself i've tried whithin the "Pervasive SQL Control Center" to use the export function. I can see all tables...

Hi all we got in contact with CA support and they recomended without a question to move to an MSSQL DB. This procedure was done within 15 min. and should now be much more stable... we'll see thanks dani

Hi all we use BAB 11.1 (Windosw) and have three backup jobs every night. One morning, two of this three jobs displayed within the Status column "corrupted". Also the DB-Backup after the job could (and still can) not be done. Then i did the following: - Run dbcheck utility, everything ok. -...

Hi, below my Trigger. I actually do not change anything whithin the Oracle DB, just read. the vi_relFirma is the view i created in MSSQL with a select statement on the linked server (Oracle). Means this view shows Oracle Data. CREATE TRIGGER t_check_FirmaNr ON dbo.T_Firma FOR INSERT, UPDATE...

thanks, Oracle is Setup on a Windows Machine, if this was your question. I don't understand why i can run a query against this view from the linked server out of query-analyzer, but cannot run the same query against the same view out of a MSSQL insert trigger. Dani

Hi all, i have following problem: - I created a linked server to a Oracle DB. - I created a MSSQL view with a query to a linked OraDB Table. The linked Server as well as the view is working correctly. - then i created a MSSQL table with an insert trigger, which has a query on the created view...

hi, thats the strange thing... nothing which would lead us to the problem is reportet within the system- and application logs. Only after reboot there are information entries about starting services etc. A full disk check is planed but not done yet. What i noticed is, that the process...

Hello all, we have an MSSQL 2000 SP4 on a W2K Server SP4. For a few weeks now we have troubles with the MSSQLSERVER Service, which shut down once or several a day. It comes up again suddenly by itself, but i cannot see what the reason is. For the same time periode the server also reboots itself...

Hi, we use BAB 11.1 SP1 on W2k with GFS rotation job. Till now everything went fine but suddenly it came up with this error. The weekly job still runs fine, only the daly makes trouble. The strange thing is that in the media prediction report it predicts the right tape number and method daily...

thanks a lot! hint from swampBoogie worked perfectly Cheers Dani

Hi all, i have a table relA with a datetime column ADate. this column can contain a value or NULL. Now, i would like to sort the rows as follow: SELECT * FROM relA ORDER BY ADate; Now, the rows with an NULL date appear on the top. How can I change it to appear rows with NULL date value at...

Hi all, some time ago, we have installed BAB 11.1 on a wk2 server machine. At the same time we also added a second SDLT Tape Drive to the second SCSI adapter and added this device to the same group. Now we hade an error in the backup job-log that he was not able to write to the second tape. In...

Hi all, i almost don't belive it but as it seams the problme might be that the tape reached his capacity -> is full! As i already told did i remove 9GB and the problem still exist, then i thought it could be a problem with the "brik level" update from the ms-exchange idividual mail folders...