no

there is no way to create a DSN.

What can u do is to create one dsn physically for that server, then add name of the database before the table.

I have done this b4 and it is working sucessfully.

My problem was ...i had one databse. but after some time i need to aschive data, and then generate report based on that data.

So thru stored procedure i created few buckets then useing one dsn i was connection with different databases stored on same physical machine.