
Originally Posted by
Pffi
nope, I did nothing wrong, my version of centos is obviously bugged, otherwise it wouldn't work for other versions (such as ubuntu etc.) even a friend looked into it via remoute control (his job is working with linux) and he couldn't figure out what's wrong 'coz it simply blocks everything lol even tho everythings right setuped.
downloading version 4,7 now.
4.7 Will work just fine.
----------------------------------------------------------------------------------------------------------------------------------
By the way, i am using CentOS 4.7 on a Dedicated Machine, and Windows with MSSQL on a different one. I changed the port 1433 to 1444(MSSQL) due to some security reasons. I can connect just fine from home to other databases that i host there. But i have the next problem, and it may be the reason for why i see login screen, can write login and password and press connect but it just load load, and says that failed to connect. If you have any ideas on how to solve it please post here. Thanks in advance.
EDIT:
I also changed the default port to the current one (1444) in odbc.ini
EDIT2:
Chumpy's GM Tools also connect just perfect from home to cabal db.
Code:
[Thu Nov 6 2008 17:53:18.390608 4127603616]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Nov 6 2008 17:53:18.390672 4127603616]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Nov 6 2008 17:53:18.390690 4127603616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Nov 6 2008 17:53:18.390707 4127603616]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Nov 6 2008 17:53:18.390723 4127603616]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Nov 6 2008 17:53:18.390739 4127603616]: [##ERROR##] Database Connect Fail (uid=sa;pwd=SQLPASSWORD;dsn=CabalGame01;APP=DBAgent_01)
[Thu Nov 6 2008 17:53:18.390772 4127603616]: [##ERROR##] check 'pDB' fail
[Thu Nov 6 2008 17:53:18.390789 4127603616]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Nov 6 2008 17:53:18.390809 4127603616]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Nov 6 2008 17:56:27.366090 4127603616]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Nov 6 2008 17:56:27.366154 4127603616]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Nov 6 2008 17:56:27.366172 4127603616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Nov 6 2008 17:56:27.366189 4127603616]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Nov 6 2008 17:56:27.366205 4127603616]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Nov 6 2008 17:56:27.366221 4127603616]: [##ERROR##] Database Connect Fail (uid=sa;pwd=SQLPASSWORD;dsn=CabalGame01;APP=DBAgent_01)
[Thu Nov 6 2008 17:56:27.366240 4127603616]: [##ERROR##] check 'pDB' fail
[Thu Nov 6 2008 17:56:27.366256 4127603616]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Nov 6 2008 17:56:27.366276 4127603616]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Nov 6 2008 17:59:36.341766 4127603616]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Nov 6 2008 17:59:36.341830 4127603616]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Nov 6 2008 17:59:36.341857 4127603616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Nov 6 2008 17:59:36.341873 4127603616]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Nov 6 2008 17:59:36.341889 4127603616]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Nov 6 2008 17:59:36.341905 4127603616]: [##ERROR##] Database Connect Fail (uid=sa;pwd=SQLPASSWORD;dsn=CabalGame01;APP=DBAgent_01)
[Thu Nov 6 2008 17:59:36.341924 4127603616]: [##ERROR##] check 'pDB' fail
[Thu Nov 6 2008 17:59:36.341940 4127603616]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Nov 6 2008 17:59:36.341960 4127603616]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Nov 6 2008 18:02:45.317443 4127603616]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Nov 6 2008 18:02:45.317509 4127603616]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Nov 6 2008 18:02:45.317527 4127603616]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Nov 6 2008 18:02:45.317544 4127603616]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Nov 6 2008 18:02:45.317560 4127603616]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Nov 6 2008 18:02:45.317576 4127603616]: [##ERROR##] Database Connect Fail (uid=sa;pwd=SQLPASSWORD;dsn=CabalGame01;APP=DBAgent_01)
[Thu Nov 6 2008 18:02:45.317595 4127603616]: [##ERROR##] check 'pDB' fail
[Thu Nov 6 2008 18:02:45.317610 4127603616]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Nov 6 2008 18:02:45.317630 4127603616]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
I already did yum for the FreeTDS, libssl and odbc and all seems to be ok
Code:
[root@centos64bit ~]# yum install freetds* Setting up Install Process Setting up repositories Reading repository metadata in from local files Parsing package install arguments Examining freetds-unixodbc-0.64RC3-1.i386.rpm: freetds-unixodbc - 0.64RC3-1.i386 freetds-unixodbc-0.64RC3-1.i386.rpm: does not update installed package. Nothing to do
-----------------------------------------------------------------
[root@centos64bit ~]# yum install libssl* Setting up Install Process Setting up repositories Reading repository metadata in from local files Parsing package install arguments No Match for argument: libssl* Nothing to do
-----------------------------------------------------------------
[root@centos64bit ~]# yum install unixODBC*
Setting up Install Process
Setting up repositories
update 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
addons 100% |=========================| 951 B 00:00
extras 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
primary.xml.gz 100% |=========================| 52 kB 00:00
update : ################################################## 195/195
primary.xml.gz 100% |=========================| 560 kB 00:00
base : ################################################## 1831/1831
primary.xml.gz 100% |=========================| 192 B 00:00
primary.xml.gz 100% |=========================| 36 kB 00:00
extras : ################################################## 155/155
Parsing package install arguments
Examining unixODBC-2.2.11-1.RHEL4.1.i386.rpm: unixODBC - 2.2.11-1.RHEL4.1.i386
unixODBC-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
unixODBC-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
Examining unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm: unixODBC-devel - 2.2.11-1.RHEL4.1.i386
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
Examining unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm: unixODBC-kde - 2.2.11-1.RHEL4.1.i386
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm: does not update installed package.
Nothing to do
-----------------------------------------------------------------