ASP.NET website connecting to Oracle

Posted on 2011-10-11
Last Modified: 2012-05-12
How to build the website from 32 bit machine (Windows XP prof) and deploy it to windows 2003  ( 64 bit) server.

Connecting to Oracle works fine from devlopment machine (windiows 32) but it doesn't work under windows 2003 server (64 bit server)

Just want to grab table simple table data and display on webgrid.
Question by:Bharat Guru
    LVL 11

    Expert Comment

    Is oracle client (32 bits) installed on the server, are you using the right provider?
    On 32 bits there are 2 providers for Oracle one built by Microsoft and one built by Oracle. For 64 bits the is only one, from Oracle as Microsoft didn't develop his one for this platform.

    Author Comment

    by:Bharat Guru
    can you please provide any sample code to display the table from oracle using
    LVL 11

    Accepted Solution

    So you are looking for Oracle Provider for OLE DB.

    From here you install it on the server:

    Here it is how to create connection string (the one with OraOLEDB.Oracle):

    Here is how to use it in .NET:

    My connection string in my .NET application running on 64-bit is:
    Provider=OraOLEDB.Oracle.1;Password=pass;Persist Security Info=True;User ID=user;Data Source=data_source

    Where data_source is defined in tnsnames.ora

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now