INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Many errors trying to copy a database on another pc

Many errors trying to copy a database on another pc

(OP)
Hi all, I'm italian, sorry for my english.
I'm trying to copy a PSQL database from a server to my laptop.
I installed Pervasive.SQL v8.6, then I copied all the .BTR files from the server to a specific directory on my laptop.
But when I tried to load the database, I noticed that I can't see the tables.
So I tried to uninstall the engine and many other issues, but nothing was helpful.
Now:
1) when I try to add the database, the error is "Pervasive engine or client data source with this name already exists". I just deleted the databases in "Mantain named database" and the file DBNAMES.CFG.
2) when I try to open the Tables of my database (with another name due to the problem before) I can see only 3 icons:
X$Field:
Xe$Id Xe$File Xe$Name              Xe$DataType Xe$Offset Xe$Size Xe$Dec Xe$Flags
----- ------- -------------------- ----------- --------- ------- ------ --------
1     1       Xf$Id                14          0         2       0      0        
2     1       Xf$Name              0           2         20      0      1        
3     1       Xf$Loc               0           22        64      0      0        
4     1       Xf$Flags             14          86        1       0      0        
5     1       Xf$Reserved          0           87        10      0      0        
6     2       Xe$Id                14          0         2       0      0        
7     2       Xe$File              14          2         2       0      0        
8     2       Xe$Name              0           4         20      0      1        
9     2       Xe$DataType          14          24        1       0      0        
10    2       Xe$Offset            14          25        2       0      0        
11    2       Xe$Size              14          27        2       0      0        
12    2       Xe$Dec               14          29        1       0      0        
13    2       Xe$Flags             14          30        2       0      0        
14    3       Xi$File              14          0         2       0      0        
15    3       Xi$Field             14          2         2       0      0        
16    3       Xi$Number            14          4         2       0      0        
17    3       Xi$Part              14          6         2       0      0        
18    3       Xi$Flags             14          8         2       0      0        

(18 row(s) affected)


X$File:
Xf$Id Xf$Name              Xf$Loc                                                           Xf$Flags Xf$Reserved
----- -------------------- ---------------------------------------------------------------- -------- -----------
1     X$File               file.ddf                                                         16                   
2     X$Field              field.ddf                                                        16                   
3     X$Index              index.ddf                                                        16                   

(3 row(s) affected)


X$Index:
Xi$File Xi$Field Xi$Number Xi$Part Xi$Flags
------- -------- --------- ------- --------
1       1        0         0       256      
1       2        1         0       290      
2       6        0         0       256      
2       7        1         0       257      
2       8        2         0       291      
2       7        3         0       274      
2       8        3         1       290      
2       7        4         0       275      
2       10       4         1       275      
2       12       4         2       259      
3       14       0         0       257      
3       15       1         0       257      
3       14       2         0       274      
3       16       2         1       274      
3       17       2         2       258      

(15 row(s) affected)


Any suggestion? Thank you in advance.

RE: Many errors trying to copy a database on another pc

If you only copied the BTR files, you are probably missing the DDF files.  When a database is created pointing to a directory that does not have DDFs, empty DDFs are created and you don't see any tables defined in the database.  
Make sure you copy all of the DDF files from the server.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Many errors trying to copy a database on another pc

(OP)
I forgot t change the Dictionary Location! That was the error.
Now, if I want to delete the databases name created in the past, what can I do?
I can see the tables, but I can't use the name I want, due to the error "Pervasive engine or client data source with this name already exists".

RE: Many errors trying to copy a database on another pc

You might be able to delete the database by clicking on the "Maintain Named Databases" option found by right clicking on the engine name in the Pervasive Control Center.   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Many errors trying to copy a database on another pc

(OP)
It doesn't work! I did it, I also delete the DBNAMES.CFG but probably PSQL saves the name in a strange file that I cant't find.

RE: Many errors trying to copy a database on another pc

You might also check for an ODBC Datasource name through the ODBC Administrator.  Pervasive only stores Database Names in DBNAMES.CFG.  ODBC DSN information is stored in the ODBC registry entry (HKLM\Software\ODBC).   

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Many errors trying to copy a database on another pc

(OP)
Perfect, it was there.

Thank you very much!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close