Hi, I have succesfully installed sqoop as when i type sqoop-help i am able to retrieve the list as shown below.But when i try to connect it to sql server and list databases,it gives connection error.ie ERROR sqoop.ConnFactory: Could not load ManagerFactory com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
I have installed the mssql connector and set its path as well.I have also copied the sqljdbc jars in lib . Why this error is coming then Thanks & Regards Prabhjot Here are the results [hduser@master bin]$ sqoop-help Warning: $HADOOP_HOME is deprecated. usage: sqoop COMMAND [ARGS] Available commands: codegen Generate code to interact with database records create-hive-table Import a table definition into Hive eval Evaluate a SQL statement and display the results export Export an HDFS directory to a database table help List available commands import Import a table from a database to HDFS import-all-tables Import tables from a database to HDFS job Work with saved jobs list-databases List available databases on a server list-tables List available tables in a database merge Merge results of incremental imports metastore Run a standalone Sqoop metastore version Display version information See 'sqoop help COMMAND' for information on a specific command. [hduser@master bin]$ sqoop list-databases --driver com.microsoft.jdbc.sqlserver.SQLServerDriver --connect 'jdbc:sqlserver://IPADDRESS;username=dvp;password=dvp' Warning: $HADOOP_HOME is deprecated. 12/07/23 19:05:16 ERROR sqoop.ConnFactory: Could not load ManagerFactory com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found) 12/07/23 19:05:16 INFO manager.SqlManager: Using default fetchSize of 1000 12/07/23 19:05:16 ERROR manager.SqlManager: Generic SqlManager.listDatabases() not implemented. Could not retrieve database list from server 12/07/23 19:05:16 ERROR tool.ListDatabasesTool: manager.listDatabases() returned null
