Problem Connecting to ODBC
Moderators: chulett, rschirm, roy
Problem Connecting to ODBC
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
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
Re: Problem Connecting to ODBC
can you able to ping the SQLserver from production. does it respond.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
RK
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
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
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
Kumar,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
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
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: