strange ODBC result
strange ODBC result
I have installed ODBC followed this steps:
https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
yum update
yum remove unixODBC #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql mssql-tools
yum install unixODBC-devel
I have a query with 1000 bindValue in where clause.
When I connect to MS Sql 10 all's right, when I connect ti MS SQL 13 I haven't error but the fetchall don't result nothig, zero rows.
Why?
thanks
https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
yum update
yum remove unixODBC #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql mssql-tools
yum install unixODBC-devel
I have a query with 1000 bindValue in where clause.
When I connect to MS Sql 10 all's right, when I connect ti MS SQL 13 I haven't error but the fetchall don't result nothig, zero rows.
Why?
thanks
Re: strange ODBC result
And if you use the packages that we already provide? Does it work then?
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Re: strange ODBC result
isn't this the package?
if not, how do I install it?
thanks
if not, how do I install it?
thanks
Re: strange ODBC result
No, those are not our packages, they are ones provided by Microsoft so we have no idea what they are or anything about them. The distro already provides packages like unixODBC in the base and updates repo so you do not need the Microsoft repo for this. You will also need the freetds packages from the EPEL repo so if that isn't installed already, use yum --enablerepo=extras install epel-release first.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke
Re: strange ODBC result
thanks, but I found 1000 link for this, can you to do the last effort and give me, please, the steps in order to install unixODBC/freetds from source PHP package?
thanks a lot
thanks a lot
Re: strange ODBC result
You can read
https://blog.remirepo.net/post/2016/09/ ... r-from-PHP
I run all my test using unixODBC from base repository (microsoft version is needed on CentOS 6)
https://blog.remirepo.net/post/2016/09/ ... r-from-PHP
I run all my test using unixODBC from base repository (microsoft version is needed on CentOS 6)
Re: strange ODBC result
thanks, it's what I wanted.
bye
bye