Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Error message: bad driver nameSearch Forum

Forum Home > FlexODBC - ODBC Driver for DataFlex Embedded DBMS > FlexODBC Bug Reports

 New Topic 
 
 Post Reply 
[1]  
 Error message: bad driver name 
 Author   Message 
  Bjørnar 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-06 
 Profile
 Posted : 2007-03-06 18:29:09

Hello

 I try to use Flexquarters FlexODBC version 4 to read from a dataflex database:

1. I have put the data from the database in a folder called c:\data\ 

2. I set up the ODBC driver

3. I try to use the ODBC driver using the demonstration program (VB) that is sent with the ODBCdriver.

a) Try to log in with the user Admin, no password 

b) Push the button tables, and I get a list of all the tables

c) Try to execute a query (For instance: Select * from Kunder) and I get the following error message from the vb program: [FlexODBC][FLEXERR] Bad driver name  

 Can anyone help me figure out what is wrong?

 Best regards
 Bjørnar Brendryen

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-06 23:25:12
Following the successful installation of FlexODBC you should immediately tell FlexODBC where your DataFlex data is located! Click on "Start" and "All Programs" and locate the "FlexODBC Driver for DataFlex" program group on your desktop. Click on the "FlexODBC Setup" icon to launch the setup program supplied with FlexODBC.

Click on the "..." button in the FlexODBC Setup to search
your system for your DataFlex data setting for DFPath.

Locate the local or remote drive and folder that contains your DataFlex Data.
Note: The folder will need to contain a file called "filelist.cfg" in order for FlexODBC
to operate. Click on "Open" and "OK" to save the new DFPath.

The DFPath for the Visual DataFlex v10.1 Order Example is shown here.

Step 4 - Seeing your Data
Now that DFPath is configured to point to your data, it's time to test your connection. Click on "Start" and "All Programs" and locate the "FlexODBC Driver for DataFlex" program group on your desktop. Click on the "VB Demo" icon to launch the Visual Basic Demo program supplied with FlexODBC.

To establish a connection: From the menu bar
select "Connections" | "Add New connection".

Select the "Machine Data Source" tab and "DataFlex Data32" User DSN, Click "OK”.

Click on the "Tables" button to display the list of Tables in your application.
The tables from our Visual DataFlex v10.1 Order Example are shown here.

To view the contents of a table, double click on the table name of interest to you,
for example "CUSTOMER". The Select statement will change to the name selected,
for example "SELECT * FROM CUSTOMER". Click on the "Query" button and the requested
query results will appear! In case you're wondering, the * in the SQL Select statement
means all columns in that Table.

FlexODBC supports the use of multiple tables and Left Outer Joins. For example,
to view all Customers and their Orders, regardless whether they have orders
or not, we can type in a complex SQL Statement like the one shown below
and execute the query.

The customer "La Avenida Mexican Store" is displayed in a
Left Outer Join, even though it has no orders.
To disconnect, you can either select "Connections" | "Remove
the connection" or Click the "Disconnect" button

Trouble Shooting
If you have successfully made a connection in the VB Demo with our test databases but cannot make a connection with your own data, refer to the manual for possible solutions. The FlexODBC Manual is installed with the program and is in a PDF document file which is viewed with Adobe Acrobat. The Adobe Acrobat installer, if you do not have Acrobat Reader, is on the CD-ROM or at www.adobe.com.

If the manual does not address your specific problem contact the dealer or distributor you purchased the product from for further assistance. Any other questions or technical support can be addressed to support@DataAccess.com.au.

DataFlex File Extensions
In DataFlex, regardless of the operating system the files and specifically the file extensions are the same. The following is a list of DataFlex files that FlexODBC utilizes in its operation and what they represent:

bullet

FILELIST.CFG - The file that holds the index to all DataFlex database files

bullet

COLLATE.CFG - The file that holds the collating sequence used in indexes

bullet

*.DAT - Files containing the data

bullet

*.VLD - Optional compressed data file used in conjunction with the .DAT

bullet

*.K1 (thru .K15) - Index files for a data file (Index 0 is Record Number)

bullet

*.TAG - Files containing the database field names

bullet

*.INT - Intermediate File containing external database driver information and table configuration details.

 

  Top 
  Bjørnar 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-06 
 Profile
 Posted : 2007-03-08 21:09:18

Hello

 

 

Thank you for your reply.

 

 

This is exactly what I do.  

 

 

And when I click the button Query I get the error message that I described: [FlexODBC][FLEXERR] Bad driver name  

 

 

But I do not understand what this error message means

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-09 09:26:10
FlexODBC needs to be run on a workstation logged in with administrative rights, not a Terminal Services or Citrix session. 

  Top 
  Bjørnar 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-06 
 Profile
 Posted : 2007-03-09 18:39:29

Hello

I am computer administrator on a workstation with Windows XP Proffessional Service pack 2.

I do not use Citrix or Terminal services.

The data folder is copied from another computer, is that a problem?

Best regards Bjørnar.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-09 23:27:47
Try using the DataFlex Test32 DSN installed with FlexODBC to see if FlexODBC is working correctly. There's a ALLHITS database that you should be able to view in VB Demo. 

  Top 
  Bjørnar 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-06 
 Profile
 Posted : 2007-03-13 00:23:33

Hello

That works.

What does that mean? That something is wrong with the other data that I tru to read?

Best regards Bjørnar

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-13 08:12:49
Does your data folder have .INT files, for example Kunder.int? Your filelist.cfg may be pointing to non-embedded DataFlex DBMS tables, in which case FlexODBC will try to load the driver named within the .INT file and because it's not in your data folder, it will say "Bad Driver name". 

  Top 
  Bjørnar 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-06 
 Profile
 Posted : 2007-03-13 18:45:08

Hello

yes I have INT files in my data folder.

For example for the table kunder I have:

Kunder.BTR

Kunder.FD

Kunder.INT

 

Best regards Bjørnar

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-13 22:08:31
Ok, you're not using the embedded DataFlex DBMS, you're using Btrieve or as it's known these days as Pervasive.SQL datafiles. FlexODBC isn't the driver you should be using here, try looking at: http://www.pervasive.com/developerzone/access_methods/ODBC.asp 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to