SV: Huge memory consumed with myOdbc and VB.NET

------_=_NextPart_001_01C66EA4.431DC356
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm sorry for the bad example, my first post!
Attached is a working example and with a schema for the table.

The problem is not just related to this table, any other big tables is
crasching the application, and what causing the problem is
adapter.MissingSchemaAction =3D MissingSchemaAction.AddWithKey.

The application runs on more then 10 other servers without problem, it's
just related to one server.

//Patrik


------_=_NextPart_001_01C66EA4.431DC356
Content-Type: text/plain;
name="Module1.txt"
Content-Transfer-Encoding: base64
Content-Description: Module1.txt
Content-Disposition: attachment;
filename="Module1.txt"

DQpJbXBvcnRzIFN5c3RlbS5EYXRhLk9kYmMNCg0KTW9kdWxlIE1vZHVsZTEN Cg0KICAgIFByaXZh
dGUgY24gQXMgT2RiY0Nvbm5lY3Rpb24NCiAgICBQcml2YXRlIERhdGFhZGFw dGVyIEFzIE9kYmNE
YXRhQWRhcHRlcg0KDQogICAgU3ViIE1haW4oKQ0KDQogICAgICAgIERpbSBk cyBBcyBOZXcgRGF0
YVNldA0KICAgICAgICBEaW0gc3FsIEFzIFN0cmluZw0KICAgICAgICBEaW0g Y291bnQgQXMgSW50
ZWdlciA9IDEwMDAwDQogICAgICAgIGNuID0gTmV3IE9kYmNDb25uZWN0aW9u KCJEU049dGVzdCIp
DQogICAgICAgIHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHByaXNlciB3aGVyZSBh cnRucj0gJzEnIEFO
RCBEYXR1bSA9JzIwMDYtMDEtMDEnIg0KICAgICAgICBUcnkNCiAgICAgICAg ICAgIGNuLk9wZW4o
KQ0KICAgICAgICAgICAgRGF0YWFkYXB0ZXIgPSBOZXcgT2RiY0RhdGFBZGFw dGVyKHNxbCwgY24p
DQogICAgICAgICAgICBEYXRhYWRhcHRlci5NaXNzaW5nU2NoZW1hQWN0aW9u ID0gTWlzc2luZ1Nj
aGVtYUFjdGlvbi5BZGRXaXRoS2V5ICAnV2hlbiByZW1vdmluZyB0aGlzIGxp bmUgdGhlIGlzdWUg
ZG9lc24ndCBhcmlzZSEhIQ0KICAgICAgICBDYXRjaCBleCBBcyBFeGNlcHRp b24NCiAgICAgICAg
ICAgIENvbnNvbGUuV3JpdGVMaW5lKGV4Lk1lc3NhZ2UpDQogICAgICAgICAg ICBDb25zb2xlLlJl
YWRMaW5lKCkNCiAgICAgICAgICAgIEVuZA0KICAgICAgICBFbmQgVHJ5DQoN CiAgICAgICAgRG8N
CiAgICAgICAgICAgIFRyeQ0KICAgICAgICAgICAgICAgIERhdGFhZGFwdGVy LkZpbGwoZHMsICJw
cmlzZXIiKQ0KICAgICAgICAgICAgQ2F0Y2ggZXggQXMgRXhjZXB0aW9uDQog ICAgICAgICAgICAg
ICAgQ29uc29sZS5Xcml0ZUxpbmUoIkNvdW50OiIgJiBDb3VudCAmIHZiQ3JM ZiAmIGV4Lk1lc3Nh
Z2UpDQogICAgICAgICAgICAgICAgRXhpdCBEbw0KICAgICAgICAgICAgRW5k IFRyeQ0KICAgICAg
ICAgICAgJ0RvIHNvbSB3b3JrIQ0KDQogICAgICAgICAgICBJZiBDb3VudCBN b2QgMTAwID0gMCBU
aGVuDQogICAgICAgICAgICAgICAgQ29uc29sZS5Xcml0ZShDb3VudCAmICIs KCIgJiBkcy5UYWJs
ZXMoMCkuUm93cy5Db3VudCAmICIpIikNCiAgICAgICAgICAgIEVuZCBJZg0K ICAgICAgICAgICAg
ZHMuVGFibGVzKCJwcmlzZXIiKS5DbGVhcigpDQogICAgICAgICAgICBDb3Vu dCAtPSAxDQogICAg
ICAgIExvb3AgVW50aWwgQ291bnQgPD0gMA0KICAgIEVuZCBTdWINCg0KRW5k IE1vZHVsZQ0KDQo=


------_=_NextPart_001_01C66EA4.431DC356
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
------_=_NextPart_001_01C66EA4.431DC356--