Printable View
As the title show: where can i find odbc.ini
Because i don't why i can't connect the server.
And i don't know how to login my sql database.
And i don't know how to check the connection between centOS and databases.
And i don't know how to check if port 1433 is open
Hope someone can help me out.:thumbup:
Odbc.ini is located to usr/local/etc and for the rest of your questions check the section tutorial,you`ll find wonderfull things there.
But the logs are saying that the "sql server does not exist"
that also happens if the centos can't reach the windows
When i Ping in centos with the command ping -c4 192.168.1.7 (sql ip/ Windows) It seems to be OK
When i ping in centos with the command ping -c4 192.168.52.128 (centOS ip)
It seems to be OK
So i dont know why database isn't responding.
The ports are also not responding but i still forwarded them.
Enabled TC/IP connection via SQL//Firewall disabled?
How to do that ?
Ok I enabled Tcp.
the porblem "cannot connect to the server".
I did forwarded the ports but when i scan it says they don't respond even when i disable every firewall/and add it to exclusions.
I also don't know how to set the centOS network type Bridged or NAT. because i have a Tele2 modem for television, internet, Telephone.
So what to do ?
Follow this mini tutorial http://forum.ragezone.com/f460/conne...lution-736658/
But i can login with Winscp and putty.
Post your LOGS!
type in putty those commands:
cd var/log/cabal
cat DBAgent_01.log
And post here.
[Wed Apr 13 2011 02:17:05.127420 3086882512]: open log file '/var/log/cabal/DBAgent_01.log'
[Wed Apr 13 2011 02:17:05.127549 3086882512]: LOG LEVEL: 3
[Wed Apr 13 2011 02:17:05.127580 3086882512]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Apr 13 2011 02:17:05.128527 3086882512]: Start DBAgent_01 Server
[Wed Apr 13 2011 02:17:05.129265 3086882512]: UseEcryptText (Off)
[Wed Apr 13 2011 02:17:05.143835 3086879632]: CProcessLayer(0)::svc Start [3086879632]
[Wed Apr 13 2011 02:17:05.143946 3076389776]: CProcessLayer(0)::svc Start [3076389776]
[Wed Apr 13 2011 02:17:05.144019 3065899920]: CProcessLayer(0)::svc Start [3065899920]
[Wed Apr 13 2011 02:17:05.144090 3055410064]: CProcessLayer(0)::svc Start [3055410064]
[Wed Apr 13 2011 02:17:05.144190 3086882512]: try listening 38181 port
[Wed Apr 13 2011 02:17:05.147496 3044920208]: CProcessLayer(0)::svc Start [3044920208]
[Wed Apr 13 2011 02:17:05.298410 3086882512]: accept success 8(127.0.0.1:37990)
[Wed Apr 13 2011 02:17:05.299409 3086882512]: 1.open user 8 [9198BC0] (127.0.0.1)
[Wed Apr 13 2011 02:17:05.430610 3086882512]: accept success 10(127.0.0.1:37992)
[Wed Apr 13 2011 02:17:05.430708 3086882512]: 2.open user 10 [91A7300] (127.0.0.1)
Hmm,the server connected with succesfull to database,try disable firewall.
I already did.
Maybe its the client ?