-
MikeAtkinson
- Contributor
- Offline
- Posts: 185
- Joined: Wed May 29, 2013 2:10 pm
- Location: Bracknell
-
markc
- Contributor
- Offline
-
- Posts: 386
- Joined: Thu May 23, 2013 4:48 pm
-
MikeAtkinson
- Contributor
- Offline
- Posts: 185
- Joined: Wed May 29, 2013 2:10 pm
- Location: Bracknell
- Open the ODBC administration tool, select the DSN connection and then click on "Configure...". Check that the IP address is correct. Some customers use ports other than the default of 6550, if that is the case for you check the port is specified in the IP address like "172.0.0.1:1234" where 1234 is the port number. The "Connection timeout (seconds)" may be set to 3 by default, if you are making a connection over the internet (or a VPN) increase this to 30 seconds.
- Check that the Kognitio Analytics Platform is running by using the WxAdmin tool
- Check that you can reach the Kognitio Analytics Platform, e.g. by doing a ping and a traceroute ("tracert" on Windows). NOTE: some networks block ping and traceroute, check with your system administrators.
- Check also for dropped packets, excessive numbers of dropped packets may cause connections to fail, especially with a connection timeout of 3 seconds (see above).
- Contact Kognitio support by raising a SalesForce case or via your Kognitio contact.
-
MikeAtkinson
- Contributor
- Offline
- Posts: 185
- Joined: Wed May 29, 2013 2:10 pm
- Location: Bracknell
-
markc
- Contributor
- Offline
-
- Posts: 386
- Joined: Thu May 23, 2013 4:48 pm
Kognitio Console issues, advice, etc.
unable to connect to database server. Connection Timed out
by MikeAtkinson » Thu Jul 25, 2013 10:51 am
We've been asked several times why Console gives the following error on trying to make a connection to the Kognitio Analytics Platform:
08001 [kognito] [wx2 driver] unable to connect to database server. Connection Timed out
This is almost certainly not a Console issue, the error comes from the Kognitio ODBC driver.
08001 [kognito] [wx2 driver] unable to connect to database server. Connection Timed out
This is almost certainly not a Console issue, the error comes from the Kognitio ODBC driver.
Re: unable to connect to database server. Connection Timed o
by markc » Thu Jul 25, 2013 11:08 am
What sort of things normally give that error?
Setting up the connection details wrongly (either providing the wrong IP address/port when specifying address and port in the Console connection dialog, or using a DSN which is specified wrongly) would be one way.
The database being down would be another.
A communication issue between the client and database would be a third (e.g. firewall preventing access, or some network infrastructure issue).
Are there any other ways?
Setting up the connection details wrongly (either providing the wrong IP address/port when specifying address and port in the Console connection dialog, or using a DSN which is specified wrongly) would be one way.
The database being down would be another.
A communication issue between the client and database would be a third (e.g. firewall preventing access, or some network infrastructure issue).
Are there any other ways?
Re: unable to connect to database server. Connection Timed o
by MikeAtkinson » Thu Jul 25, 2013 11:10 am
In order to try and resolve the problem, we recommend the following steps:
Re: unable to connect to database server. Connection Timed o
by MikeAtkinson » Tue Aug 06, 2013 11:24 am
It is possible to do a ping or traceroute (tracert on Windows) directly from within Console using Kog scripts. Using a script like:
This may take some time to complete as tracert may be slow.
Code: Select all
shell("ping 172.1.2.3");
shell("tracert 172.1.2.3");
Re: unable to connect to database server. Connection Timed o
by markc » Tue Aug 06, 2013 12:05 pm
...remembering that sometimes ping can get through but firewalls still prevent connectivity, so the ping test is not a guarantee that connecting to the server on the relevant port for ODBC is possible. You could try to telnet to an IP address/port combination to reduce the risk there.
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest