Tag Archives: odbc

Exporting Windows System DSNs

Hello there!

Today I’m going to teach you how to backup System DSNs.

When you migrate MicroStrategy to a new machine, for example, you have to recreate all system DSNs that you had in the old machine to MicroStrategy connect to DWs and Metadata databases.

If you have a lot of DSNs configured, it could be boring create one-by-one again.

To make it easier, you can backup the System DSNs and import it to the new machines.

To do that you just have to:

1. Click Start -> Run -> type: regedit

pic1

2. Browse to: “HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI”

pic2

3. Select ODBC.INI and click “File” and then Export.

pic3

Save in a known place and paste this reg file in the new machine.

Open regedit again and click on File -> Import. Choose your .reg file and every DSN that you had will be created in target machine.

 

That’s it.

Hope it helps.

God bless you!

Unicode in Linux

Hello there!

Today I’m going to talk about an error in strings when you have accents. If you have a word like this: baú in your database and in MicroStrategy you see something like ba?, for example. This is an Unicode problem. You have to set odbc connection to allow accents in your odbc.ini file.

Just go to:

mstrInstallationFolder/odbc.ini

In your odbc connection, change the default value of IANAAppCodePage to 111.

Before: IANAAppCodePage=106

After: IANAAppCodePage=111

It will allow MicroStrategy to use Unicode for that specific database connection.

Hope it helps.

God bless you!