Page 1 of 1
Problem Connecting to ODBC
Posted: Thu Jun 17, 2010 9:39 am
by nani1974
Hi,
I am not able to connect the SQL Server through ODBC in my production environment where as i can connect the same in Development with same ID & Password................i can read the source data in development through ODBC but not in Production...i checked all the settings in .ODBC.ini file and UVODBC Config file............they are same .....i don't understand where the problem is......can any help me out.
Thanks In Advance
Kumar
Posted: Thu Jun 17, 2010 9:42 am
by anbu
Can you post the error message?
Re: Problem Connecting to ODBC
Posted: Thu Jun 17, 2010 9:55 am
by g_rkrish
nani1974 wrote:Hi,
I am not able to connect the SQL Server through ODBC in my production environment where as i can connect the same in Development with same ID & Password................i can read the source data in development through ODBC but not in Production...i checked all the settings in .ODBC.ini file and UVODBC Config file............they are same .....i don't understand where the problem is......can any help me out.
Thanks In Advance
Kumar
can you able to ping the SQLserver from production. does it respond.
Posted: Thu Jun 17, 2010 10:26 am
by nani1974
Hi,
When i am trying to read the source it's showing the error,........
DSR.MetaGeta(Get.Tables)(SQLConnect('BRETAIN','dsnid')):
BCI Error:
SQLSTATE=08001,CODE=11,[DataStage][SQLClient][ODBC]
[DataDirect][ODBC SQL Server Driver][libssClient22]
General Network Error.Check your Network Documentation.
SQLSTATE=01000,CODE=11,[DataStage][SQL Client][ODBC]
[DataDirect][ODBC SQL Server Driver][libssClient22]
ConnectionOpen (,()).
Thanks
Kumar
Posted: Thu Jun 17, 2010 10:37 am
by anbu
Posted: Fri Jun 18, 2010 5:09 am
by antonyraj.deva
Is the IP address and hostname of the SQL server added to "etc\hosts" file of the client system?
--Tony
Posted: Fri Jun 18, 2010 1:49 pm
by nani1974
Tony,
I did not get you, etc\hosts?...............
why we add this and where we add this because we never did that in any of our project...we just add database in .odbc.ini and uvodbd.config as per my knowledge....
Thanks
Kumar
Posted: Fri Jun 18, 2010 2:08 pm
by Neerav
Can you connect to SQLServer thru external tools like sql server management studio.
Posted: Fri Jun 18, 2010 2:14 pm
by nani1974
Yes, i can connect through SQL Assistant,and i develped the job in Development too.......with same settings....the problem is i cannot connect to the source in production environment which i mentioned earlier with the error i am getting....
Kumar.
Posted: Fri Jun 18, 2010 5:00 pm
by ray.wurlod
Can you ping the SQL Server host machine from your production server?
Is connectivity blocked by a firewall setting?
Posted: Tue Jun 22, 2010 2:08 am
by antonyraj.deva
nani1974 wrote:Tony,
I did not get you, etc\hosts?...............
why we add this and where we add this because we never did that in any of our project...we just add database in .odbc.ini and uvodbd.config as per my knowledge....
Thanks
Kumar
Kumar,
We had a similar issue like you are facing when moving from One server to other and it resolved once I added the required IP addresses to the \etc\hosts file of both the server and the client systems.
I'd suggest to give it a try.
--Tony
Posted: Tue Jun 22, 2010 2:14 am
by antonyraj.deva
The location of the hosts file is "C:\WINDOWS\system32\drivers\etc\hosts" for a windows system.
And in a AIX system the location is just "\etc\hosts" I guess.
--Tony
Posted: Tue Jun 22, 2010 2:29 am
by ray.wurlod
Not quite. On any UNIX system it's /etc/hosts
(On UNIX, \etc\hosts would become etchosts.)