[fdo-users] MySQL Problem
Cary.Peebles at pb.com
Mon Mar 23 21:08:35 EDT 2009
Hi, I am having trouble getting my FDO and MySQL environment set up properly. I have installed MySQl 5.0 and 5.1 and I've tried FDO 3.2.2, 3.3.0, and 3.3.2 and I cannot yet get an open connection. I am able to use the MySQL Administrator to connect so I know the server, user name, and pwd are right.
<br><br>I initially had problems with the provider unable to load libmysql.dll. I found some posts indicating that I should use an older version of this dll which I did and I was able to get further. I'm using C# and the code below. I would like to list out the datastores so I know what is available for me to use and the Execute method throws an exception:
<br> OSGeo.FDO.Common.Exception: RDBMS: Invalid object type to describe.
<br> at OSGeo.FDO.Commands.DataStore.IListDataStoresImp.Execute()
<br><br>IConnection connection = fdoConnectionManager.CreateConnection("OSGeo.MySQL.3.3");
<br>IConnectionInfo connectionInfo = connection.ConnectionInfo;
<br>IConnectionPropertyDictionary connectionProperties = connectionInfo.ConnectionProperties;
<br><br>ConnectionState Constate = connection.Open();
<br><br>using (IListDataStores dlist = connection.CreateCommand(CommandType_ListDataStores)
<br> as IListDataStores)
<br> using (IDataStoreReader reader = dlist.Execute()) // Exception thrown here!
<br> while (reader.ReadNext())
<br><br>Any help would be appreciated. Any small sample client C# project for MySQL would be great.
View this message in context: http://n2.nabble.com/MySQL-Problem-tp2524291p2524291.html
Sent from the FDO Users mailing list archive at Nabble.com.
More information about the fdo-users