If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Pervasive SQL 200i ODBC Connection not showing Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-09-09, 17:51
ddrolet ddrolet is offline
Registered User
 
Join Date: Dec 2009
Posts: 1
Wink Pervasive SQL 200i ODBC Connection not showing Tables

I am able to create a System DNS ODBC and it says it connects succesfull.
but when I use the ODBC is only shows the system Tables
X$Field, X$File,X$Index
I see .ddf files in the data directory folder on the server.
How do I make the ODBC reference the .ddf files so I can export the data. I downloaded the "Mirtheil Software" but I only see the "System Tables" in the drop down.

Any guidance would be greatly appreciate.

David
Reply With Quote
  #2 (permalink)  
Old 12-09-09, 17:58
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,015
If you only see the system tables (X$FILE, etc), then it's likely the DDFs you have don;t have any other tables defined. Did the DDFs you are using come with the software generating Btrieve files? My guess is that these DDF files were created when the ODBC DSN was created. When a DSN is created pointing to a directory that does not have DDFs, empty ones are created.
You would need to either find DDFs that have the table definitions or create the table definitions manually (through CREATE TABLE statements or DDF Builder tools).
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
Reply

Tags
ddf, mirtheil, odbc, pervasive, tables

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On