fuzmic
IS-IT--Management
- Sep 3, 2006
- 20
Hi friends
Situation
1 In the ODBC Data source Admin Dialog, a System DSN Data source say A-CO is created using vfpodbc.dll (Jan97) driver pointing to a folder say Z:\CO\ that contains numerous VFPro Free tables.
2 Using a Access .mdb database, there is no problem linking to a target free table say Vend.dbf in the above folder.
3 However using Access .adp project (connected to SQL 2000 Server Manager) trying to link to the Vend.dbf free tables in the using A-CO folder failed.
How was the .adp link done?
1. Using the Link table option > Linked Server, i can see the above A-ISE in 'My Data Sources'.
2. Click this source will show all the free tables in the Z:\CO folder.
3. When i select the Vend.dbf and finish the Link Table Wizard, the following message appears OLE DB provider 'A-CO does not contain ''Default'\'vend''.
Tinkering
I have tried various combination of availiable options with no avail. Options used were
1. Transact SQL 2. Add New Connections 3. ODBC DSN 4. Other/Advanced 5. ms OLE DB Provider for ODBC Drivers.
Please help me cross this block. I searched the web & found method to link to a .mdb from .adp; none for the above. Thanks in Advance.
Situation
1 In the ODBC Data source Admin Dialog, a System DSN Data source say A-CO is created using vfpodbc.dll (Jan97) driver pointing to a folder say Z:\CO\ that contains numerous VFPro Free tables.
2 Using a Access .mdb database, there is no problem linking to a target free table say Vend.dbf in the above folder.
3 However using Access .adp project (connected to SQL 2000 Server Manager) trying to link to the Vend.dbf free tables in the using A-CO folder failed.
How was the .adp link done?
1. Using the Link table option > Linked Server, i can see the above A-ISE in 'My Data Sources'.
2. Click this source will show all the free tables in the Z:\CO folder.
3. When i select the Vend.dbf and finish the Link Table Wizard, the following message appears OLE DB provider 'A-CO does not contain ''Default'\'vend''.
Tinkering
I have tried various combination of availiable options with no avail. Options used were
1. Transact SQL 2. Add New Connections 3. ODBC DSN 4. Other/Advanced 5. ms OLE DB Provider for ODBC Drivers.
Please help me cross this block. I searched the web & found method to link to a .mdb from .adp; none for the above. Thanks in Advance.