Pervasive.SQL

• Pervasive.SQL Questions

• • Table Designer Error

    I am attempting to access the table design on my existing Pervsiave database.Here's the configu...

    By jensterd

  • Token Ring to Ethernet causing application errors

    Our company tested a segment of Ethernet clients set to auto negotiate, and we got desktop memory an...

    By jayhild

  • Unlink Table to Modify Properties

    I have to linked dbs. I'd like to modify the properties of one of the tables but I can't ...

    By tmort

  • Crystal Reports and Pervasive SQL connecting throu...

    Hi,Currently I have crystal reports set up directly to a Macola database using the DDF files. I can...

    By rizzo89

  • Substring problem in SQl

    hi all , I have one problem that is I would like to take only number from String like : ...

    By ramesh_nim

• • btrieve 5.10a & Crystal Reports

    I'm doing some beginning research on Btrieve 5.10a & Crystal Reports. Our very small company h...

    By debbie45, 3 Comments

  • encyption database access

    I am trying to use odbc to connect to an encrypted database. I have the key, but I do not know how ...

    By jeffs, 3 Comments

  • AMSI Btrieve .ddf

    I am attempting to integrate with a software package called AMSI. The software uses btrieve files t...

    By menard_1, 1 Comments

  • Embedded Pervasive Data Export

    Hello all,This is a very broad question but i really don't know where to begin. Basically there...

    By bryanj, 4 Comments

  • Clipper access to Betrieve Files

    Anyone know of a third party lib. or software, freeware or shareware... or any coded methodolgies th...

    By wlgibbs, 2 Comments

• Pervasive.SQL: is the Category's subject.It's has 478 questions,this is No.24 pages.
• Grouped view joins are not supported.
• Trying to select specific records from a view that is made from selections pointing to two other views. Done this many times in MS SQL Database enviro... no joy in Pervasive... Ideas besides building a separate view? (counter to my goal of one view serving many reports, etc...)...
• cablalock, Sun, 14 Mar 2010 06:04:00 GMT, 298 bytes, 6 Answer
• Problem with pvjdbc2.jar
• Hello! I'm trying to connect to a PervasiveSQL 9 Server but I fail.The driver that I use is pvjdbc2.jar (pvjdbc2x.jar might be needed).Here is my codeClass.forName("com.pervasive.jdbc.v2.Driver"); String url = "jdbc ervasive://database_host_name:1583/source_name";DriverManager.getConnect...
• fedai, Sat, 13 Mar 2010 05:07:00 GMT, 3,027 bytes, 1 Answer
• Dropping connections
• Hey everyone.This just started happening about 2 days ago, and is happening at 2 sites, with 2 different programs (one accounting, one police reports). Both use Pervasive 8.6 on their respective servers.Occasionally, ALL users will be disconnected with errors ( I don't have them handy, but...
• dougp25, Sat, 13 Mar 2010 04:55:00 GMT, 1,044 bytes, 1 Answer
• Pervasive/Daceasy under Redhat Linux?
• I have an question I thought I may get answered here. I have always used RedHat Linux for my gaming servers but recently bought a new server as a file server for my office. I have been using it for basic file storage but would like to use it to serve the files for my accounting program. I use Da...
• pgodden, Sat, 13 Mar 2010 04:54:00 GMT, 992 bytes, 1 Answer
• Pervasive and SQL 2000
• Hi,I am totally new to pervasive. I dont have any knowledge abt it. The scene is that i am working in sql 2000 and my DW accesses data from pervasive. Due to some reasons the pervasive server was updated. My daily extraction process failed. When checked the foloowing error we were getting the fo...
• prachin, Sat, 13 Mar 2010 03:10:00 GMT, 2,003 bytes, 1 Answer
• Row/Record Locking
• Hi,Is there a recommended method to perform row/record lock in Pervasive SQL?I'm working on an application that has the database on the server and is accessed by 4 desktops and 2 PDA (Pocket PC 2003 SE). I cannot find any Compact Framework libraries and desperately need to use it as I will...
• michaelhyk, Fri, 12 Mar 2010 10:54:00 GMT, 1,129 bytes, 2 Answer
• Sunsystems - Btreieve file How to export it to access or others?
• I am using Sunsystems Version 4.2 which use Btreive 6.15I have ODBC Driver from Pervasive.I have installed and try to create ODBC connection to btreive file.But the ODBC Administrator ask for Login and Password.I have tried to use blank and/or admin of SunSystems But it doesn't work.Please...
• thsoft, Thurs, 11 Mar 2010 23:39:00 GMT, 336 bytes, 1 Answer
• Btrieve, Peachtree, and JDBC
• I am trying to retrieve data from Peachtree for use in a custom JAVA application. I have downloaded and installed an ODBC driver that works with Btrieve, connected to it through Suns JDBC-ODBC bridge, and can see the tables (I'm using Squirrel to test this). However, whenever I try to see...
• fdillon, Thurs, 11 Mar 2010 20:52:00 GMT, 887 bytes, 1 Answer
• 8.6 (SP2 Update) Win 2003Server hangs after some time
• sorry, posted this one twice. Please read other thread....
• pklauss, Thurs, 11 Mar 2010 18:09:00 GMT, 55 bytes
• Stored procedures
• I'm trying to create a procedure. It's not very long (about 40 lines) and the syntax is OK. I can save it without any problems. But when I open it I see that the procedures last few lines are missing. I can't save them. When I delete some spacing and remove some fields from my SEL...
• darlok, Thurs, 11 Mar 2010 10:15:00 GMT, 484 bytes, 11 Answer
• Migrating Btrieve from Server to Workstation
• Hi to all!I've got a DOS apllication that uses Btrieve on a Netware 4.11 server, and i want to set it up running locally on a Win 95 workstation or on a Win2000 server...The issue is that i can copy all the application files to the workstation, but when i try to execute it locally, it gives...
• rica_carv, Thurs, 11 Mar 2010 04:47:00 GMT, 563 bytes, 3 Answer
• Pervasive Message: Error retrieving error information
• Does anyone what the following error means?Message: Error retrieving error informationSQLState: S1000Vendor: -17 at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:85)java.sql.SQLException: Error retrieving error information at com.pervasive.jdbc.lna.LNAObject.getErr...
• ltutar, Wed, 10 Mar 2010 21:18:00 GMT, 1,038 bytes, 3 Answer
• Tables Vanished From Control Center
• Pervasive V8.7Yesterday, some SQL queries stoped working. The errors indicated that the referenced table could not be found or is not accessible. When I opened the Pervasive Control Center the table was no where to be found. Now all of the tables are gone but one. How do I get these table ba...
• wing25nut, Wed, 10 Mar 2010 21:06:00 GMT, 329 bytes, 2 Answer
• Upgrading from V8 server to V10
• If we install V10 on our current server running V8, is it going to be a seamless upgrade? Anyone with bad experience? Do i need to uninstall and install? what's your recommendationsThanks...
• msk2007, Wed, 10 Mar 2010 21:04:00 GMT, 202 bytes, 1 Answer
• Importing into Pervasive SQL 2000i
• I have a software product that was developed in VB 6.0 and the developer used Pervasive SQL 2000i for the database. It's a program we had custom developed for our hobby store to track club events and data on club members. The developer is no longer around literally. He passed away 9 mont...
• acerocks, Wed, 10 Mar 2010 16:50:00 GMT, 543 bytes, 6 Answer
• How to migrate data from Microsoft SQL database to Pervasive SQL and vice versa
• Hi,I would like to know what are the ways to migratedatabase (1) from MS SQL to Pervasive SQL(2) from Pervasive SQL to MS SQLPlease advise.Thank you.Sally...
• sallypeh, Wed, 10 Mar 2010 15:44:00 GMT, 189 bytes, 2 Answer
• Pervasive.SQL DataSource Configuration in JBoss
• Can anyone send me the xml file for the Pervasive.SQL datasource confiuration in JBoss.Thanks....
• chandrag59, Wed, 10 Mar 2010 14:06:00 GMT, 104 bytes
• Help! Need System File
• My win98 doesn't work well, without a system file 'lwbhmvxd.vxd', it starts innormally. I know 'lwbhmvxd.vxd' is a file of Pervasive.SQL2000 (English), but it isn't in my computer.Who could send me the file or attach it here, it's just in the '\PVSW\BIN�...
• shaanlan, Wed, 10 Mar 2010 09:57:00 GMT, 513 bytes, 1 Answer
• SUBSELECT doesnt work
• I'm new to Pervasive SQL but I have been using MS SQL 7 and 2000 for 5 years now. I have a problem. I can't make this SELECT work:SELECT a.id FROM( SELECT id FROM TABLE1) aHow to make it work?Thanks in advance....
• darlok, Wed, 10 Mar 2010 04:49:00 GMT, 255 bytes
• Btrieve API and marshaling in VB.Net
• Has anyone had any experience using the Btrieve API with VB.Net?Does marshaling work for Btrieve API as for Windows API? Has anyone had experience/success using the Btrieve ActiveX controls in place of trying to call the Btrieve API directly in VB.Net?Any info would be greatly appreciated...
• yakshasa, Wed, 10 Mar 2010 04:04:00 GMT, 319 bytes
• «««1415161718192021222324