On 9 Ott, 18:38, Smitty <marksmith...@hotmail.com> wrote:
> On Oct 9, 12:24 pm, pamela fluente <pamelaflue...@libero.it> wrote:
>
>
>
>
>
> > On 9 Ott, 18:20, pamela fluente <pamelaflue...@libero.it> wrote:
>
> > > On 9 Ott, 17:40, Smitty <marksmith...@hotmail.com> wrote:
>
> > > > On Oct 6, 11:33 am, pamela fluente <pamelaflue...@libero.it> wrote:
>
> > > > > On 5 Ott, 20:33, Smitty <marksmith...@hotmail.com> wrote:
>
> > > > > > On Oct 5, 2:31 pm, "Martijn Tonies" <m.ton...@upscene.removethis.com>
> > > > > > wrote:
>
> > > > > > > > Hello everyone. I am brand new to mySQL, so I am not sure if this can
> > > > > > > > be done. Is there a way to capture a schema? I am taking over a
> > > > > > > > number of databases, and I'd like to get a better understanding of
> > > > > > > > each database. Thanks in advance
>
> > > > > > > What do you mean by "capture a schema"? Create a visual diagram from it?
>
> > > > > > > Yes, there are tools that can do that for you, both free and commercial.
>
> > > > > > > Ours is a commercial tool named Database Workbench, seewww.upscene.com
>
> > > > > > > --
> > > > > > > Martijn Tonies
> > > > > > > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> > > > > > > MS SQL Server
> > > > > > > Upscene Productionshttp://www.upscene.com
> > > > > > > My thoughts:http://blog.upscene.com/martijn/
> > > > > > > Database development questions? Check the forum!http://www.databasedevelopmentforum.com
>
> > > > > > Sorry, I wasn't more clear. Yes, a visual diagram would be great. I
> > > > > > am going to try the tool you mentioned. Thanks a lot.- Nascondi testo tra virgolette -
>
> > > > > > - Mostra testo tra virgolette -
>
> > > > > Another powerful one, free, will show all the DBMS details, including
> > > > > OleDBSchemGUIDs
> > > > > stored procedures, relations, types, etc.http://www.datatime.eu/download.aspx
>
> > > > > Create Connection > DatabaseExplorer > Reload structure etc ...
>
> > > > > Enjoy!
>
> > > > > -P
>
> > > > Thanks, I downloaded this tool, but am getting a "The 'MySQLProv'
> > > > provider is not registered on the local machine" error. I have to
> > > > look into this error and see what needs to be done.- Nascondi testo tra virgolette -
>
> > > > - Mostra testo tra virgolette -
>
> > > It's not an error. It's normal if you have not installed
> > > the OleDB provider client (free) for MySQL.
>
> > > Clearly, you need to install the OldDB provider to connect to the DBMS
> > > (there is a link in the documentation).
>
> > > For any question or problem, just get back to me or post on the group.
>
> > > -P- Nascondi testo tra virgolette -
>
> > > - Mostra testo tra virgolette -
>
> > OleDB driver here:http://sourceforge.net/projects/myoledb/
>
> Thanks so much Pamela for your responses. I downloaded the OldDB
> provider, and am getting this error now when trying to connect:
> "Could not retrieve OleDB Data Types info from (schema not
> supported)Could not retrieve information about OledDB data types
> from" Thanks again for your - Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

That's not good.

Let me test the OleDb driver. The last time I tried it worked just
fine (apart some little
fixes we had to make to remove the double Null char at the end of each
string).

Perhaps some changes have been made to the OleDB driver
which compromise the compatibility with the .NET OleDBSchemaGuid
class. I do hope not.

In case, I will search for the OleDbProvider which we used (time ago)
for the test
and that was working fine.

Keep in touch and in the meantime get familiar with the tool by using
it on other DBMSes.

I will be back soon.


PS
You can also experiment with third part drivers if you find it, by
using the "General connection" dialog.
-P

>
> Thanks so much Pamela for your responses. I downloaded the OldDB
> provider, and am getting this error now when trying to connect:
> "Could not retrieve OleDB Data Types info from (schema not
> supported)Could not retrieve information about OledDB data types
> from" Thanks again for your - Nascondi testo tra virgolette -


Ok I think I found the old Driver we used and which worked (windows):
here is a copy:

http://www.datatime.eu/public/MyOLEDB.exe

Uninstall the one you have and try this one.

I am going to test the new one. Let me know how this works.

-P

On 9 Ott, 18:38, Smitty <marksmith...@hotmail.com> wrote:
.... am getting this error now when trying to connect:
> "Could not retrieve OleDB Data Types info from (schema not
> supported)Could not retrieve information about OledDB data types
> from" Thanks again for your - Nascondi testo tra virgolette -
>


Dear Mark,

I had the test done. Here are the findings.

First of all the solution:
---------------------------------------------------------------------------------
1. Download the NEW release: http://www.datatime.eu/download.aspx
2. Download this driver: http://www.datatime.eu/public/MyOLEDB.exe
[ it's a local copy of MyOLEDB 3.00 ]

If you have done a connection to your MySQL, remove it and
make sure
you will NOT use it with the new version of DataTime. Make
a NEW one.

----------------------------------------------------------------

Let me know if this is working for you ! Thank you.



Here is what we found:

1. First of all, there was a bug in DataTime related to MySQL.
But this was not the reason
of your error message. It would just prevent the use of the
old driver MyOLEDB 3.00
Actually it was not expected this bug to be there. It was
probably introduced in one of the
latest revision by one of newer programmers. We have fixed
it now.

2. The provider myoledb-3.9.6.msi that can be found on the
download page seems to have major issues.
It does not support the .NET Oledbschemaguid class. So it's
practically unusable for our purpose
or on the .NET framework.


Strangely, the older version of the provider MyOLEDB 3.00
had this support got [almost] right
therefore you need to use it.
I said "almost" because, strangely, it has in all string an
additional Null char which we remove programmatically
[you can still see it in the display of the
OleDBSchemaGUIDs]
(the above mentioned bug was that this bug removal had been
removed !! ).



========= TO MYSQL USERS ==========


Now the point become: why the newer MyOLEDB is no more
working with .NET ??
Is anyone here that can respond ?

And please, if you fix it, as I hope, make sure to remove
that additional Null char in all the Guid strings. Please !

You can use the DataTime OLEDB scanner to check the Oled
Driver. We have used it will all the commercial drivers
available on the market, and all the serious driver pass
perfectly our scanning. So Mysql should also :-)

-P

On 5 , 18:52, Smitty <marksmith...@hotmail.com> wrote:
> Hello everyone. I am brand new to mySQL, so I am not sure if this can
> be done. Is there a way to capture a schema? I am taking over a
> number of databases, and I'd like to get a better understanding of
> each database. Thanks in advance

Take a look at MicroOLAP Database Designer for MySQL. It doesn't
requier any drivers, OLEDB providers and so. Just perform Reverse
Engineering of your database and you'll get your schema.

http://microolap.com/products/database/mysql-designer/