Data Source Name

kennyapril · Post by **kennyapril** » Fri Oct 22, 2010 2:54 pm

I was trying to load data into DB2 Database using ODBC connector.
I an new to this work i.e loading data and In the place of data source I used the name of the database But for some reason the job fails and The error is

Data source name not found and no default driver specified

What could be the problem the stage or the data source name?
please help me with any suggestions.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 22, 2010 3:52 pm

Is the data source name (DSN) you used in the ODBC stage correctly configured in $ODBCINI and registered in uvodbc.config file?

chulett · Post by **chulett** » Fri Oct 22, 2010 8:23 pm

As noted, it's not the database name you use but rather the 'data source name', the name of the entry you made in the ODBC configuration files for this database.

kennyapril · Post by **kennyapril** » Fri Oct 22, 2010 9:33 pm

Regularly we connect to the DB which is informix using DSN which is already configured.

But now the DB is DB2 with a new database Do I need a new DSN for that DB on the server?

Do I need to load the data using Information server which is installed on the same server?

ray.wurlod · Post by **ray.wurlod** » Sat Oct 23, 2010 1:20 am

You do need a new DSN. It might have the same name as the old Informix one, but it will have a totally different definition, including the pathname of the library to be loaded and the port number through which to connect. Prototypes exist within the $ODBCINI file.

kennyapril · Post by **kennyapril** » Mon Oct 25, 2010 8:30 am

Thanks,

Admin created a new dsn for the new database with new definition.

The dsn was created on the server in which the database is present now
Do I need to load the data using the datastage on that server in which the DSN is created?

The file which is to be loaded comes every monday to the server and the records increase every week like first week 100 users Information and the second week 110 users information so approximately 10 new users add every week and they cannot be identified and I have to delete the old week information and load the new week Information.
In the Properties of ODBC connector
Write mode I am using is Delete then Insert

and the table action is Truncate

Please let me know whether the properties I gave are correct for my requirement?