MySQL Problem

[Cary Peebles]

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.

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:
        OSGeo.FDO.Common.Exception: RDBMS: Invalid object type to describe.
           at OSGeo.FDO.Commands.DataStore.IListDataStoresImp.Execute()

IConnection connection = fdoConnectionManager.CreateConnection("OSGeo.MySQL.3.3");
IConnectionInfo connectionInfo = connection.ConnectionInfo;
IConnectionPropertyDictionary connectionProperties = connectionInfo.ConnectionProperties;
connectionProperties.SetProperty("Service", "capeeble-w1");
connectionProperties.SetProperty("Username", "root");
connectionProperties.SetProperty("Password", "mysql");

ConnectionState Constate = connection.Open();

using (IListDataStores dlist = connection.CreateCommand(CommandType_ListDataStores)
                        as IListDataStores)
{
        using (IDataStoreReader reader = dlist.Execute()) // Exception thrown here!
        {
                while (reader.ReadNext())
                {
                }
        }
}

Any help would be appreciated. Any small sample client C# project for MySQL would be great.

[Dan Stoica]

Hi,

Can you do debugging?

"RDBMS: Invalid object type to describe" is thrown in a number of spots in the driver. The question is where and why?


Dan.
-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Cary Peebles
Sent: Monday, March 23, 2009 9:09 PM
To: [hidden email]
Subject: [fdo-users] MySQL Problem


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>connectionProperties.SetProperty("Service", "capeeble-w1");
<br>connectionProperties.SetProperty("Username", "root");
<br>connectionProperties.SetProperty("Password", "mysql");
<br><br>ConnectionState Constate = connection.Open();
<br><br>using (IListDataStores dlist = connection.CreateCommand(CommandType_ListDataStores)
<br>                        as IListDataStores)
<br>{
<br>        using (IDataStoreReader reader = dlist.Execute()) // Exception thrown here!
<br>        {
<br>                while (reader.ReadNext())
<br>                {
<br>                }
<br>        }
<br>}
<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.

_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[Cary Peebles]

I have just been using the binaries. I'll try to see if I can get the source built so I can debug into it.

Dan Stoica wrote:

Hi,

Can you do debugging?

"RDBMS: Invalid object type to describe" is thrown in a number of spots in the driver. The question is where and why?


Dan.
-----Original Message-----
From: [e-mail] [mailto:[e-mail]] On Behalf Of Cary Peebles
Sent: Monday, March 23, 2009 9:09 PM
To: [e-mail]
Subject: [fdo-users] MySQL Problem


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>connectionProperties.SetProperty("Service", "capeeble-w1");
<br>connectionProperties.SetProperty("Username", "root");
<br>connectionProperties.SetProperty("Password", "mysql");
<br><br>ConnectionState Constate = connection.Open();
<br><br>using (IListDataStores dlist = connection.CreateCommand(CommandType_ListDataStores)
<br>                        as IListDataStores)
<br>{
<br>        using (IDataStoreReader reader = dlist.Execute()) // Exception thrown here!
<br>        {
<br>                while (reader.ReadNext())
<br>                {
<br>                }
<br>        }
<br>}
<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.

_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/fdo-users