• Home   /  
  • Archive by category "1"

Providex Odbc Driver Assignment Error Message

PxPlus SQL ODBC Driver

Frequently Asked Questions

This page provides answers to some commonly asked questions about the PxPlus SQL ODBC Driver and other PxPlus File IO products:

 

Note:
The information given on this page assumes that you are using the latest version of the PxPlus File IO products. If you are encountering issues, check that you are using the latest version.

Should I use the 32-bit or 64-bit PxPlus SQL ODBC Driver?

The PxPlus SQL ODBC Driver that you should use depends on the applications from which you will be using it.

If you are using the PxPlus SQL ODBC Driver from a 32-bit application, then you need the 32-bit driver. If you are using the PxPlus SQL ODBC Driver from a 64-bit application, then you need the 64-bit driver. If you are using the PxPlus SQL ODBC Driver from both a 32-bit and a 64-bit application, then you need to install both the 32-bit and 64-bit drivers. The PxPlus SQL ODBC Driver can have both the 32-bit and 64-bit versions installed at the same time using the same license. For example, if you are using the PxPlus SQL ODBC Driver from Microsoft Excel, then you likely need the 32-bit driver, as most users have a 32-bit version of Microsoft Office. If you are using the PxPlus SQL ODBC Driver from Microsoft SQL Server 2012, then you likely need the 64-bit version, as this is a 64-bit application.

Important Note:
A 32-bit operating system cannot run 64-bit applications. If you are using a 32-bit operating system, your applications are 32-bit and you need the 32-bit PxPlus SQL ODBC Driver. If you are using a 64-bit operating system, your applications could be either 32-bit or 64-bit. The method used to determine whether an application is 32-bit or 64-bit varies depending on the type and version of the operating system. This information can be found on the Internet based on the type and version of the operating system you are using.

I'm creating a new Data Source Name (DSN) for Windows. Why isn't my installed PxPlus SQL ODBC Driver listed?

The most common reason for this likely has to do with the 64-bit Windows having two versions of the ODBC Data Source Administrator: a 32-bit version and a 64-bit version.

On Windows versions prior to Windows 8, the 32-bit version is hidden in the C:\SysWow64 directory, and the 64-bit version is accessed through the Control Panel. If you open the 64-bit version of the ODBC Data Source Administrator and try to create a new Data Source Name (DSN), only 64-bit PxPlus SQL ODBC Drivers are listed.

If you open the 32-bit version of the ODBC Data Source Administrator and try to create a new DSN, only 32-bit PxPlus SQL ODBC Drivers are listed.

If you are using Windows 7 and install a 32-bit PxPlus SQL ODBC Driver, and then you go to the Control Panel to open the ODBC Data Source Administrator, you will not be able to create a DSN because only 64-bit PxPlus SQL ODBC Drivers are listed. The solution in that case is to go to C:\SysWow64 and launch odbcad32.exe to get the 32-bit version of the ODBC Data Source Administrator, which allows you to create a DSN with the 32-bit PxPlus SQL ODBC Driver. For your convenience, the installer for the PxPlus SQL ODBC Driver can optionally install a shortcut to the 32-bit ODBC Data Source Administrator.

On Windows 8 and higher, the ODBC Data Source Administrator is labeled as 32-bit or 64-bit, so this becomes less of an issue.

I'm trying to configure a Data Source Name (DSN). Why am I getting the following error(s): "The setup routines could not be found" and/or "The specified DSN contains an architecture mismatch"?

The reason that these errors are occurring likely has to do with the 64-bit Windows having two versions of the ODBC Data Source Administrator: a 32-bit version and a 64-bit version.

On Windows versions prior to Windows 8, the 32-bit version is hidden in the C:\SysWow64 directory, and the 64-bit version is accessed through the Control Panel. If you open the 64-bit version of the ODBC Data Source Administrator and try to configure a Data Source Name (DSN) created for a 32-bit PxPlus SQL ODBC Driver, you will get this error.

If you open the 32-bit version of the ODBC Data Source Administrator and try to configure a DSN created for a 64-bit PxPlus SQL ODBC Driver, you will get this error.

If you are using Windows 7 and go to the Control Panel to open the ODBC Data Source Administrator, and then select a DSN to configure that was created for the 32-bit PxPlus SQL ODBC Driver, you will get this error. The solution in that case is to go to C:\SysWow64 and launch odbcad32.exe to get the 32-bit version of the ODBC Data Source Administrator, which allows you to configure the DSN. For your convenience, the installer for the PxPlus SQL ODBC Driver can optionally install a shortcut to the 32-bit ODBC Data Source Administrator.

On Windows 8 and higher, the ODBC Data Source Administrator is labeled as 32-bit or 64-bit, so this becomes less of an issue.

I set up a Data Source Name (DSN), but why don't I see any tables?

If the PxPlus SQL ODBC Driver reports 0 (zero) tables, the most common reason for this is an incorrect setting for either the Database Directory or Definition File fields when defining the DSN.

The PxPlus SQL ODBC Driver uses the data dictionary (providex.ddf) file or an INI file to retrieve the list of tables. If the Data Source Name (DSN) is not correctly pointing to the data dictionary or INI file, then it will report 0 (zero) tables.

If you are using a data dictionary, check that the Database Directory setting contains the path to the directory where the data dictionary (providex.ddf) file can be found. In addition, check that the permissions on the file are permissive enough for read access for the user using the PxPlus SQL ODBC Driver.

If you are using an INI file, check that the Definition File setting includes the path to the INI file and the name of the file. In addition, check that the permissions on the file are permissive enough for read access for the user using the PxPlus SQL ODBC Driver.

If you are using a client/server ODBC setup, check that the settings are relative to the server. For example, a Windows PxPlus SQL ODBC Driver configured to use a Linux PxPlus SQL Server should have the Database Directory and/or Definition File fields set to Linux paths as if the setting was for a local PxPlus SQL ODBC Driver on the Linux server.

For details on configuring the Database Directory and Definition File settings for a DSN, see PxPlus SQL ODBC Driver Configuration (Windows) and PxPlus SQL ODBC Driver Configuration (UNIX/Linux).

I can see my tables, but why can't I access them?

Check the actual location of the physical files and then verify that your data dictionary, INI files or prefix setting points to the correct location.

If you are using a client/server ODBC setup, then make sure the Prefix for data files setting is relative to the server. For example, a Windows PxPlus SQL ODBC Driver configured to use a Linux PxPlus SQL Server should have the Prefix for data files field set to a Linux path as if the setting was for a local PxPlus SQL ODBC Driver on the Linux server. If the table you are trying to access is a View, refer to the response for I can access all of my tables, but why can't I access any Views? for details on Views configuration.

For details on configuring the Prefix for data files setting for a DSN, see PxPlus SQL ODBC Driver Configuration (Windows) and PxPlus SQL ODBC Driver Configuration (UNIX/Linux).

For details on how to determine if the data dictionary and INI files point to the correct physical file locations, see Data Dictionary Maintenance and INI Definition.

I can access all of my tables, but why can't I access any Views?

Verify that the Path to Views DLL setting is configured correctly. It should point to the directory where the view dll/so file can be found.

If you are using a Windows version of the PxPlus SQL ODBC Driver or PxPlus SQL Server, the Views DLL that you need to point to is pvxwin32.dll, which is installed with the Windows version of PxPlus.

If you are using a UNIX/Linux PxPlus SQL ODBC Driver or PxPlus SQL Server, the Views DLL that you need to point to is libpvx.so, which is installed with the UNIX/Linux version of PxPlus.

If you are using a client/server ODBC setup, verify that the Path to Views DLL setting is relative to the server. For example, a Windows PxPlus SQL ODBC Driver configured to use a Linux PxPlus SQL Server should have the Path to Views DLL field set to a Linux path as if the setting was for a local PxPlus SQL ODBC Driver on the Linux server.

Note:
If you are using the 64-bit Windows PxPlus SQL ODBC Driver or PxPlus SQL Server, Views cannot be used because there is no 64-bit Views DLL (pvxwin32.dll).

For details on configuring the Path to Views DLL setting for a DSN, see PxPlus SQL ODBC Driver Configuration (Windows) or PxPlus SQL ODBC Driver Configuration (UNIX/Linux).

Can I perform a join between more than two tables?

Yes. To do a join with three or more tables, you need to nest a join within a join. Two methods for nesting a join within a join are: (1) nest the join where the first table would normally be, and (2) nest the join where the second table would normally be. Parenthesis can be used to make reading the join easier.

Example: 

SELECT * FROM (Customer LEFT OUTER JOIN SalesReps ON Customer.SALESREP = SalesReps.SALESREP) LEFT OUTER JOIN Shipping ON Customer.CUSTID = Shipping.CUSTID
SELECT * FROM Customer LEFT OUTER JOIN (SalesReps LEFT OUTER JOIN Commision ON SalesReps.SALESREP = Commision.SALESREP) ON Customer.SALESREP = SalesRep.SALESREP

See Using the PxPlus SQL ODBC Driver.

Why is my SQL query so slow?

The most common reason for an SQL query that is being processed by a PxPlus SQL ODBC Driver to take a long time is that the SQL query itself is inefficient. The PxPlus SQL ODBC Driver will do exactly what the SQL query asked it to do. If the SQL query asks it to do a huge amount of file IO, then this will take a long time in any case. An example of this is if your SQL query is a cross join between two large tables with millions of records each, and you ask the PxPlus SQL ODBC Driver to read the entire second table every time it reads one of the millions of rows of the first table.

To help ease this problem, two effective strategies are available. The first strategy is to try to always use key fields in the WHERE clause of the SQL query. When you filter based on a key, the PxPlus SQL ODBC Driver can go directly to the data in question instead of having to read through the entire file. The second strategy is to minimize the amount of data you ask the PxPlus SQL ODBC Driver to read. This means that wherever possible, avoid joining large tables and use more restrictive joins instead of a cross join.

Why am I getting a "Network Communication" error and/or an "ISAM Communication" error?

These errors are typically caused by incorrect settings for the Server Name or IP field and/or the TCP/IP Port field for the Data Source Name (DSN). Check that the network name or IP address and the port are correct. You can verify the port on which the SQL Server is running by looking at the Configuration application (if it is running on Windows) or looking at the pxpsqlsvr.conf file (if it is running on UNIX/Linux).

If these settings are not the issue, then verify that there is no network problem and test to see that the server is reachable from the client. You should also verify that firewalls on both the client and the server are not blocking the client or server communication.

In addition, check that there is no client/server version mismatch. For details on client/server compatibility, refer to the response for Is version X of the PxPlus SQL ODBC Driver compatible with version Y of the PxPlus SQL Server?

For details on configuring the Server Name or IP and/or TCP/IP Port settings for a DSN, see PxPlus SQL ODBC Driver Configuration (Windows) or PxPlus SQL ODBC Driver Configuration (UNIX/Linux).

Is version X of the PxPlus SQL ODBC Driver compatible with version Y of the PxPlus SQL Server?

While every possible effort has been made to ensure that each version is compatible, there are some limitations regarding which version of the PxPlus SQL ODBC Driver works with which version of the PxPlus SQL Server.

The following table indicates the versions of the PxPlus SQL ODBC Driver that correspond with the versions of PxPlus SQL Server.

PxPlus SQL ODBC Driver Version

PxPlus SQL Server Version

4.21

4.21

5.00

4.21+

5.10+

5.10+

32-bit

32-bit and 64-bit

64-bit

32-bit and 64-bit

If you attempt to use the PxPlus SQL ODBC Driver with a non-compatible version, the result is usually an ISAM communication error or other network error; however, it can also lead to undefined behavior and crashes.

Does the PxPlus SQL ODBC Driver work with Sage 100?

Yes. However, it is important to keep in mind that it is impossible to guarantee that it will always work in the future because at any time, Sage could change how their files work. Be aware that, if using the 64-bit PxPlus SQL ODBC Driver with Sage 100, you must bypass password authentication by leaving the Password field blank for the Data Source Name (DSN). This is because the 32-bit Sage 100 has a security DLL that cannot be loaded by the 64-bit PxPlus SQL ODBC Driver. Bypassing the authentication works by ignoring the password and just giving you access to the data files.

For details on configuring the Password setting for a DSN, see PxPlus SQL ODBC Driver Configuration (Windows) and PxPlus SQL ODBC Driver Configuration (UNIX/Linux).

Can I test the PxPlus SQL ODBC Driver and/or PxPlus SQL Server before purchasing?

Yes. When installing the product, leave the Serial Number and User Count fields blank and enter DEMO for the Activation Key field. Alternatively, you can just leave all the fields blank. The product will then install and allow you to use all of the features. However, each time you use the product, you will be presented with message box popups informing you that you are using a non-activated/demo product. These message box popups will prevent you from testing any background applications that use the PxPlus SQL ODBC Driver or testing the running of the PxPlus SQL Server as a service/background process. The reason for this is that when running in the background, you cannot see and clear the message box popups.

If you decide to purchase the PxPlus SQL ODBC Driver while running in Demo mode, you can activate the product without reinstalling. For the Windows PxPlus SQL ODBC Driver, open one of your Data Source Names (DSN), select the Activation tab and enter the activation information. For the UNIX/Linux PxPlus SQL ODBC Driver, edit the license file and enter your activation information. For the Windows PxPlus SQL Server, use the Configuration application, select the Activation tab and enter the activation information. For the UNIX/Linux PxPlus SQL Server, edit the pxpsqlsvr.conf file and enter the activation information.

For details on activation during installation, see File IO Product Installation and Activation (Windows) or File IO Product Installation and Activation (UNIX/Linux).

For details on activating an installed product, see PxPlus SQL ODBC Driver Configuration (Windows), PxPlus SQL ODBC Driver Configuration (UNIX/Linux), PxPlus SQL Server Configuration (Windows) or PxPlus SQL Server Configuration (UNIX/Linux).

 

 

 

 

По-видимому, Танкадо считал, что два эти события чем-то различались между. Выражение лица Фонтейна не изменилось. Но надежда быстро улетучивалась. Похоже, нужно было проанализировать политический фон, на котором разворачивались эти события, сравнить их и перевести это сопоставление в магическое число… и все это за пять минут. ГЛАВА 124 - Атаке подвергся последний щит.

One thought on “Providex Odbc Driver Assignment Error Message

Leave a comment

L'indirizzo email non verrà pubblicato. I campi obbligatori sono contrassegnati *