select convert(yourtimestampfield, sql_date)from timestamptable; select convert(yourtimestampfield, sql_time)from timestamptable; Rok Pierre...

Rok Debeljak

08-27-2003 02:58 AM
Rok Debeljak

Hello! I have a running Pervasive SQL V. 7 Database Server Engine (Service Pack 6) in my network. I tried to use the database in C# for...

Markus Jung

08-26-2003 10:25 AM
Markus Jung

Hi, I'm trying to set up Pervasive.SQL Server v7 (sp6) on Win2000 Server with Terminal Services. I have an application that I can run locally on...

Greg Doherty

08-26-2003 03:40 AM
Gordon

I'm a long-time user of Btrieve, but there's something I've never fully understood. If this question is plainly answered in some...

Adam Augusta

08-25-2003 04:41 PM
Bill Bach

Hi, I have a MS Access 2000 database that I would like to move it to Pervasive SQL Server. It's an invoice database that contains 6 tables which are...

Bre-x

08-25-2003 04:16 PM
Bill Bach

Gary, There is a utility called butil.exe that comes with the Btrieve 5.10a package. This utility can load the contents of your data files to...

rwickers

08-25-2003 02:04 PM
Roxton

I hate to say this, but I think the Pervasive.SQL V8 brequest is messed up. Since you have Pervasive.SQL 2000, run that brequest...

LHarvey

08-22-2003 10:07 AM
LHarvey

Typically Pervasive is not CPU bound so whichever processor will likely make little difference in performance. It is however usually IO bound so the...

LHarvey

08-22-2003 10:04 AM
LHarvey

Hello, we own a 50 user licence of a Pervasive Btrieve V7 server engine for netware. Now we plan to buy a new FileServer with Netware 6.5. We will...

Hans Tepe

08-22-2003 09:46 AM
LHarvey

I have a 20 user license for Btrieve 6.15 and I now need a 50 user license. Does anyone sell upgrades to the licenses or just the 50 user license?

news.shore.net

08-21-2003 01:13 PM
Brad Kunkel

Hi there To create a database to link to from Excel, I run the CreateDB.exe utility. Apart from clicking next a few times the only user input is...

Michael Rekas

08-20-2003 01:50 PM
Michael Rekas

I have a product that uses Pervasive 2000i and the Pervasive ActiveX controls v7.90.245.008. I use memo field type LONBVRCHAR but the ActiveX...

Phil Chapman

08-18-2003 08:49 AM
Phil Chapman

Can anybody tell me, how to install wbtrv32.dll ? I tried to use BtSearch32 from www.nssdd.com to create DDF then to export my netware btrieve...

yohanesh

08-17-2003 11:07 PM
Gil

Hello, I have to edit .dat files, using a dos based program Btrieve Browse ver. 3.30. What I need, is a help-file, a user's manual, or whatever...

Henrik Olsen

08-14-2003 12:08 PM
Klaus Scheidgen

Hello, I'm totally new to Btrieve, and i need to access data from two old btrieve databases. I've no .ddf files, no owner name, only a password....

David BRETEL

08-13-2003 10:25 PM
Bill Bach

Bill Hmmmm.. I am only using raw btrieve, not any of the fancy SQL stuff. However, I can see that your stored procedure would be fast. Is there a...

Andy Rigby

08-11-2003 06:32 PM
Bill Bach

hi i'm using Pervasive.SQL 2000i under windows 2k. i want to create tables with names longer than 20 characters and columns with names longer than 20...

noam

08-11-2003 11:27 AM
Bill Bach

I want to store files in a database, I have absolute no clue how I do this. I have a structure like this: typedef struct DB_DOCUMENTBASE { DWORD ...

GTi

08-11-2003 04:34 AM
Gordon

hello, i'm experiencing a strange problem while fetching SQL data from Pervasive 2000i database into the Cocoon script. The inside-Cocoon-script...

mefiu

08-08-2003 04:11 AM
mefiu

Hi All, I am having lot of difficulty getting BREQTCP to work on XP. I have checked the Pervasive knowledgebase and tried all the...

Sutha

08-07-2003 03:13 PM
Caleb Land

Gordon <grafzerk (AT) bigfoot (DOT) no.spam.please.com> wrote To note: I've made my decision and its no on the upgrade. The issues that would be...

Ecator

08-06-2003 05:25 PM
Ecator

Has anyone out there written recursive stored procedures on Pervasive.SQL 2000i or Pervasive.SQL V8? If so, do they work well? How deep could they...

Bill Bach

08-06-2003 02:38 PM
Bill Bach

Hi, In psql v8 pervasive introduced TOP to be part of a sql query. Is there any way to do something like this within psql 2000?? Thanks in...

Koek

08-06-2003 02:37 PM
Bill Bach

Hello, our working environment is: PSQL 7.0 SP 5 on Netware Server DOS-Application using Btrieve API to access data on the server For demonstrating...

Karl Friedrich

08-06-2003 02:33 PM
Bill Bach

Hi, I am an experienced developer on several database but I am very new to Pervasive My company is using a program which uses the pervasive...

enders

08-06-2003 06:02 AM
enders

Hi Can someone please confirm that btrieve version 6.10a was shipped with an unlimited user count licence. Alternatively, if this is not the case...

Andrew Chapman

08-05-2003 11:16 AM
Mirtheil

This solution sorted out my problem and it works for this environment: Windows NT 4.0 server with Pervasive.SQL 2000(i SP 4). Bob Wirtz has replied...

Joni Tuoreniemi

08-04-2003 06:31 PM
Bill Bach

I am developing a VB6 program using the Microsoft ADO Control with a bound grid (True Grid Pro 7). The table I am accessing is in a Pervasive 2000i...

Michael Baugh

08-04-2003 06:27 PM
Bill Bach

Files can only be locked when they are open. The easiest solution would be to get all the users out of the application (suggested before doing any...

LHarvey

08-04-2003 05:22 PM
Bill Bach

Hello I m student for computer science and in my final project I need to derive reports from btrieve. We don’t have any tools and we are working in...

avihai

07-31-2003 02:17 PM
Gil

I think this is a _very_ valuable idea. But, I see some problems/difficulties... 1. If the holding table is a Btrieve file, we need a special...

S Nelissen

07-30-2003 11:12 AM
S Nelissen

"Most Magic apps I've seen use either the Btrieve date or the INTEGER DATE - 1901. Pervasive.SQL 2000i has built-in date handling routines to...

Halwon

07-30-2003 09:06 AM
Halwon

Database Manager for Pervasive SQL Version 2.1 now available. Database Manager will allow to get a full supervision on your database Pervasive SQL....

radiy

07-30-2003 12:45 AM
radiy

Hello ! I want to write Pervasive SQL V8 Data into a MS SQL Server 2000 Table. I am using Pass-Through-Queries: Example: SELECT * FROM OpenRowSet

aaapaul

07-29-2003 07:50 AM
aaapaul

Hi, i know that Btrieve 6.15 is a very old one, but we have several users that still use the 6.15 workstation engine. If the data is on another PC...

Arnd Iffland

07-29-2003 07:04 AM
Arnd Iffland

Jerome, BtSearch will recognize all the btrieve data types as well as several other data types. You can use BtSearch to help you analyze...

Jerome DELGRANGE

07-25-2003 01:43 PM
Gil

Gene, In case you ever need a query like we discussed again. The following will work. The query below will sets the Bills.LetterStatus to C (...

Phil Chapman

07-24-2003 03:29 PM
Phil Chapman

Thanks for the help "Rok Debeljak" <rok.debeljak (AT) email (DOT) si> wrote

Phil Chapman

07-24-2003 03:18 PM
Phil Chapman

SELECT * FROM "Table1", "Table2" WHERE "Table1"."JoinField" = "Table2"."JoinField" (+) Good day, Rok Adam Augusta wrote:

Rok Debeljak

07-24-2003 02:56 AM
Rok Debeljak

Trey, The mertech drivers for pervasive are originating from drivers to Oracle, SQL-Server and now My-SQL from a database developement tool called...

Bill Bach

07-22-2003 09:48 AM
Peter H. van Wijk

Hello, I have installed P.SQL V8 (Workgroup engine) on a XP Computer as a local workstation engine. Installation has to be done with administrator...

Axel Potthoff

07-22-2003 08:20 AM
Axel Potthoff

Btrieve is owned by Pervasive at www.pervasive.com. You can download their trial version of V8 at www.pervasive.com/downloads. Once you get...

Gil

07-21-2003 11:18 AM
Gil

OK, apologies in advance for a pretty unusual question, and the cross-posting in dBforums... Up until a botched backup and restore last week one of...

Neil Hughes

07-21-2003 08:32 AM
Neil Hughes

Terry, To get the client side settings you don't need to call PvConnectServer just use a handle value of "-1". That should get you the client side...

rwickers

07-18-2003 05:36 PM
Terry B.

Two mystery messages have appeared at a customer site of mine in thePVSW.LOG on their Win2000 server. Has anyone seen these messages? Can anyone...

Bill Bach

07-18-2003 12:06 PM
Bill Bach

Does anyone know where to get the Btrieve/Pervasive ODBC V2.54 drivers??? awoodward (AT) salemgroup (DOT) com

BedWind

07-18-2003 10:20 AM
Bill Bach

If you need to create the DDF files for your btrieve file you can take a look at BtSearch at www.nssdd.com. It helps you analyze the structure and...

Gil

07-18-2003 10:18 AM
Bill Bach

Greetings. First and foremost, while fairly skilled with Access, I am a novice when it comes to ODBC connectivity, VB, and Btrive. That...

JSwinney

07-18-2003 10:17 AM
Bill Bach

Any idea why a newly setup workstation running a 16bit app would get st=1010. Only happening on WinXP. Admin does not get error. User does have full...

Sue Matlosz

07-18-2003 10:08 AM
Bill Bach

Matthias, This error 14 is this a Btrieve error status? What format are the db files you are using? A butil -stat operation of a data file will...

rwickers

07-18-2003 02:14 AM
Matthias Hartmann