While defining the OleDB Connection I Got this message :
Test Connection Failed because of an error initilizing provider
(When i try to view the catalogs)
CWBCO1049-The iSeries Application is not started
The Following Steps where performed:
1.STRHOSTSVR SERVER(*ALL)
2.Grant Select on all catalog,ODBC,ISO Views to public
3.Adding SYSIBM lib to the user global user library list
4. Stop/Start QUSRWRK
5. Using two connection string :
Provider=IBMDASQL.DataSource.1;Password=XXXXX;Persist Security
Info=True;User ID=XXXXX;Data Source=XXXXX
Provider=IBMDA400.DataSource.1;Persist Security Info=False;User ID=XXXX;Data
Source=XXXXX;Password=XXXX
Please Advice
Zahi
You can get much the same info from the PC cmd line by running cwbping
<hostname> /v.
Jon