This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello, I can't create or update the database or get any code that hits the database to work in a sample I put together. The sample works fine on another machine that has VS 2010 on Windows XP with Oracle 10.2.0.5 client. On this Windows 7 64-bit machine, the Oracle client was installed correctly and works fine with Sql Developer, TOAD, and even with nHibernate. But I can't get anywhere with LightSpeed as well as another ORM product I'm evaluating -- OpenAccess. I'm sure this is a 32-bit vs 64-bit Oracle driver issue because it was a big pain just getting that issue resolved for using ADO.NET directly in VS 2010 code. Any ideas? |
|
|
|
|
You're right, this is a 32/64-bit issue and I haven't found a solution either. The problem is that the Oracle installer sees the 64-bit OS and insists that you install only the 64-bit version of the client. But Visual Studio is a 32-bit process and can't use 64-bit DLLs. The obvious fix would be for Oracle to allow you to install the 32-bit client alongside the 64-bit client, but they seem to explicitly prevent that. It really is incredibly frustrating. The good news is that the Oracle driver will work fine with LightSpeed at runtime, just as it does with NHibernate. Unfortunately, I haven't found a way of making it work inside Visual Studio for design time. Note that this doesn't stop you working on models using the Toolbox and the properties grid -- it just stops you dragging tables from Server Explorer or doing database sync. I will check with Jeremy if he has a workaround for this but so far I haven't come up with anything better than "run Visual Studio in a (32-bit) virtual machine when you want to do Oracle stuff." Sorry. |
|
|
|
