Forum  Migrations  Oracle to SQL S...  SSMA - problems on 64 bit
Disabled Previous
 
Next Next
New Post 11/21/2008 4:19 AM
  ilyagant
0 posts
No Ranking


SSMA - problems on 64 bit 

 


Some time ago we run SQL Server Migration Assistant for Oracle software on a 32bit system (Windows Server 2003 SP2) and everything looked OK.

My current configuration is a 64 bit machine with

   1) SSMA (v4.0.1246 CTP1)

   2) Windows Server 2003 R2 Standard x64 Edition SP2

   3) 64bit OracleDB 10g over Oracle Client Provider

When executing Connect to Oracle, I receive the following error messages from SSMA:


Connection to Oracle failed.
Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
 
The 64bit OracleDB 10g is running on the same machine. Oracle Client Version is 10.2.0.1.0 and 64bit components are installed. Connection to SQL Server 2005 (9.0.3068) works fine. Is the problem caused by SSMA running in 32-bit mode?


 Hope you can help me out in this case.
 

 
New Post 11/21/2008 7:47 AM
  valerius
1 posts
No Ranking


Re: SSMA - problems on 64 bit 

Generally, there is no way to load 64 bit driver within app running in 32 bit mode (more precisely running under WoW64). But if your .NET application starts in 64 bit mode and you want it to see 32 bit driver you can force it to do that.

There's a nice tool that help us to do that magic trick. It's called corflags.exe and present in every .NET Framework SDK. It allows you to configure the CorFlags section of the header of an assembly. If you run it and pass as a parameter assembly name you get something like this:

 

C:\...er Migration Assistant 2005 for Oracle\bin>corflags SSMAforOracle.exe

Microsoft (R) .NET Framework CorFlags Conversion Tool. Version 2.0.50727.42

Copyright (c) Microsoft Corporation. All rights reserved.

 

Version : v2.0.50727

CLR Header: 2.5

PE : PE32

CorFlags : 9

ILONLY : 1

32BIT : 0

Signed : 1

 

The value important for us is 32BIT property. Now it holds a value of 0, which means that this assembly can be run anywhere, since it was compiled with setting of 'any cpu' for the platform target.

We can turn this property on using the following:

 

corflags.exe /32BIT+ SSMAforOracle.exe

 

Now, this assembly would always execute under WoW64.

The other assemblies on which depends the assembly we have changed can have 32BIT=0. But since we have changed the entry point for the whole application we are not concerned about the rest of assemblies. 

 
New Post 9/3/2010 12:02 AM
  lehua777
4 posts
No Ranking


ReplicaBreitling 

Breitling Bentley, is a timepiece that is made to be worn on a person. Breitling Navitimer. The agency issued a tropical storm Breitling Chronomat, Cartier Watches, Replica Cartier, your unbiased guide Cartier Watch. Find information about the newest Cartier Tank, Cartier Santos, Cartier Pasha, and a glimpse into the company history. Chanel Watches. Buy high quality wholesale Chanel Watch, Chanel J12 Watch, Chanel Ceramic Watch, Gucci Watches, directly from top Chinese reliable Gucci Watch, Gucci Bracelet Watch, wholesalers on luxuryreplicas.net with free shipping and worldwide delivery. Omega Watches, Omega Watch, Replica Omega, is trailblazing sub couture. Omega Seamaster. As the wholesaler of Omega Speedmaster, Tag Heuer Watches, we selling cheap quality Tag Heuer Watch, is the founder of the ECG accurate strapless heart rate monitor watch.

 
New Post 8/4/2015 8:06 PM
  clibin
13 posts
No Ranking


Re: SSMA - problems on 64 bit 

 “Blow coach outlet Palgrave Island juicy couture outlet out ralph lauren of air jordan pas cher the juicy couture outlet water!” ugg boots was birkin bag the north face outlet head-line ray ban uk retort of longchamp outlet the newspapers. The government coach outlet was nike free run uk of true religion jeans the michael kors outlet same gucci outlet frame of wedding dresses mind, and the nike outlet assembling nike roshe of the polo ralph lauren outlet fleets burberry began. Walter converse outlet Bassett michael kors outlet broke thomas sabo out in louboutin ineffectual valentino shoes protest, vans but oakley sunglasses was mulberry swiftly burberry outlet online silenced ghd by true religion jeans the threat ugg,uggs,uggs canada of a burberry lunacy north face outlet commission. longchamp Goliah michael kors outlet remained ray ban silent. ray ban sunglasses Against Palgrave soccer jerseys Island hollister five timberland great mont blanc fleets supra shoes were north face hurled vans shoesswarovski crystal the Asiatic Squadron, michael kors the ray ban pas cher South hollister pas cher Pacific nike air max Squadron, north face the kate spade outlet North gucci Pacific hollister Squadron, the Caribbean pandora jewelry Squadron, and swarovski half replica watches of abercrombie and fitch the prada outlet North coach outlet Atlantic Squadron, p90x workout the two vans pas cher latter michael kors coming converse through sac guess the Panama herve leger Canal.

 

“I chanel handbags have tiffany jewelry the soccer shoes honour ugg,ugg australia,ugg italia to bottega veneta report nike blazer that giuseppe zanotti we nike air max sighted asics running shoes Palgrave ferragamo shoes Island coach purses on the converse pas cher evening replica watches of bottes ugg April tory burch outlet 29,” nike air max ran the louboutin outlet report nike air max of polo ralph lauren outlet Captain prada handbags Johnson, hollister of the baseball bats battleship iphone 6 cases North ugg boots Dakota, nike free to nike air max the longchamp Secretary michael kors outlet of vanessa bruno the louboutin shoes Navy. marc jacobs “The beats by dre Asiatic pandora charms Squadron oakley pas cher was jimmy choo shoes delayed oakley sunglasses and longchamp pas cher did reebok shoes not ugg boots arrive jordan shoes until pandora charms the true religion jeans morning montre pas cher of nike huarache April sac longchamp 30. timberland boots A mcm handbags council celine handbags of ugg boots uk the michael kors outlet admirals mac cosmetics was tiffany and co held, ugg boots and nike free it abercrombie and fitch was michael kors decided ugg pas cher to babyliss attack uggs on sale early toms shoes next nike roshe morning. nike trainers The longchamp outlet destroyer, coach factory outlet Swift air force VII, christian louboutin outlet crept hermes in, unmolested, nike air max and new balance reported hogan no oakley sunglasses warlike lacoste pas cher preparations true religion outlet on wedding dresses the island. insanity workout It louboutin noted ralph lauren pas cher several small lancel merchant ray ban sunglasses steamers instyler in air max the kate spade handbags harbour, hollister and louboutin pas cher the lululemon existence of oakley a small village karen millen in tn pas cher a lululemon hopelessly ralph lauren uk exposed nfl jerseys position that new balance pas cher could nike roshe run be hollister swept chi flat iron by nike air max our links of london fire.

michael kors

 
New Post 8/4/2015 8:06 PM
  clibin
13 posts
No Ranking


Re: SSMA - problems on 64 bit 

 “Blow coach outlet Palgrave Island juicy couture outlet out ralph lauren of air jordan pas cher the juicy couture outlet water!” ugg boots was birkin bag the north face outlet head-line ray ban uk retort of longchamp outlet the newspapers. The government coach outlet was nike free run uk of true religion jeans the michael kors outlet same gucci outlet frame of wedding dresses mind, and the nike outlet assembling nike roshe of the polo ralph lauren outlet fleets burberry began. Walter converse outlet Bassett michael kors outlet broke thomas sabo out in louboutin ineffectual valentino shoes protest, vans but oakley sunglasses was mulberry swiftly burberry outlet online silenced ghd by true religion jeans the threat ugg,uggs,uggs canada of a burberry lunacy north face outlet commission. longchamp Goliah michael kors outlet remained ray ban silent. ray ban sunglasses Against Palgrave soccer jerseys Island hollister five timberland great mont blanc fleets supra shoes were north face hurled vans shoesswarovski crystal the Asiatic Squadron, michael kors the ray ban pas cher South hollister pas cher Pacific nike air max Squadron, north face the kate spade outlet North gucci Pacific hollister Squadron, the Caribbean pandora jewelry Squadron, and swarovski half replica watches of abercrombie and fitch the prada outlet North coach outlet Atlantic Squadron, p90x workout the two vans pas cher latter michael kors coming converse through sac guess the Panama herve leger Canal.

 

“I chanel handbags have tiffany jewelry the soccer shoes honour ugg,ugg australia,ugg italia to bottega veneta report nike blazer that giuseppe zanotti we nike air max sighted asics running shoes Palgrave ferragamo shoes Island coach purses on the converse pas cher evening replica watches of bottes ugg April tory burch outlet 29,” nike air max ran the louboutin outlet report nike air max of polo ralph lauren outlet Captain prada handbags Johnson, hollister of the baseball bats battleship iphone 6 cases North ugg boots Dakota, nike free to nike air max the longchamp Secretary michael kors outlet of vanessa bruno the louboutin shoes Navy. marc jacobs “The beats by dre Asiatic pandora charms Squadron oakley pas cher was jimmy choo shoes delayed oakley sunglasses and longchamp pas cher did reebok shoes not ugg boots arrive jordan shoes until pandora charms the true religion jeans morning montre pas cher of nike huarache April sac longchamp 30. timberland boots A mcm handbags council celine handbags of ugg boots uk the michael kors outlet admirals mac cosmetics was tiffany and co held, ugg boots and nike free it abercrombie and fitch was michael kors decided ugg pas cher to babyliss attack uggs on sale early toms shoes next nike roshe morning. nike trainers The longchamp outlet destroyer, coach factory outlet Swift air force VII, christian louboutin outlet crept hermes in, unmolested, nike air max and new balance reported hogan no oakley sunglasses warlike lacoste pas cher preparations true religion outlet on wedding dresses the island. insanity workout It louboutin noted ralph lauren pas cher several small lancel merchant ray ban sunglasses steamers instyler in air max the kate spade handbags harbour, hollister and louboutin pas cher the lululemon existence of oakley a small village karen millen in tn pas cher a lululemon hopelessly ralph lauren uk exposed nfl jerseys position that new balance pas cher could nike roshe run be hollister swept chi flat iron by nike air max our links of london fire.

michael kors

 1 Reports
Disabled Previous
 
Next Next
  Forum  Migrations  Oracle to SQL S...  SSMA - problems on 64 bit