search

ercananlama / JQSQL

library for simple and efficient query features of JSON in MS SQL Server
MIT License
16 stars 5 forks source link

Cannot install the library #4

Open eelziere opened 8 years ago

eelziere commented 8 years ago

Hi,

I am using an SQL Server 2012 Enterprise server.

I choosed a manual installation.

I customized the install.sql file as explained in its header. The path to my JQSQL.dll file on my server is as follow: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\JQSQL.dll

When I run the script from a query window in my SQL Server Management Studio, I get the following error message:

Enable clr Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install. Generate assembly Msg 10301, Level 16, State 1, Line 39 Assembly 'JQSQL' references assembly 'simplejson, version=0.0.0.0, culture=neutral, publickeytoken=null.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. Create schema

I double checked: the JQSQL.dll file is located on the server as mentioned in the install.sql script.

Why is the message error talking about a simplejson assembly while the SQL script is dealing with a jqsql one?

Any clue?

Thank you for your help.

Regards, Eric.

eelziere commented 8 years ago

Hi again, I made progress: I found out that the JQDotNet.dll and SimpleJson.dll libraries had to be published with the JQSQL.dll one.

But now when I run the install.sql script, I get the folowing error message:

Enable clr Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install. Generate assembly Create schema Create value function Msg 6528, Level 16, State 1, Procedure getvalue, Line 53 Assembly 'JQSQL' was not found in the SQL catalog of database 'ArcaniaDB'.

Thank you for you help. Eric.