openmolecules.org

 
Home » DataWarrior » Functionality » Retrieve Data from SQL database (How to access MS SQL Server)
Retrieve Data from SQL database [message #599] Mon, 15 July 2019 16:27 Go to next message
alienke is currently offline  alienke
Messages: 1
Registered: July 2019
Junior Member
Hi Thomas,

first and foremost: compliments for including a SQL interface. Connection with MySQL works perfect. How can I access MS SQL Server. I tried various connection strings and always get the same error message.

Do I need special drivers?
Do I need to use a sideway?

Best wishes

Achim
Re: Retrieve Data from SQL database [message #600 is a reply to message #599] Tue, 23 July 2019 17:13 Go to previous message
thomas is currently offline  thomas
Messages: 219
Registered: June 2014
Senior Member
Hi Achim,

the current and official DataWarrior 5.0.0 does not support SQL-Server nor PostgreSQL.
However, I have built support for both database engines into the current development
version, which you may download as zip-file containing 4 files, which you need to replace
in the official installation. The links are for Windows: openmolecules.org/datawarrior/dw500win.zip
and for Linux/Mac: openmolecules.org/datawarrior/dw500x.zip

Since I don't have access to a SQL-Server not a PostgreSQL database, I could not test it
and would be grateful, if anybody you would let me know, whether it works.

There are some other bug fixes and new functionality coming with that version, e.g. the generation
of random molecules or predicting missing values from chemical structures using machine learning approaches. This functionality is not described in the manual, but is rather straight forward.

Enjoy, Thomas

[Updated on: Wed, 24 July 2019 21:23]

Report message to a moderator

Previous Topic: export jpg/png file from SDF file with datawarrior from command line
Next Topic: Calculation of mean/median values in box &whisker plots.
Goto Forum:
  


Current Time: Mon Aug 19 22:39:00 CEST 2019

Total time taken to generate the page: 0.00257 seconds