[Flask] Connecting to 2 servers

[Larry Martell]

On Mon, Aug 12, 2019 at 4:33 PM Adil Hasan <paradox2005 at gmail.com> wrote:
>
> Hello,
>
> oh.
>
> Perhaps this may help:
> https://stackoverflow.com/questions/34785653/pyodbc-cant-open-the-driver-even-if-it-exists

Tried solutions mentioned in that post, no joy.

> Perhaps there are some other libraries missing. If you try to run ldd
> against the library it will indicate what is missing?

# ldd /usr/local/lib/libmsodbcsql.17.dylib
not a dynamic executable

>
> hth
> adil
>
> On Mon, Aug 12, 2019 at 03:53:28PM -0400, Larry Martell wrote:
> > On Mon, Aug 12, 2019 at 3:00 PM Adil Hasan <paradox2005 at gmail.com> wrote:
> > >
> > > Hello,
> > > Perhaps you could try to set the LD_LIBRARY_FLAG environmental variable.
> > > You may already have it set, so you just need to append the path at the
> > > end. If you're using bash:
> > >
> > > export LD_LIBRARY_PATH=/usr/local/lib:${LD_LIBRARY_PATH}
> > >
> > > That I think should allow the application to find the library path.
> >
> > That also did not work.
> >
> >
> > > On Mon, Aug 12, 2019 at 02:13:36PM -0400, Dennis Lee Bieber wrote:
> > > > On Mon, 12 Aug 2019 13:18:24 -0400, Larry Martell
> > > > <larry.martell at gmail.com> declaimed the
> > > > following:
> > > >
> > > > >
> > > > >I changed it to use the 'pass-through-exact-pyodbc-string' but got the
> > > > >same error. Then I thought maybe the driver is not installed. So I
> > > > >followed the instructions here:
> > > > >
> > > > >https://medium.com/@liamfirth/installing-mssql-odbc-driver-17-1-0-1-on-amazon-web-services-linux-9a8febccfe94
> > > > >
> > > > >and installed it and changed my driver string to ODBC Driver 17 for
> > > > >SQL Server and now I get:
> > > > >
> > > > >Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found
> > > > >
> > > > >but it is there:
> > > > >
> > > > ># ls -l /usr/local/lib/libmsodbcsql.17.dylib
> > > > >-r--r--r-- 1 root root 2539360 Aug 12 17:06 /usr/local/lib/libmsodbcsql.17.dylib
> > > >
> > > >       We're past my level of expertise (in truth, Google was the source for
> > > > everything in my previous post). Best I can come up with might be related
> > > > to
> > > >
> > > > https://linux.die.net/man/8/ldconfig
> > > >
> > > > Does
> > > >       ldconfig -p
> > > > list the file? If not... is /usr/local/lib somewhere in /etc/ld.so.conf (or
> > > > any subfiles referenced)? The Debian on Windows seems to have it
> > > > included...
> > > >
> > > > wulfraed at ElusiveUnicorn:~$ cat /etc/ld.so.conf
> > > > include /etc/ld.so.conf.d/*.conf
> > > >
> > > > wulfraed at ElusiveUnicorn:~$ ls /etc/ld.so.conf.d/
> > > > libc.conf  x86_64-linux-gnu.conf
> > > > wulfraed at ElusiveUnicorn:~$ cat /etc/ld.so.conf.d/*.conf
> > > > # libc default configuration
> > > > /usr/local/lib
> > > > # Multiarch support
> > > > /lib/x86_64-linux-gnu
> > > > /usr/lib/x86_64-linux-gnu
> > > > wulfraed at ElusiveUnicorn:~$
> > > >
> > > >       Even with it (the directory) there, you may need to rebuild cache by
> > > > running ldconfig
> > > >
> > > >
> > > > --
> > > >       Wulfraed                 Dennis Lee Bieber         AF6VN
> > > >       wlfraed at ix.netcom.com    http://wlfraed.microdiversity.freeddns.org/
> > > >
> > > > _______________________________________________
> > > > Flask mailing list
> > > > Flask at python.org
> > > > https://mail.python.org/mailman/listinfo/flask
> > > _______________________________________________
> > > Flask mailing list
> > > Flask at python.org
> > > https://mail.python.org/mailman/listinfo/flask