|
|
conect database
Posted: 06 May 12 9:46 PM
|
i have a database in visual foxpro can somebody tell me how I get that conect to this program... please
|
|
|
Bev Connor
Posts: 117
|
 |
|
Re: conect database
Posted: 07 May 12 10:05 AM
|
The Microsoft ODBC OLE DB drivers for your FoxPro database (download from Microsoft) must be installed on your computer. Then, use a DSN or write a connection string.
Also, in your ITScriptNet program design, confirm that the database field has been set into each collected element's "Database Field" drop-down (to map to) to the FoxPro field.
For more information, please see the user guide - from the ITScriptNet System Console's left pane, Documentation tab, Full User Guide:
For validation files, see the user guide page 248;
An example view of generating a validation file from an ODBC data source, see page 254.
For Configure Receive - transfer data from the device to the computer, see page 263.
If your computer is running Windows 7, Please download the PDF from this link:
http://www.z-space.com/kb/Article.aspx?ID=10231&SearchID=5401
|
|
|
| |
|
Re: conect database
Posted: 07 May 12 10:17 PM
|
after i try to generated a validation file gives me a validation error sql query error and in fill field list says. unable to open recordset
SELECT [producto].[barra], [producto].[costo], [producto].[codigo], [producto].[nombre], [producto].[precio1]
FROM [producto]
ORDER BY [producto].[barra] ASC
|
|
|
Bev Connor
Posts: 117
|
|
|
Re: conect database
Posted: 08 May 12 11:41 AM
|
ITScriptNet simply uses a Microsoft ODBC connection to pass data to/from a source. There are a number of issues that could cause an improper connection, such as an incorrect ODBC driver, incorrect username/password access, other permission issues, firewall, connection string, naming conventions. ‘Unable to open recordset’ points to a database or connection issue. This would not relate to the software. Your best approach would be to contact your FoxPro vendor for further assistance.
Working with connection strings can often be tricky, as every provider has their own differences. You might also check here for FoxPro: www.connectionstring.com.
|
|
|
| |
|
mc9000w
Posted: 22 May 12 8:53 PM
|
| now i got this working but the scanner doesn't scan just see the red night and nothing happend |
|
|
| |
Bev Connor
Posts: 117
|
|
|
Re: mc9000w PPC 2003
Posted: 23 May 12 9:10 AM
|
First, check which client software was loaded to your scanner: Run the ITScriptNet client software on the scanner; at the main menu (4 buttons), just above the 'Collect Data' button, the client should display as "Symbol Picket PC 2003". If not: exit the software on the scanner to the scanner's desktop, and reload the ITScriptNet client software from the computer's ITScriptNet System Console (Configure Devices), making sure to select the MC9000 PPC client from the drop-down list.
|
|
|
|