Oracle connection string help

Hi,

I have built a little web application that checks a field on an oracle database then redirect users depending on this value. I have just managed to deploy the admin are with a sql databse and thought all was well, but this is key to the functionality of the site.

In my admin area I had to change the connection string for the sqlserverclient as the provider to make the site work, but I'm not sure what to do with the oracle bit.

To explain how this works, basically I am using System.Data.Odbc in a model. This model contains the connection string and basically when called, performs the query on the oracle table and returns bool to the controller. The controller then directs the user to the correct view.

This works fine when debugging on my machine but when I deploy the value is always to the defual "false" despite me changing the value on the oracle table so it would return true.

Below is the model itself, I have also correctly setup the ODBC settings on the server and they connect to the database.

I can't think what else it could be so I am guessing it is something to do with the connection string needing to be in the database?

Any way here is my model:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.Odbc;

namespace Gateway.Models
{
    public static class Lock
    {
        static OdbcConnection conn = new OdbcConnection();
        static OdbcDataAdapter da = new OdbcDataAdapter();
        static DataSet ds = new DataSet();
        static Boolean bol = false;
        static string val;

        public static bool getState()
        {
            string strSQL = "SELECT TABLE.FIELD_LOCK.* FROM TABLE.FIELD_LOCK";
            goget(strSQL);
            if (bol == true)
            {
                val = ds.Tables[0].Rows[0][0].ToString();
                if (val == "Y")
                    return true;
                return false;
            }
            else
            {
                return false;
            }
        }
        static void Conect()
        {
            conn.ConnectionString = "DSN=database;UID=user;PWD=password;DBQ=database;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0;";
        }

        public static void goget(string strSQL)
        {
            try
            {
                Conect();
                da.SelectCommand = new OdbcCommand(strSQL);
                da.SelectCommand.Connection = conn;
                ds.Tables.Clear();
                da.Fill(ds);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    bol = true;
                }
            }
            catch    // Unanticipated error.
            {
                bol = false;
            }
        }

Thanks in advance,

Andy

Re: Oracle connection string help

mcinnes01

static void Conect()
        {
            conn.ConnectionString = "DSN=database;UID=user;PWD=password;DBQ=database;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0;";
        }

HelloIt seems that you wanna change the connection string dynamicallySo please do to use the connection string by putting it into the web.config's <connectionStrings> tags by adding a nameand then use ConfiguationManager.ConnectionStrings["name defined in the connection string's tag"].ConnectionString to read it out

For more about ConfigurationManager's usageplease refer to thishttp://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager(v=vs.80).aspx

Reguards