Thanks, your post was very useful for me. I was able to get it to work by eliminating the following lines from my odbcinst.ini file
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
FileUsage = 1
CPTimeout =
CPResuse =
client charset = utf-8
so now my odbcinst.ini file looks like this:
--- /etc/odbcinst.ini ---
[FreeTDS]
Description = FreeTDS
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
and my odbc.ini file looks like this now:
--- /etc/odbc.ini ---
[TS]
Description = "test"
Driver = FreeTDS
Server = SERVER
Port = 1433
Database = DBNAME
Once I simplified everything it worked great. I still can't get it to work with RODBC but it worked with isql.
I don't know if this will help but your post helped me. Thanks.
You are using the default nouveau driver, for your nvidia graphics card. This is a reverse engineered driver and is known to cause trouble with power management.
From what I can tell from my experience suspend with nouveau is gambling, depends very much on the kernel version, graphics card etc.
The first thing I would try if I were you is installing the official nvidia driver: Note, though, it is proprietary, but I would try to see if it resolves your problem, because then we know pretty much for sure nouveau is the component to blame. (Looking at all the errors on your screen I am pretty sure though nouveau is the trouble maker.)
If you have concern because the proprietary driver is closed source, you can set up a second ubuntu install on an external hdd/usb and try it there.
To try the proprietary nvidia driver do the following:
sudo apt-get install nvidia-current-updates
and reboot your machine after the process finished.
Please report back if that changes something for you.
If not, my second try would be disconnecting all external hardware (usb devices like scanners, printers etc.), to make sure nothing external triggers a wakeup.
EDIT: Please also paste the output of
lspci
since the error message on your screen says "Device 0000:01:00.0 failed to suspend" and that command helps us to find what device exactly that is, but I suppose your graphics card.
Added by questioner:
For all who have similar Problem with a Nvidia Card in a laptop, If you have further trouble (eg. if your OpenGL Version is still low, or your laptop needs a lot of energy), check if your card uses OPTIMUS technology. This means that you have an additional graphics card, which is used for not graphical expensive Applications. In contrast this second card is optimized for low energy usage. You can search on the in the optimus scetion on the Nvidia Site for your card. If found your card there install also bumblebee
and bumblebee-nvidia
. After that, to run a Application with your powerful graphics card you have to run your Application via
$ optirun <path to app>
Best Answer
According to this link: http://www.unixodbc.org/doc/FreeTDS.html, it might be:
Another possibility is:
This is for 64-bits architecture.
Once you found the right place, update the
/etc/odbcinst.ini
to reflect the changes.