SQL Server-Oracle-Linked Server on 64 bit machine
-
Hello, WE are moving to a 64 bit machine. The usual provider MSDAORA is not avaliable. Started to use the ORAOLEDB.ORacle provider. While this works, there is a data issue. One of them show up as data conversion to type numeric. This worked perfectly on the 32bit environment. Which is the ideal provider to use on a 64 bit machine? Much appreciated!!
-
Hello, WE are moving to a 64 bit machine. The usual provider MSDAORA is not avaliable. Started to use the ORAOLEDB.ORacle provider. While this works, there is a data issue. One of them show up as data conversion to type numeric. This worked perfectly on the 32bit environment. Which is the ideal provider to use on a 64 bit machine? Much appreciated!!
I suspect you don't have many choices. As you stated Microsoft doesn't do a 64 bit version. And presumably you have spent the time to verify the actual problem in the Oracle version. At one time there was a 3rd party company that created database drivers. But searching quickly I can't find them. You might have better luck. Other than that I would suggest modifying your code. You can always have your SQL return a string, rather than numeric, and then process that in your C# code.
-
I suspect you don't have many choices. As you stated Microsoft doesn't do a 64 bit version. And presumably you have spent the time to verify the actual problem in the Oracle version. At one time there was a 3rd party company that created database drivers. But searching quickly I can't find them. You might have better luck. Other than that I would suggest modifying your code. You can always have your SQL return a string, rather than numeric, and then process that in your C# code.
A bit of an issue. The select statement has about 450 variables(?), I know, not something I created. The select statement is not executing stating it is exceeding the 8000 characters selection limit. This is the first time I am ecountering a limit on selection.
-
A bit of an issue. The select statement has about 450 variables(?), I know, not something I created. The select statement is not executing stating it is exceeding the 8000 characters selection limit. This is the first time I am ecountering a limit on selection.
vanikanc wrote:
The select statement is not executing stating it is exceeding the 8000 characters selection limit.
I can assure that a statement limit has existed for years. Pretty sure I saw it in Oracle 8. So in terms of a previous driver you got lucky because you were at the border anyways. And depending on the data it could have gone over with the older driver. The only solution for that, which I can think of (besides getting rid of all those fields) is to encode the data into xml and then return is as a blob and then re-extract.