locked
Asp.net application data access issue with oracle back-end in windows surface pro 64 bit RRS feed

  • Question

  • User-1797368610 posted

    Hi,

    i have created a 32 bit application and back-end is oracle DB. using Microsoft oracle odbc provider and working fine with windows 7 32 bit. now problem with surface pro windows 64 bit. people are saying i can use oracle oledb provider instead of Microsoft provider as they dont support for 64 bit. please help me out if you guys know the way to configure this application on surface pro.

    Thanks in advanced

    Tuesday, April 25, 2017 9:12 PM

All replies

  • User269602965 posted

    Use Oracle Access Data Provider ODP.NET 

    I use it in mixed 32-bit / 64 bit environments, use with console apps, WPF apps, and ASP.NET website.

    They have GAC dependent Unmanaged driver with Oracle Client, and GAC independent with Oracle Client built in Managed driver.

    Current build is 12cR4

    http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html 

    Tuesday, April 25, 2017 9:25 PM
  • User-1797368610 posted

    Hey,

    Thanks for your reply. Could you provide me the details as step? what do i need to change into web.config and which ODP.net needs to install.

    Wednesday, April 26, 2017 5:18 PM
  • User269602965 posted

    Web config implies the application is running on a web server remote from the Surface device, and not directly on the Surface device.

    They should use Firefox or Internet Explorer on their connection Surface to Web Server and not the default Edge Browser in Surface with Windows 10.

    The Firefox or Internet Explorer should be able to connect the ASP.NET application on the web server.

    If your ASP.NET application is using javascript, that will need to be enabled in the browser settings on the Surface calling the web server application.

    If you are going to transition the web application on the web server to Oracle ODP.NET, you will need to do much reading and all your calls to the database will be different than ODBC.

    Developers guides

    http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/toc.htm

    http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/toc.htm]

    Wednesday, April 26, 2017 9:06 PM