system.Byte[] cannot convert to System.String

[wdiechmann]

Hi,

I've just recently downloaded [b]MyGeneration [/b]- and if this scripting error of mine is a sheer 'noob', please excuse me javascript:emoticon(':oops:')
Embarassed

When I select my connection (MySQL2) languages (->C#) and mapping (Connector.Net) and test connection everything is OK.

When I execute template (dOOdasMySQLBusiness Entity) and select table from connection - I get a scripting error like this:

[code]C:\\Program Files\\MyGeneration\\Templates\\dOOdasMySQL\\VbNet_MySQL_dOOdads_BusinessEntity.vbgen

Source: MyMeta

Error Number: -2147467262

Scripting Errors and Warnings:
[Error] MyMeta (155, 0) -2147467262: Et objekt af typen 'System.Byte[]' kan ikke konverteres til typen 'System.String'.
Stack Trace -[/code]

translated this error reads something like: An object of thy System.Byte[] cannot be converted to type System.String

I have not touched anything - added nothing to anything - as I'm totally green on mygeneration (as stated previously)

best regards,
Walther

[wdiechmann]

I tried using ActiveRecord template instead - and I "bagged" a System Exception for doing that javascript:emoticon(':o')
Surprised

Exception Type: InvalidCastException
Source: DotNetScriptingEngine
Method: Void EngineExecuteCode( Zeus.IZeusCodeSegment, Zeus.IZeusContext)
Message:
System.Byte[] cannot be converted to System.String (approx translation from danish message)

- I use the 5.1.2 MySQL Connector.Net

/Walther

[quote="wdiechmann"]Hi,

I've just recently downloaded [b]MyGeneration [/b]- and if this scripting error of mine is a sheer 'noob', please excuse me javascript:emoticon(':oops:')
Embarassed

When I select my connection (MySQL2) languages (->C#) and mapping (Connector.Net) and test connection everything is OK.

When I execute template (dOOdasMySQLBusiness Entity) and select table from connection - I get a scripting error like this:

[code]C:\\Program Files\\MyGeneration\\Templates\\dOOdasMySQL\\VbNet_MySQL_dOOdads_BusinessEntity.vbgen

Source: MyMeta

Error Number: -2147467262

Scripting Errors and Warnings:
[Error] MyMeta (155, 0) -2147467262: Et objekt af typen 'System.Byte[]' kan ikke konverteres til typen 'System.String'.
Stack Trace -[/code]

translated this error reads something like: An object of thy System.Byte[] cannot be converted to type System.String

I have not touched anything - added nothing to anything - as I'm totally green on mygeneration (as stated previously)

best regards,
Walther [/quote]

[mgnoonan]

You would have to search the forums for MySql, but I think I remember having to copy the MySql provider to the MyGeneration folder. There's a post somewhere on the forums telling what to do.

[dnparsons]

MySQL Connector 5.1.x is still Beta. I do not believe MyGeneration MyMeta has been tested against that. It includes improvements to stored procedure schema parsing, which may be breaking changes to MyGeneration. Have you tried the GA release 5.0.x? Matt is right, you need to copy MySql.Data.dll to the MyGeneration program folder.

[dnparsons]

It occurred to me that they have added some data types to the latest MySQL. It may just be a mapping issue, which can be adjusted by the user. Once you have selected Language Mappings and Database Target Mappings in Default Settings, you can click on the icons on the toolbar. They are the third and fourth from the right. They can be changed and new mappings added. If you need to make changes, you should report them, so they can be added to the shipping version with the next release of MyGeneration.

But, I think the safest, easiest thing to do first is use the 5.0.x Connector.

[wdiechmann]

It occurred to me that they have added some data types to the latest MySQL. It may just be a mapping issue, which can be adjusted by the user. Once you have selected Language Mappings and Database Target Mappings in Default Settings, you can click on the icons on the toolbar. They are the third and fourth from the right. They can be changed and new mappings added. If you need to make changes, you should report them, so they can be added to the shipping version with the next release of MyGeneration.

But, I think the safest, easiest thing to do first is use the 5.0.x Connector.

- oh so true

- 5.0.7 did the trick - now I'm building entityspaces templates - and thanks to you all!