Posted by: Lee Taylor
Date: February 02, 2018 05:19PM

I have created a .NET application that uses ...
Dim sb As New Text.StringBuilder
Dim cn As New MySql.Data.MySqlClient.MySqlConnection(My.Settings.ElationDBConn)
Dim cmd As New MySql.Data.MySqlClient.MySqlCommand("", cn)
Dim rs As MySql.Data.MySqlClient.MySqlDataReader = Nothing

cmd.CommandText = sb.ToString
rs = cmd.ExecuteReader()
tblElationVitals = New DataTable

I user a schema table created from the DataReader above to create the columns for the datatable using the "ColumnName".

When I run the app on one machine it runs fine. When I deploy it to another machine, I get an error indicating duplicate column names when creating the DataTable, note the query executed fine, but the column set returned seems to be different between the two machines.

I used MySQLData ADO.Net driver for MySQL for .Net Core 1.0, Runtime version v4.0.30319, Version

Options: ReplyQuote

Written By
February 02, 2018 05:19PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.