Adding Data Source via script for all new users

[shimon]

Hi,
Im planning a migration from one DB to another (SQl to Oracle) and would like to give each user an easy way to add the Data Source.
Does anyone have a VB (or other) script, that adds a Data Source to EA?

Thanks,
Shimon J.

[shimon]

OK.
Just found this and it should work if the users have the "Right" to add a key to the registry.
I'll update this post if it works.

http://windowsitpro.com/systems-management/how-do-i-migrate-odbc-data-sources-one-server-another

[Mauricio Moya (Arquesoft)]

You can create a connection to the Oracle server without having an ODBC declared in the Windows ODBC sources. This could be done when connecting to a database in EA. After doing that (and typing the server, username and password for the database) you can create a shortcut from "File/Save shortcut" and distribute the shortcut.