Forum Discussion
vbace2
14 years agoOccasional Contributor
Ok, I have switched to the IBM OLE DB Provider for DB2. I'm not sure why I didn't select that in the first place. I guess I missed it. Anyway, even with the IBM OLE DB Provider for DB2 I am still having issues. I am basically having the same issues that I was when using the Microsoft OLE DB Provider for ODBC Drivers. However, I do have an update...
Originally, I said I could only create a DB Table store if I selected Custom Query and typed out my query. It is still true that if I want to create a custom query that I need to type out my query. I can type it out in the "Enter SQL Query" window, or I can click the Design button and type it out in the SQL tab of the SQL Designer. I can't use the SQL Designer and select the tables or views from the list. The tables and views do not have the schema associated with them.
Originally, I didn't think I could select the data source types of Table or View, that I had to select Custom query. However, I can use the view and table options. After I select which view or table I want from the dropdown list, I just need to add my schema name and a period in front of the table name. That seems to work just fine.
However, I still can't figure out the project variables. When it comes time to select the table name, I am just given a scrollable list where I can just select a table. Since the schema name is not in front of the table, I don't think it can find the table. Also, unlike the DB Table stores, I can't type the schema name in front of the table name.
Any ideas?
Originally, I said I could only create a DB Table store if I selected Custom Query and typed out my query. It is still true that if I want to create a custom query that I need to type out my query. I can type it out in the "Enter SQL Query" window, or I can click the Design button and type it out in the SQL tab of the SQL Designer. I can't use the SQL Designer and select the tables or views from the list. The tables and views do not have the schema associated with them.
Originally, I didn't think I could select the data source types of Table or View, that I had to select Custom query. However, I can use the view and table options. After I select which view or table I want from the dropdown list, I just need to add my schema name and a period in front of the table name. That seems to work just fine.
However, I still can't figure out the project variables. When it comes time to select the table name, I am just given a scrollable list where I can just select a table. Since the schema name is not in front of the table, I don't think it can find the table. Also, unlike the DB Table stores, I can't type the schema name in front of the table name.
Any ideas?
Related Content
- 9 months agoLuukdb
- 4 years agoDavid91
- 5 years agoKrishna_Kumar
Recent Discussions
- 10 hours agoSvetaG