Home / user-641388

niknoe's questions

Martin Hope
niknoe
Asked: 2019-10-23 23:07:36 +0800 CST
  • 5

I am attempting to use pyodbc to connect to a MSSQL database in python. I have installed the MS drivers following the instructions here using the 19.04 version. When attempting to install pyodbc via pip i get sql.h: No such file or directory. Googling tells me I need to install unixodbc and unixodbc-dev, however when I try to do just that I get the following message:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 unixodbc : Depends: odbcinst1debian2 (>= 2.3.7) but it is not going to be installed
            Depends: libodbc1 (>= 2.3.7) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

Running apt autoclean, apt install -f etc did not do anything.

odbc 19.10
Martin Hope
niknoe
Asked: 2017-01-13 01:08:22 +0800 CST
  • 2

So it's time to ask my first question, something I've been struggling with for a while now. I know there are some questions around the same topic, however, none of them (which I could find) have been of any help.

Before you ask, I want to do some explaining of the core problem.

Why have I not just installed it in UEFI mode?

I was unable to boot the install (or live mode for that matter) in uefi mode. After some time spent searching on google I noticed that several people have had this exact problem: after the menu appears (the uefi one), whatever I do simply results in a black screen.

After reading this article https://help.ubuntu.com/community/UEFI, I though I'd try installing ubuntu in legacy mode, and then use boot-repair to convert my install to uefi.

NOTE: I am dual booting ubutnu alongside Windows 10. Currently I have to enter the bios settings to enable uefi boot in order to enter windows and vice versa.

What I have tried

Boot-repair

I then tried, of course, boot-repair while in a legacy mode session only to get this error message:

The current session is in Legacy mode. Please reboot the computer, and use this software in an EFI session. This will enable this feature. For example, use a live-USB of Boot-Repair-Disk-64bit (www.sourceforge.net/p/boot-repair-cd), after making sure your BIOS is set up to boot USB in EFI mode.

Boot-repair live usb

I tried creating a live usb with boot-repair 64bit only to encounter the same problem as when booting the ubuntu install

Why do I need to boot with UEFI?

Well I don't REALLY need too boot using UEFI, however, my current windows install does, and it would be great to be able to choose whether to boot windows or ubuntu without having to switch between legacy and uefi.

Need any more information?

Is there a way to manually create the /boot partition and do the necessary changes for my system to boot efi?

Other suggestions?

Thanks

EDIT:

While I have tried both on and off, secured boot has been turned off for most of my attempts.

Edit #2: (In response to Rod Smith and comments regarding more info)

  • I have tried rEFInd boot manager, it encounters the very same problem
  • I have tried rufus (Windows) and unetbootin (Ubuntu) for creating the usb media, both of which producing valid media (for other computers at least)
  • I have a friend with (almost) the same computer with the same problem
  • Very few distros work, Arch and Gentoo are among those who do work
  • I have a GTX 1060 card on a Multicom laptop
  • Windows does indeed use GPT and UEFI boot

Many of my assumptions have been made after reading this post right here: My computer boots to a black screen, what options do I have to fix it?

Especially the text right after something describing my problem:

There is no solution for these errors and the workaround is to disable UEFI to enable the Ubuntu installer to run in legacy mode; after which boot-repair can be used to install grub-efi which then allows/needs UEFI switched back on before Ubuntu will boot using UEFI.

I actually assumed I couldn't reach the F6 menu at all, but now I haven't had time to recheck that.

dual-boot