The below config file works fine with sql server. Make sure you are using the correct database / server name.
<dataConfig> <dataSource type="JdbcDataSource" driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://myserver;databaseName=mydb;responseBuffering=adaptive;selectMethod=cursor" user="sa" password="password"/> <document> <entity name="results" query="SELECT statements"> <field column="fielda" name="fielda"/> <field column="fieldb" name="fieldb"/> <field column="fieldc" name="fieldc"/> </entity> </document> </dataConfig> -- View this message in context: http://lucene.472066.n3.nabble.com/Configuring-Solr-to-connect-to-a-SQL-server-instance-tp4070005p4070010.html Sent from the Solr - User mailing list archive at Nabble.com.