Jump to content

Víctor M.

Members
  • Posts

    3
  • Joined

  • Last visited

LabVIEW Information

  • Version
    LabVIEW 2009
  • Since
    2010

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Víctor M.'s Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. First of all thank you again for your quick response. And sorry for the delay, but I was out and I could not check it until today. I took some time to try to use the same bitness in all DLLs and LabVIEW as you suggested but it did not worked. I had the same error in all the trials I did. Moreover, I was surprised because I repeated the same experiment than the explained in my previous post with the two extension functions DLLs (extension-functions.dll and extension-functions_64.dll, which I suppose that are the files for 32 and 64 files respectively) and I get no errors when trying to load any of these files. These are the sentences employed: SELECT load_extension('D:\Program Files (x86)\National Instruments\LabVIEW 2019\vi.lib\drjdpowell\SQLite Library\SQL Connection\extension-functions.dll'); SELECT load_extension('D:\Program Files (x86)\National Instruments\LabVIEW 2019\vi.lib\drjdpowell\SQLite Library\SQL Connection\extension-functions_64.dll'); For these reasons I think there is another problem that is not allowing me to load the SpatiaLite DLL files. Thank you in advance for your help! Víctor
  2. Thank you for your quick response. I follow your instructions and I did several experiments but I cannot get my problem solved. These are the experiments performed: First experiment: loading "mod_spatialite.dll": I wrote this line in the sqlite3 command-line tool: SELECT load_extension('mod_spatialite.dll'); As a result of this sentence I did not get any error message. It is interesting to note that the file "mod_spatialite.dll" was in the same folder than "sqlite3.exe". Nevertheless, I could not do that in LabVIEW, also after copying the DLL file in the same folder than the VI file. Second experiment: loading "mod_spatialite.dll" with its absolute path: I wrote this line in the sqlite3 command-line tool: SELECT load_extension('D:\Program Files (x86)\National Instruments\LabVIEW 2019\VMM.lib\mod_spatialite-4.3.0a-win-amd64\mod_spatialite.dll'); As a result of this sentence I get this error message: "Error: No se puede encontrar el módulo especificado" (in English it can be translated as "Cannot find the specified module"). It is insteresting to note that "'D:\Program Files (x86)\National Instruments\LabVIEW 2019\VMM.lib\mod_spatialite-4.3.0a-win-amd64\" is the absolute path of the location of the "mod_spatialite.dll" file. Third experiment: loading "extension-functions.dll" with its absolute path: I wrote this line in the sqlite3 command-line tool: SELECT load_extension('D:\Program Files (x86)\National Instruments\LabVIEW 2019\vi.lib\drjdpowell\SQLite Library\SQL Connection\extension-functions.dll'); As a result of this sentence I get the same error message: "Error: No se puede encontrar el módulo especificado". It is insteresting to note that: "'D:\Program Files (x86)\National Instruments\LabVIEW 2019\vi.lib\drjdpowell\SQLite Library\SQL Connection\" is the absolute path of the location of the "extension_functions.dll" file. This sentence worked properly in the LabVIEW code shown in my previous post when selecting this path in the "dll File Path" control. Fourth experiment: loading "extension-functions.dll" without its absolute path: The last experiment consisted on trying to do not get an error message by repeating the procedure employed in the first experiment. To do so, I moved the "extension-functions.dll" file to the same folder than the "mod_spatialite.dll" and the "slqite3.exe" files. After that, I wrote this line in the sqlite3 command-line tool: SELECT load_extension('extension_functions.dll'); As a result of this sentence I get again the same error message: "Error: No se puede encontrar el módulo especificado". To sum up, the description of the error obtained is "Error: No se puede encontrar el módulo especificado" (in English it can be translated as "Cannot find the specified module"). Moreover, in the first experiment I was able to load the "mod_spatialite.dll" file without error, but it did not worked in LabVIEW. Finally, in the fourth experiment I get an error message even with a sentence that worked in LabVIEW. Thank you in advance for your help! Víctor
  3. Hello, I am working with LabVIEW and SQLite and I am using the SQLite library created by drjdpowell. Moreover, I need to use SPATIALite as SDietrich used in the previous quoted post. To do so I am following the instructions of this Spatialite page and I am trying to include the file "mod_spatialite.dll" (SDietrich loaded "lib-spatialite-2.dll" but as this post is old I consider that now I should follow the instructions of the Spatialite web page). My question is, how can I load it? I tried to do that with the VI shown in the next image: where "BBDD Path" is the link to my SQLite database and "dll file Path" the link to the "mod_spatialite.dll" file. When I execute this VI I get the 402860 error after executing "Execute SQL.vi", and I also get the message "SQLite returned SQLITE_ERROR(1), see www.sqlite.org/rescode.html#error" in the error source string, but it does not give information about the error. My VI is based on the "Load Extended Math Functions.vi" of the SQLite library created by drjdpowell, and it works when I try to load the file "extension-functions.dll" (which is the file loaded by "Load Extended Math Functions.vi") instead of the "mod_spatialite.dll" file. In case that it helps, I am using LabVIEW 2019 and the version of SQLite and Spatialite shown in the next image: Can anyone help me to solve this problem? Thank you in advance! Víctor
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.