How do I create external views in a MS VisFoxPro5.0 Database using ODBC that will allow only SPECIFIC MEMBERS of a Physical File on the AS400 to be accessed? I am using the ODBC Manager supplied by Client Access (The software supplied with AS400s to allow interconnectivity with a Windows network or PC). I have attempted to create external views in my FoxPro Project Database using both 'Connections' and 'Avail. Data Sources'. I have tried specifying the Member by using '.' and by using parentheses. Does anyone know a connection string syntax that might help me?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC connect to access AS400 files from NTnet using VisFoxPro?
- Thread starter fineday
- Start date
One suggestion is to create logical file views over the specific physical file member(s) to which you want to provide access. CRTLF & some DDS specifiying the columns (fields) will suffice. Ensure proper authority is provided if you allow adds, updates, deletes in addition to *USE (Read & Execute).<br>
<br>
Also, if you want to prevent access (directly) to the original physical files, change the authority to *EXCLUDE *PUBLIC.
<br>
Also, if you want to prevent access (directly) to the original physical files, change the authority to *EXCLUDE *PUBLIC.
Do you have the correct ODBC Drivers is my first question? <p>Randal Cooke<br><a href=mailto:randy.cooke@elkviewcoal.com>randy.cooke@elkviewcoal.com</a><br><a href= Mining</a><br>Just another Techno Super Freak Wannabe....Sigh.
Guest_imported
New member
- Jan 1, 1970
- 0
I'd like an AA/400 ODBC to connect to Microsoft Query. Can anyone help?
- Status
