Format of the initialization string does not conform to specification starting at index 0

[kinyanjui_kamau]

Hi experts,

I have an addon that throws an error when I am trying to create a log table (Log4net). The error is : "Format of the initialization string does not conform to specification starting at index 0".

The connection string is: "0030002C0030002C00530041005000420044005F00440061007400650076002C0050004C006F0". Using SAP 9.1

Below is my app.config file:

<connectionStrings>
	<add name="EIMCredit.DAL.Properties.Settings.SBODemoGBConnectionString"
	connectionString="Data Source=ACACIA;Initial Catalog=SBODEMOUS;Persist Security Info=True;User ID=sa;Password=tomcat22"
	providerName="System.Data.SqlClient" />

</connectionStrings>

Below is my code for inserting log table is non existent:

static void CreateLogTable(string logTableName, string connectionString)

        {

            using (SqlConnection sqlConnection = new SqlConnection(connectionString))  <------ Error is thrown here!

            {

                Server server = new Server(new ServerConnection(sqlConnection));

                // Create log table in database

                Database database = server.Databases[sqlConnection.Database];

                if (database == null)//check if database is null

                    return;

                if (!database.Tables.Contains(logTableName))

                {

                    // Create new table, called Log

                    Table newTable = new Table(database, logTableName);

                    // Add "Id" Column, which will be PK

                    Column idColumn = new Column(newTable, LogTableColumnName.Id.ToString());

                    idColumn.DataType = DataType.Int;

                    idColumn.Nullable = false;

                    idColumn.Identity = true;

                    idColumn.IdentitySeed = 1;

                    idColumn.IdentityIncrement = 1;

                    // Add "Date" Column

                    Column dateColumn = new Column(newTable, LogTableColumnName.Date.ToString());

                    dateColumn.DataType = DataType.DateTime;

                    dateColumn.Nullable = false;

                    // Add "Thread" Column

                    Column threadColumn = new Column(newTable, LogTableColumnName.Thread.ToString());

                    threadColumn.DataType = DataType.VarChar(255);

                    threadColumn.Nullable = false;

                    // Add "Level" Column

                    Column levelColumn = new Column(newTable, LogTableColumnName.Level.ToString());

                    levelColumn.DataType = DataType.VarChar(50);

                    levelColumn.Nullable = false;

                    // Add "Logger" Column

                    Column loggerColumn = new Column(newTable, LogTableColumnName.Logger.ToString());

                    loggerColumn.DataType = DataType.VarChar(255);

                    loggerColumn.Nullable = false;

                    // Add "Message" Column

                    Column messageColumn = new Column(newTable, LogTableColumnName.Message.ToString());

                    messageColumn.DataType = DataType.VarChar(4000);

                    messageColumn.Nullable = false;

                    // Add "Exception" Column

                    Column exceptionColumn = new Column(newTable, LogTableColumnName.Exception.ToString());

                    exceptionColumn.DataType = DataType.VarChar(2000);

                    exceptionColumn.Nullable = false;

                    // Add Columns to Table Object

                    newTable.Columns.Add(idColumn);

                    newTable.Columns.Add(dateColumn);

                    newTable.Columns.Add(threadColumn);

                    newTable.Columns.Add(levelColumn);

                    newTable.Columns.Add(loggerColumn);

                    newTable.Columns.Add(messageColumn);

                    newTable.Columns.Add(exceptionColumn);

                    // Create a PK Index for the table

                    Index index = new Index(newTable, "PK_Log");

                    index.IndexKeyType = IndexKeyType.DriPrimaryKey;

                    // The PK index will consist of 1 column, "Id"

                    index.IndexedColumns.Add(new IndexedColumn(index, LogTableColumnName.Id.ToString()));

                    // Add the new index to the table.

                    newTable.Indexes.Add(index);

                    // Physically create the table in the database

                    newTable.Create();

                }

            }

        }

What can I do to solve this?

Any help appreciated.

[pedro_magueija · Accepted solution]

Hi Kamau,

The SAP connection string is meant to connect to the UI Server and not to SQL Server.

If you need to connect to the SQL Server like that have a look at ConnectionStrings.com.

---

Best regards,

Pedro Magueija