hi all
i have some tables in the MS Sql database.i want that the data of those tables should be populated in the tables created in oracle.i have created the tales in oracle and just using a single transformer i want to populate them.but when trying to read the data in the ODBC its showing the following error..
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
read data from sqlserver
Moderators: chulett, rschirm, roy
-
I_Server_Whale
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Do you have the DSN's created for accessing the databases? This topic has been covered a ton of times. Searching would yield you more fruitful results. Do an exact search on "Data source name not found and no default driver specified".
Whale.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Data source name not found " is fairly self-explanatory.
Start by importing the table defintions from the ODBC data source. This will automatically populate the uvodbc.config file in your project from the DSNs defined in the Windows registry.
Start by importing the table defintions from the ODBC data source. This will automatically populate the uvodbc.config file in your project from the DSNs defined in the Windows registry.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.