Problem Connecting to ODBC

nani1974 · Post by **nani1974** » Thu Jun 17, 2010 9:39 am

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

anbu · Post by **anbu** » Thu Jun 17, 2010 9:42 am

Can you post the error message?

g_rkrish · Post by **g_rkrish** » Thu Jun 17, 2010 9:55 am

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.

nani1974 · Post by **nani1974** » Thu Jun 17, 2010 10:26 am

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

anbu · Post by **anbu** » Thu Jun 17, 2010 10:37 am

Check this link

http://support.microsoft.com/kb/195566

antonyraj.deva · Post by **antonyraj.deva** » Fri Jun 18, 2010 5:09 am

Is the IP address and hostname of the SQL server added to "etc\hosts" file of the client system?

--Tony

nani1974 · Post by **nani1974** » Fri Jun 18, 2010 1:49 pm

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

Neerav · Post by **Neerav** » Fri Jun 18, 2010 2:08 pm

Can you connect to SQLServer thru external tools like sql server management studio.

nani1974 · Post by **nani1974** » Fri Jun 18, 2010 2:14 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 18, 2010 5:00 pm

Can you ping the SQL Server host machine from your production server?

Is connectivity blocked by a firewall setting?

antonyraj.deva · Post by **antonyraj.deva** » Tue Jun 22, 2010 2:08 am

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

antonyraj.deva · Post by **antonyraj.deva** » Tue Jun 22, 2010 2:14 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jun 22, 2010 2:29 am

Not quite. On any UNIX system it's /etc/hosts

(On UNIX, \etc\hosts would become etchosts.)

DSXchange

Problem Connecting to ODBC

Problem Connecting to ODBC

Re: Problem Connecting to ODBC