strange ODBC result

General support questions
Post Reply
oscaroxy
Posts: 33
Joined: 2014/02/05 20:18:54

strange ODBC result

Post by oscaroxy » 2018/11/13 17:06:11

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

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: strange ODBC result

Post by TrevorH » 2018/11/13 17:49:55

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

oscaroxy
Posts: 33
Joined: 2014/02/05 20:18:54

Re: strange ODBC result

Post by oscaroxy » 2018/11/13 18:33:03

isn't this the package?
if not, how do I install it?
thanks

tunk
Posts: 1205
Joined: 2017/02/22 15:08:17

Re: strange ODBC result

Post by tunk » 2018/11/13 18:46:43

deleted

oscaroxy
Posts: 33
Joined: 2014/02/05 20:18:54

Re: strange ODBC result

Post by oscaroxy » 2018/11/13 18:48:57


User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: strange ODBC result

Post by TrevorH » 2018/11/13 21:25:32

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

oscaroxy
Posts: 33
Joined: 2014/02/05 20:18:54

Re: strange ODBC result

Post by oscaroxy » 2018/11/14 08:03:45

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

User avatar
remirepo
Posts: 447
Joined: 2014/09/21 09:07:12
Location: France
Contact:

Re: strange ODBC result

Post by remirepo » 2018/11/14 14:17:40

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)
Remi's Repository - Forum - Blog

oscaroxy
Posts: 33
Joined: 2014/02/05 20:18:54

Re: strange ODBC result

Post by oscaroxy » 2018/11/14 15:45:03

thanks, it's what I wanted.
bye

Post Reply