Hello, If you are specifying the URI for the driver jar, then you would generally put it outside of NiFi lib directory, somewhere else.
The URI also needs the file:/// prefix, so for windows I think it would be: file:///D:/some/path/to/driver/sqljdbc4.jar Let us know if that works. -Bryan On Tue, Mar 8, 2016 at 3:16 PM, Ashraf Mohammed <ashraf...@ihfinfotech.com> wrote: > Hi dev@Nifi, > > I am trying to connect Nifi to source SQL Server database. I keep getting > the error " Cant load database driver" > > My settings are as follows: > > > Database Driver Class NameInfo > com.microsoft.sqlserver.jdbc.SQLServerDriver > > Database Driver Jar UrlInfo > D:\nifi\nifi-0.5.1-bin\nifi-0.5.1\lib\sqljdbc4.jar > > Also note: I downloaded, the SQLJDBC4.jar file from the Microsoft site, I > unzipped the files, retrieved the jar file and moved it under the nifi lib > folder/ > > Any advice in fixing this issue please ? > -- > Regards, > Ashraf Y Mohammed >
