Hi Steve, I do not do too much in the Windows environment.
I know of some customers are using the Windows ODBC support in Excel via DB2/Connect to get access to DB2/VSE&VM database servers. DB2/VSE&VM provides a set of CLI Stored Procedures to support ODBC. It works not too badly.
If you are getting various user id errors when you are trying to access table data then you may want to look at what the user ID your Windows application is passing. Once you have connected to your DB2/VM database from Windows, issue a SHOW CONNECT to find out the SQLID your Windows user is using. Tha may give you a clue. Make sure the SQLID is authorized to access the target table.
Sorry, can't provide much help.
Regards,
...Roland
Steve_Domarski/[EMAIL PROTECTED] wrote:
Steve_Domarski/[EMAIL PROTECTED] wrote:
Roland, While I got your attention. Do you know of a ODBC driver or ADO.NET
package that will communicate with VM/DB2 from a Windows .NET application.
I've been to Direct Connect and can connect to VM but I get various user id
errors when I try to access table data.
Steve Domarski 352-368-8350
Property Appraisers Office Marion County Florida USA
With best regards,
...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)
197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6
** Life is short. Stop once in a while and smell the roses. **
