how can i open .mdf files( SQL server files) and access the data. I downloaded MSDE software but unable to install it says Strict username and psaaword required . were should i look for that....
What is the SQL command to list all tables in a database?
What is the SQL command to list all columns in a table?
I am trying to run a MS Access query on a linked table. On one of the fields I need to have a "empty" criteria that the user must specify when running the query. When I link the table and run ...
Hi,
I've been searching various sites and have come upon various solutions to connect to Oracle from ASP. But, unfortunately none of them work and all i am left behind is frustration. I hav...
I need to find out where can download the btrieve odbc driver for windows for free so that i can access btrieve data from ms access, which i don want to install the btrieve/pervasive database ...
We use an applications called TAS. It uses Btrieve and we have used Pervasive SQL v8 SP1 as a transactional server engine for some time on a Netware 5 server. We've recently moved this to a ...
I need an ODBC driver for a btrieve database, I only have the .DAT files, and need to convert them to MSSQL server (I use the MSDE2000). But first I want to access the data, and for that I nee...
Hi there.
I have a client that has an old DOS Btrieve database with several .dat files named customer.dat, etc. I am looking for some kind of utility to convert these .dat files into somet...
Hi,
Below is the output of my PVSW.log file which I have obtained from System32 directory. The network is setup with pervasive / betrieve workgroup v8.6. All users log files are the same. I...
Can anyone tell me what the following errors mean? From my Pervasive server log.
I have (hopefully) repaired the table, but I would like to ensure this doesn't happen again if possible.
03...
I am completely new to databases beyond Microsoft Access. Learning how to use SQL is still a project for when I have time in the future. :|
I have a database, containing quite a few tables,...
Hello all,
I have an Access 2k db that uses a Pervasive (SQL V8 SP1) connection to an accounting package. The tables from the accounting application contain invoice transactions with lots ...
I have been tasked with accessing data from Peachtree and importing it into either Access or SQL server. I am not sure what options are available to me or even what database Peachtree uses (I...
I have sql server linked with Pervasive V8.6 and when i run query in query analyzer it gives me this error.
Error converting data type DBTYPE_DBDATE to datetime.
select field one, Cast...
Hello,
I need to convert some excel file to Btrieve .dat file using VB.NET. Also, I will need later to convert that Btrieve .dat file back to excel. I have no idea how to do this (because I...
am getting a btrieve error of 3103 everytime I try to start my database program. can anyone tell me what the problem is and how to solve it?
I am also getting error 3012 on several of my ot...
I am trying to create an ODBC DSN using the Pervasive ODBC Engine Interface. After entering the database name (see question below), the data file locations and dictionary locations, I click O...
I am receiving btrieve errors in our software of 3012, 3111, and 3112. Is there any help for this. The version of pervasive is 7.9. I cannot access the monitor using a TS client. I read ab...
I have a customer that can run a btrieve application fine from any workstation and even from the server. But when he tries to run it remotely throught terminal services he gets a status 3014
...
I have a a set of dat files that I need to export to excel or access...even a text file would do. I have no problem paying for the conversion software but I at least want a trial version to m...
I am trying to connect to a PSQL via ODBC
My server is Windows 2000 running PSQLV8.0
i am using a php script.
but when i try to connect to my database using the odbc_connect() function (my ...
Hi I am Using pervasive 8.6 workgroup on Windows 2003 server.
When accessing the pervasive monitor utility and selecting active users, I get the error message "Insufficient rights to get o...
Can someone help me connect Crystal 10.0 to my Peachtree 2005 database? This is not the Crystal for Peachtree version, just plain crystal reports 10.0. Not sure how to make the connection,...
Hi Experts
The script below, when run from php command line ie. php odbctest.php, returns a list of DSN's as expected.
When run in a browser ie. http://localhost/odbctest.php, the browse...
I want to open and edit a .BTR ( btrieve ) file using VB6. I know the structure of the file and also i have DDF files. I just want to brows data in the first step and change some data in some ...
