Re: Cannot Connect to Database Server: Type mismatch

[Michael Britt]

I found the connections.xml file. Here it is with both connections. The first section will not connect. The second section will.

The only differences i can see are the db.mgmt.Connection values and the "int" "isDefault" where the top one is set to 1 and the bottom one is set to 0.

<?xml version="1.0"?>
<data grt_format="2.0">
<value _ptr_="000001EB361ECAB0" type="list" content-type="object" content-struct-name="db.mgmt.Connection">

<value type="object" struct-name="db.mgmt.Connection" id="{762832BE-02A6-472B-A16C-5FD6CFBF8092}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">1</value>
<value _ptr_="000001EB355F8C20" type="dict" key="modules"/>
<value _ptr_="000001EB355F8740" type="dict" key="parameterValues">
<value type="int" key="DbSqlEditor:LastDefaultSchema">1981</value>
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658434767</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">Local instance MySQL80</value>
<link type="object" struct-name="GrtObject" key="owner">{1238A872-4333-4C61-A8AF-F395EEB99503}</link>
</value>

<value type="object" struct-name="db.mgmt.Connection" id="{A07CCE27-C6BB-43A9-AC9E-D48D7E035C73}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">0</value>
<value _ptr_="000001EB3631EA60" type="dict" key="modules"/>
<value _ptr_="000001EB3631F000" type="dict" key="parameterValues">
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658537048</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">NonBrokenRootAccess</value>
</value>

</value>
</data>