Is it possible to use MS-SQL in Fedora?

asked 2018-12-05 18:42:43 -0600

updated 2018-12-05 19:01:37 -0600

Sorry for my vague question, it is due to my shallow knowledge. Basically in my company we have an MS-SQL server deployed and after providing with the correct username and password, I can ask query there using Python with pyodbc, read SQL scripts and retrieve the data I want.

Now I'm wondering if I can do the same thing in Fedora. It seems like MS-SQL supports RHEL but not Fedora, but I think there should be a method. I heard this thing about Docker and what not, but I'm not sure what is the most easiest method to connect to the MS-SQL server in Fedora. I do have a separate Windows machine just in case so if it is not a good idea to use Linux than I have to fall back to Windows...

Also what is your opinion about MS-SQL for developers? Should I suggest to the higher-ups that maybe next time we have to use MariaDB or PostgreSQL or something? This is a small startup and we don't even have a database administrator...

Thanks in advance.

answered 2018-12-05 20:51:57 -0600

ed209
1098 ●183 ●20

Here you will find some hints for your questions https://computingforgeeks.com/how-to-...

Good luck.

edit flag offensive delete link

Comments

Thanks. I did try the method but it gives me the error messages similar to 'nothing provides openssl < 1:1.1.0 needed by mssql-server-14.0.1000.169-2.x86_64' when attempting the installation. I have openssl-1:1.1.1-3 installed, so do I have to download an older version as well? I'm not sure what is the best method in this situation.

incantator ( 2018-12-06 22:32:06 -0600 )edit

The link I gave you shows version 15, not 14. Are you sure you followed the instructions therein correctly? If not, erase your old version and try again.

ed209 ( 2018-12-07 12:54:15 -0600 )edit

@ed209 Thanks, I almost installed it but it throws a python traceback when configuring:

[---@localhost opt]$ sudo /opt/mssql/bin/mssql-conf setup
Traceback (most recent call last):
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 15, in <module>
    import mssqlconfhelper
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 174
    print _("Setting language using LCID from environment variable %s") % mssqlLcidEnvVariable
          ^
SyntaxError: invalid syntax

It looks like a python2 syntax. Should I redirect my python symlink to python2?

incantator ( 2018-12-10 22:32:45 -0600 )edit

I would contact the guy that wrote that page I sent you for further details.

ed209 ( 2018-12-14 18:56:43 -0600 )edit

add a comment

Is it possible to use MS-SQL in Fedora?

1 Answer

Comments

Question Tools

Stats

Related questions

Is it possible to use MS-SQL in Fedora? edit

1 Answer

Comments

Question Tools

Stats

Related questions

Is it possible to use MS-SQL in Fedora?