have already gone thro' that example, zuperman.....i dont have any problems when i create the dsn without specifying the userid and the pwd...its only when i do specify a userid and a pwd that i get an error......

so i guess for now i'll just not add that bit.....and use the userid and pwd at the time of connecting to the databse....unless someone can come up with a solution to my problem

thanx anyway!