ado - Strange problem in VB6 in generation of executable -

-

i there

i have scenario:

a) notebook :windows server 2008 r1, visual basic 6 service pack.

b) desktop : windows server 2008 r1 (recently update sp1, dunno if guilty), visual basic 6 service pack.

c) client machine (windows xp)

i created executable in a) , installed in c). uses ado (msado15.dll) , works fine in a) , in c)

then, using same code, tried same in b) (compiling in b) ) , work in b) fail in c). verified same code in a) , in b)

in resume:

a machine

  • executable_compiled_in_a.exe works
  • executable_compiled_in_b.exe works

b machine

  • executable_compiled_in_a.exe works
  • executable_compiled_in_b.exe works

c machine (customer machine)

  • executable_compiled_in_a.exe works
  • executable_compiled_in_b.exe fail!

the error message is

class not support automation or not support expected interface

and trigged line

set data = new adodb.connection

so, don't trouble, both uses same reference b) generated different executable.

ps: msdac_typ not work in xp , not problem of msdac because executable generated in a) works in c).

ps2: tried using msado27.tlb , msado28.tlb same results.

ps3: developers machines (a) , b) ) 64bits, while customer machine 32bits.

thanks.

update

the latest service of windows server 2008 r1 (and think same windows 7) update version of ado , executables. short story, latest sp1 evil , bring lot of trouble, @ least ado , development machines.

msado15.dll without service pack 6.1.7600

msado15.dll service pack 6.1.7601

install kb983246 on client's machines. workaround use ado old type library have issue described in kb983246 on 64bit machines.


Comments

Post a Comment

Popular posts from this blog

Javascript line number mapping -

-
magically formatted comments change reported line number of javascript errors in browsers; this: //@line n "f" n line number , f file name. unfortunately, //@line appears ungoogleable. know there documentation on feature, , browsers support it? (i found references here , here .) from can find available in mozilla based browsers. it using js_setoptions command can turn these options on or off depending on values passed. https://developer.mozilla.org/en/js_setoptions
Read more

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

php - Mysql PK and FK char(36) vs int(10) -

-
i have read mysql can handle indexes , searches better if tables keys integers rather char(36) uuid's. is worth converting int(10)? note: use 1 server , have have plans use multiple databases concurrently therefore removing 1 of big reasons using uuid. our tables innodb if makes difference. thanks in advance. usually rdbms can handle integer keys pk more efficient, other datatypes. reason how build index column, yes: long dont require string (or other typed) keys, should use integers. however: char(36) , int(10) far away being equal, because int(10) much smaller, char(36). dont know, if require many different keys, should keep in mind. update, complete last paragraph: int(10) 32-bit, char(36) 36 - ^byte^ (= 288-bit). not mean, int consumes less space, means, char(36) has 4 times more different keys.
Read more