Migrating Data Source Names to Sybase drivers

There are two methods to migrate Data Source Names (DSNs) from the OLE DB Driver Kit to the drivers created by Sybase:

Using the Sybase ASE Data Source Administrator

The Sybase ASE Data Source Administrator is a GUI process that allows you to migrate existing OLE DB Driver Kit data sources and to create new data sources for the ASE OLE DB Provider.

To migrate the data sources using the Data Source Administrator

On the main window titled “Sybase Data Source Administrator,” choose the data source.
Click Migrate.

The Sybase Data Source Administrator allows you to add, remove, configure, or test the OLE DB data sources.

Using the DSN Migration tool

The DSN Migration tool can help you migrate the data sources from the OLE DB Driver Kit to the OLE DB Driver by Sybase.The dsnmigrate tool uses switches to control which DSNs are migrated. You need to enter the following from the command line:

dsnmigrate.exe [/?|/h|/help][/oledb]
[/l|/ul|/sl][/a|/ua|/sa] [[/dsn|/udsn|/sdsn]=dsn]
[/suffix=suffix]

For all converted OLE DB DSNs, the new Sybase DSNs will have the same name.

Conversion switches

The following table lists and describes the switches used in the conversion.

**Table 7: Conversion switches**
Switches	Description of results
/?,/h,/help	Displays this message. This message is also displayed if dsnmigrate is called with no command line arguments.
/oledb	Places dsnmigrate into OLEDB-mode. By default, ODBC DSNs are migrated.
/l	Displays a list of all OLE DB Driver Kit user and system DSNs.
/ul	Displays a list of all OLE DB Driver Kit user DSNs.
/sl	Displays a list of all OLE DB Driver Kit system DSNs.
/a	Converts all OLE DB Driver Kit user and system DSNs.
/ua	Converts all OLE DB Driver Kit user DSNs.
/sa	Converts all OLE DB Driver Kit system DSNs.
/dsn	Converts specific OLE DB Driver Kit user or system DSNs.
/udsn	Converts specific OLE DB Driver Kit user DSNs.
/sdsn	Converts specific OLE DB Driver Kit system DSNs.
dsn	The name of the DSN to be converted.
/suffix	An optional switch that changes the way DSNs are named. If this switch is used, the original DSN is retained and the new DSN is named “<dsn>-<suffix>.”
suffix	The suffix that is used to name the new DSN.