Im not getting the body of the list as well as the final column (Pricing. I'm assuming that this will require ADO programming by opening up the ODBC connection but am unsure. If you have reports with many pages, click Format Cell. This will verify connectivity and that we can see a field in the Pervasive database using ODBC. All I want to do as a test is set up a simple button and textbox to bring back one field from the ODBC connection to my. adp Access program to an ODBC source? I have tried everything. Does anyone have any code-pieces that connect a. It will not connect using DSN's and I cannot get SQL server to conect to it as a Linked Server. We have been successful in executing stored procedures to the SQL 7.0 database and populating the list boxes and such however, now the once-working ODBC connectivity to the Pervasive database server is giving us fits. I have selected to convert the program to a thinner client by placing the business rules on the backend using stored procedures. Select the DenodoODBC ANSI or Unicode driver, and. mdb using ODBC but is in need of redesign for its user base. Go to Control Panel > Administrative Tools > Data Sources (ODBC). One of the DATA SERVER is a SQL Server 7 database and the other is an ODBC compliant database running Pervasive SQL. mdb Access program connecting to multiple data sources to a. I am helping another programmer convert an application written using DAO and ODBC using a.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |