ODBC error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
ODBC error
I cannot able to import the table definition through plug in odbc definition.
I am getting the data stage error and i close the datastage designer and needs to reopen again.
Kindly help me on this.
I am getting the data stage error and i close the datastage designer and needs to reopen again.
Kindly help me on this.
-
- Participant
- Posts: 47
- Joined: Wed Aug 20, 2008 7:31 am
- Location: New jersey
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
Error occurs when i click the Table definition->Import->odbc table definition.kandyshandy wrote:Close the Manager, re-open it, try it.
If it happens again, tell us when the error pops up. When you click "ODBC Table definitions" or something else..?
When i entered the DSN,user name and password.I am getting this error meessage.
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
I believe that Sree meant the DSN name. But if the entry is missing, he should not see DSN name from the drop down list at the first place. But you may want to check whether the entry has anything strange.
Or try creating another odbc entry to connect to some other DB and see whether you are able to import from there using ODBC Table Definitions import method. By this way, you can narrow down the issue atleast.
Or try creating another odbc entry to connect to some other DB and see whether you are able to import from there using ODBC Table Definitions import method. By this way, you can narrow down the issue atleast.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
I am not sure about the check list. But, i would like to know the DB (Oracle or ?) you are trying to connect to using ODBC.Yes it is listed.Actually my server got rebooted after that it is not working..Whether i need to start any process?
Someone may tell you how to find ODBC driver or service status.. and/or listener status.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
This along with your post that the server has been re-booted suggests that the network connections with regards to ODBC (IIS to the database) has some issues. You are able to connect to the Server (IIS), but once you are trying to connect to the database using ODBC there is an error that is occurring which is severing your connection.ithirak_17 wrote: ERROR CALLING SUBROUTINE:DSR_IMPORT(Action=2);Check Datastage is set up correctly in project
(The connection is broken (81002).
Try checking the .odbc.ini entries for the DSN that you are trying to connect. Also, did you contact your admin and DBA with regards to this?
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted