Retrieve Data from SQL database [message #599] |
Mon, 15 July 2019 16:27 ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
alienke
Messages: 8 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 Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
thomas
Messages: 693 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
|
|
|
|
|