Mysql Connect does not work

rranzmaier

Hi

I try to connect to a mysql database running on my local machine. I installed the "IQ (Supports Oracle,MySql,SqLite)" driver.
Typed in connection information.
Click on "Test" reported "Connection successful" but the Table Explorer shows the Error message "test (Error: InvalidoperationException - CommandText property has not been initialized.)"

Oracle works with the same driver.

Any suggestions ?

BR

rranzmaier

I'm using LINQPad 5 v5.02.03 (Single user License)
IQ Version 2.1.2.0

The latest Beta v5.02.05 shows the same behavior

nescafe

Not able to reproduce here; MySQL driver works correctly after performing these steps:

- Add connection
- Select IQ 2.1.2.0
- Enter Server / Database / User Name / Password
- Deselect Pluralization and Capitalization
- Click Test => "Connection Successful"
- Click OK => Population successful

Could you check the connection string in the advanced tab? This should be something like: Server=MyServer; Database=MyDatabase; Uid=MyUser; Pwd=*****

Could you check another database server? Or at least another database?

I think the problem could be related to one of the objects in the database; if this is the case, could you enable logging for the server and post whatever is queried from LINQPad?

To enable logging see: http://stackoverflow.com/a/6479183

Tested on:
- v5.02.03
- v5.02.05
- Windows 10
- MySQL 5.5.42 (external host since I don't have MySQL installed)