Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Script Giving "No database selected" error when run

I have successfully built one script using Talend which pulls data from an Excel file into a MySQL DB. I am looking to perform the same task, but with a new XLS and MySQL table. I have followed the same steps and have retrieved schema for both object types, but when I run the script, I am getting a "No database selected" error. The run calculates 600+ lines, but they do not insert into the DB. Any help is greatly appreciated.
Labels (2)
7 Replies
Anonymous
Not applicable
Author

Hi
Because you forgot to type a database name in tMysqlOutput.
Regards,
Pedro
Anonymous
Not applicable
Author

Hello Mam/Sir,
                     I am Trying to Connect My Access Data to MySql. But Receiving the Error as "No DataBase Selected" inspite of i have choosen proper DataBase also.Please If u Know Help Me Regarding with this.Thank You. 
Anonymous
Not applicable
Author

are you able to connect Ms Access db using metadata? try to create Metadata first then use same object in job. 
Anonymous
Not applicable
Author

Ya i tried.Finally I got Result.Thank u.
Anonymous
Not applicable
Author

Hi I have a data Base as Follows.
Employee    |      Employee ID       |      Email                    |      Position   |
__________________________________________________________
Steve         |   CS42                    |  steve12@gmail.com     | Manager      |
Steve         |   CS42                    |  steve12@gmail.com     | System Analyst      |
John           |   CS43                    | john42@gmail.com        |  Project Coordinator |
John           |   CS43                    | john42@gmail.com        |  Project Coordinator |
Steve         |   CS42                    |  steve12@gmail.com     | Manager      |
I want to Eliminate Duplicate Values and as well for the "Steve" both positions to be displayed in my database.It would be very helpful if anybody guide me.Thank You..
Anonymous
Not applicable
Author

Hi,
I Have Huge Number Records Of MS Access Data Base.And I want Only 10000 records to be Displayed.In That Records we Have 2 Column Named "First Name" And "Last Name".And i Want To apply the condition that only 10000 records of "First Name" and "Full Name" to be displayed in Upper Case.Please Can Any One Help Me Regarding with this.How Shall we Apply Query in Ms Access Query Box.Thank You. 
Anonymous
Not applicable
Author

I am also getting same error, but the scenario is different. I have multiple schemas, when use one schema with tMySqlConnection, and uses its one table as input, the job design could not recognize the schema as database. This error appears at input component properties, when I click at getSchema it shows No Database selected. 
Note: I have set the same schema in Component List option. So this is not the case that the database is not selected.