I am working with pervasive SQL9 attempting to create a flat file as output. Anyone have any suggestions? I am supposed to be using a storedproc to do this but I don't see any way to capture the data?
Hi,Is the OpLocks setting relevant to the workgroup (non c/server) version of Pervasive?I am aware that with some db's such as Access and Foxpro having OpLocks enabled can cause corruption where as other newer db's need it enabled in order to run fast.I am not sure if Pervasive with it...
Where can I download version 7 of pervasive. It has to be version 7 since I need to create note fields, since their size is 0 in the data files and the record is variable length, but in version 8 the longvarchar fields are a length of 8 bytes. I want to also create the sql scripts to create the...
Hi :)What is wrong with this command ?string strSql2 = "SELECT toInWords FROM services WHERE serviceTypeCode=" + Convert.ToInt32(str2) + " AND clientCode=" + Convert.ToInt32(str) + " AND fromDate1=#" + date1.Date + "#";This is the error that accourd:One or more errors occurred during processing...
Hi Everybody, Can anyone please help me with this problem.I have created a stored procedure called salereg. Now I want to deploy it in the client site.How can I create a script to create this Stored procedure, So that I can directly send this script file and ask the client to run it on the Da...
I've configured many servers and clients. Now I've got one client that keeps getting 3105. Protocols are equal on both sides (client/server). Other workstations are working with no problems. Trying the machine that gives the problem on another server that is running pvsw, gives the...
I have been looking for a way to detect corruption in a Btrieve table and found an old Netware document that refers to using "BUTIL -salvage". However, I am using Pervasive.SQL 8.6 and the BUTIL utility that comes with it no longer has a "salvage" option for the BUTIL tool.Does anyone know what...
It was suggested that we extend an invation to other platforms to come and hang out at the cocktail party..http://www.dbforums.com/showthread.php?p=3691128#post3691128...
When rebuilding files over 100 megs (up to sevarl gigs) from 2000i to V8, it errors out reporting there is no disk space available.The source and destination drive are the same, and have over 100 gigs free.I tried making the destination drive to another drive, smaller (30 gigs) and it worked.Any...
hello,i'm thinking this will work, but just wanted to get some feedback beforei tried it.i want to load an empty table (i created with PCC) on the server,with data from an access database table on my pc.the fields in both tables are the same type, order, etc..can i use an "insert" select qu...
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...
I have to linked dbs. I'd like to modify the properties of one of the tables but I can't do this while they are linked.I've found instructions to select the table and click delete to delete the link. The instructions say that the table still exists but that it just disapears fro...