nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Bende <bbe...@gmail.com>
Subject Re: Unable to connect Nifi to SQL Server
Date Tue, 08 Mar 2016 21:11:24 GMT
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-ym@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message