Hi,
I'm creating datasets with dotConnect for Oracle with the dataset wizard. The dataset wizard generates commands with the Oracle schema name included. This is annoying because the schema name in my develop, test en product environments differ. Now I have to manually change the commands.
It would be nice to have a checkbox in the dataset wizard, which determines wether schema names are generated in the command.
Regards,
Matthieu de Graaf
Schema name in commands of dataset
schema name in command
I have a similar problem. When executing a query against Oracle I find that I must prefix the table name with the schema name. Is there a way to identify the schema in the connection string?
"user id=mike;pwd=wouldntyouliketoknow;data source=10.10.2.110;direct=True;sid=ORCL;port=1521;connect timeout=15;Persist Security Info=False;"
"user id=mike;pwd=wouldntyouliketoknow;data source=10.10.2.110;direct=True;sid=ORCL;port=1521;connect timeout=15;Persist Security Info=False;"
Re: Schema name in commands of dataset
You can avoid generating schema prefix with Devart DataSet Wizard in the following way:
Tools > Oracle > DataSet Wizard > ... go through the wizard till the "Setup individual data tables" step:
1. Select a particular table in the "Data tables" window and press the "Configure commands" button
2. Remove schema prefix in Select Text
3. Open "Command Generator" tab, clear the "Use schema name" checkbox, press "Generate Commands" > OK
Repeat steps 1,2,3 for all tables.
Tools > Oracle > DataSet Wizard > ... go through the wizard till the "Setup individual data tables" step:
1. Select a particular table in the "Data tables" window and press the "Configure commands" button
2. Remove schema prefix in Select Text
3. Open "Command Generator" tab, clear the "Use schema name" checkbox, press "Generate Commands" > OK
Repeat steps 1,2,3 for all tables.