Distributing a ODBC connection

[flaviooooo]

Hi,

I'm looking for an easy and quick way to distribute an ODBC Connection on about 100 pcs.

I was thinking about creating a regfile, that would reate a new key in SOFTWARE/ODBC/ODBC.INI, but I'm unsure on how to do this?

Or do you guys have another suggestion for this?

I don't like the thought of having to go pc by pc to add the ODBC connection manually...

Thanks in advance

 

[PCLewis]

If creating a file DSN is not an option, and if you can't avoid a System or User DSN then you are going to hgave to visit 100 PC's or use a tool that will do this. Many corporates face this issue but have powerful deployment tools to assit them.

In case you had not thought about trying a file DSN, it is not too bad a method compared to setting up a DSN manually on each PC. All you have to do is make sure the file.dsn is copied to each user's PC (or make it on a network drive they all map to perhaps).

Cheers

 

[flaviooooo]

What exactly is the difference between a system/user DSN and a File DSN?

Advantages etc?

Thanks