
Anonymous
Not applicable
2012-03-08
04:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
350 Views
7 Replies

Anonymous
Not applicable
2012-03-08
08:44 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Because you forgot to type a database name in tMysqlOutput.
Regards,
Pedro
Because you forgot to type a database name in tMysqlOutput.
Regards,
Pedro
350 Views

Anonymous
Not applicable
2015-02-19
06:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
350 Views

Anonymous
Not applicable
2015-02-19
08:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
are you able to connect Ms Access db using metadata? try to create Metadata first then use same object in job.
350 Views

Anonymous
Not applicable
2015-02-20
11:48 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ya i tried.Finally I got Result.Thank u.
350 Views

Anonymous
Not applicable
2015-02-20
12:23 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
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..
350 Views

Anonymous
Not applicable
2015-03-13
02:47 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
350 Views

Anonymous
Not applicable
2015-08-05
03:31 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Note: I have set the same schema in Component List option. So this is not the case that the database is not selected.
350 Views
