accessing AS400 Database VB.net with Oledb

[dotNET User Group Hyd]

New Message on dotNET User Group Hyd accessing AS400 Database VB.net with Oledb Reply   Recommend Message 1 in Discussion From: s_hashim When i am accessing AS400 Database using SQL "Select * from Lib.Tablename" I am getting the following error VB.net with Oledb   please let me know about this Message "SQL5016: Qualified object name ORGANIZ not valid. Cause . . . . . :   One of the following has occurred: -- The syntax used for the qualified object name is not valid for the naming option specified.  With system naming, the qualified form of an object name is collection-name/object-name.  With SQL naming the qualified form of an object name is authorization-name.object-name. -- The syntax used for the qualified object name is not allowed. User-defined types cannot be qualified with the library in the system naming convention on parameters and SQL variables of an SQL procedure or function. Recovery  . . . :   Do one of the following and try the request again: -- If you want to use the SQL naming convention, verify the SQL naming option in the appropriate SQL command and qualify the object names in the form authorization-id.object-name. -- If you want to use the system naming convention, specify the system naming option in the appropriate SQL command and qualify the object names in the form collection-name/object-name. -- With the system naming convention, ensure the user-defined types specified for parameters and variables in an SQL routine can be found in the current path. CWBDB0036 - Server returned SQL error CWBDB0036 - Server returned SQL error " String View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.