Microsoft CRM and Scribe in perfect symbiosis

Microsoft CRM and Scribe in perfect symbiosis

About this Blog

In this Blog I will gather information about Microsoft Dynamics CRM and Scribe.

Any issues I might come across will be highlighted and a solution/workaround will be given.

Using Scribe to write to SQL tables with spaces in the table name

ScribePosted by Niels Poulsen 2016-04-22 07:56

When using a SQL ODBC connection to write to a table, that have spaces in the table name, you will get an error.

The solution is to use the Scribe OLE DB adapter to connect to the database.

Use this connection setup:

Data Source = The name of the ODBC to the database

Initial Catalog = The name of the database

User = Name of the user

Password = The password for the user

Additional Connect Parameters: = Blank

Use Owner In Queries: TRUE

Fill in only if you are not real

The following XHTML tags are allowed: <b>, <br/>, <em>, <i>, <strong>, <u>. CSS styles and Javascript are not permitted.