Databases :: Access A New Database ( Which I Created ) In Isqlplus ?

Aug 17, 2010

I created a new database with the help of Database Configuration Assistant !I created with the scott account.Now i'm not able to connect to the database with the connect identifier with the scott account.The error i get is.,

ERROR - ORA-12154: TNS:could not resolve the connect identifier specified.

View 1 Replies


Similar Messages:

Databases :: Error - Database Open For Read-only Access

Jan 20, 2011

I've created a connection to a read only Oracle database but when trying to execute a very simple SELECT statement it generates the following error:

"database open for read-only access"

I've tried a datareader and dataadapter so its looking like a specific issue or protocol with the database that I am unaware of.

View 1 Replies

Databases :: Trying To Access Mysql Database From Aspx.pages Using A Web Config File?

Jul 7, 2010

I am trying to access Mysql database from aspx.pages using a web config file.

My web.config connection string is:

<configuration>
<connectionStrings>
<add connectionString="server-10.xxx.x.xx;uid=xxxxx;pwd=1234;database=Mydb"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
</configuration>

[Code]...

View 1 Replies

Forms Data Controls :: GridView Not Updating / Created Simple Apps To Edit Data In An Access Database?

Dec 18, 2010

I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..

Here is my code

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EnableModelValidation="True" DataKeyNames="id" >
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
SortExpression="id" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="FATHER_NAME" HeaderText="FATHER_NAME"
SortExpression="FATHER_NAME" />
<asp:BoundField DataField="MOTHER_NAME" HeaderText="MOTHER_NAME"
SortExpression="MOTHER_NAME" />
<asp:BoundField DataField="CLASS" HeaderText="CLASS" SortExpression="CLASS" />
<asp:BoundField DataField="gram" HeaderText="gram" SortExpression="gram" /
<asp:TemplateField HeaderText="Remark" SortExpression="Remark">
<EditItemTemplate>
<asp:DropDownList ID="PS" runat="server" SelectedValue='<%# Bind("Remark") %>'>
<asp:ListItem>PASS</asp:ListItem>
<asp:ListItem>FAIL</asp:ListItem>
<asp:ListItem>APPEARED</asp:ListItem>
<asp:ListItem>NOT APPEARED</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Remark") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
UpDatecommand = "update [REGULAR] set [NAME] = ?, [FATHER_NAME]=?, [MOTHER_NAME]=?, [CLASS]=?, [gram]=?, [Remark]=? where [id] = ?"
SelectCommand="SELECT [id], [NAME], [FATHER_NAME], [MOTHER_NAME], [CLASS], [gram], [Remark] FROM [REGULAR] WHERE (([CLASS] = ?) AND ([SCHCD] = ?))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="class"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="schcd"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

View 1 Replies

Databases :: Data Access Layer For Multiple Databases?

Jul 6, 2010

i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection

View 1 Replies

Access :: Data Access Class / Helper Class For Access Databases?

Mar 15, 2011

recommend a data access class / helper class for Access databases, similar to the sqlhelper class found in the (Data Access Application Block)?

View 6 Replies

Access :: IIS_WPG Write/modify Access To The Folder Where MS-Access Database Is Located - Insert An Error Pop-up?

Feb 17, 2010

Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?

Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )

Using System.Data.OleDb;

I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.

View 4 Replies

If The User Click On Button Then The Database Table Is Created In The Database?

Mar 24, 2011

then the database table is created in database(that is SQL express),how can do that.Please sir help me in that problem.I try that thing and debug the code and there is no error in the code but when I click the button in run time ,no table is created in the database(which is placed in sql express 2005).So my problem is that why the table is not created in the database.
[code]...

View 3 Replies

If The User Click On Button Then The Database Table Is Created In Database Through C#?

Mar 20, 2011

My question is that if the user click on button (which is place in default.aspx, for example) then the database table is created in database (SQL express), how can do that? I have tried but errors are occuring during debugging, errors are:the best overloaded method match for 'system.data.odbc.odbc command.odbc command(string,system.data.odbc.odbc connection)'has some invalid arguments.
Argument'2':cannot convert from 'system.data.sqlclient.sqlconnection' to 'system.data.odbc.odbc connection'.
The code written in c# behind the button (button is placed in default.aspx, for example) is:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[code]...

View 2 Replies

SQL Server :: Use Management Studio With Database Created Within MS Web - Connect To New Database?

Mar 30, 2011

I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?

View 6 Replies

Databases :: Update MySQL-database / Database Doesn't Get Updated

Mar 26, 2010

protected void Button3_Click(object sender, EventArgs e)
{
//Create a connection to the database
MySqlConnection conn = new MySqlConnection("Database=kid07025;Data Source=195.178.228.254;User Id=kid07025;Password=********");
//open the connection
conn.Open();
//MySQL Query which updates the row where Anvandarnamn = Anvandarnamn (recieved from a cookie)
MySqlCommand cmd = new MySqlCommand("UPDATE personer SET Information=?Information,Fnamn=?Fnamn,Enamn=?Enamn,Personnr=?Personnr,Adress=?Adress,Postnr=?Postnr,Ort=?Ort WHERE Anvandarnamn=?Anvandarnamn", conn);
// Update with new text
cmd.Parameters.AddWithValue("?Anvandarnamn", Request.Cookies["Anvandarnamn"].Value);
cmd.Parameters.AddWithValue("?Information", TextBox1.Text);
cmd.Parameters.AddWithValue("?Fnamn", TextBox2.Text);
cmd.Parameters.AddWithValue("?Enamn", TextBox3.Text);
cmd.Parameters.AddWithValue("?Personnr",TextBox4.Text);
cmd.Parameters.AddWithValue("?Adress", TextBox5.Text);
cmd.Parameters.AddWithValue("?Postnr", TextBox6.Text);
cmd.Parameters.AddWithValue("?Ort", TextBox7.Text);
cmd.ExecuteReader();
conn.Close();
RefreshProfile();
}

I don't know what I am doing wrong here, but the database doesn't get updated when I press the button.

I use VS 2010, ASP.NET

View 3 Replies

Databases :: SQL Server Database Dependency In Oracle Database?

Feb 27, 2010

I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?

View 2 Replies

C# - Access To An Object Created In Page From A Class?

Jan 18, 2010

I have a page, Default.aspx, with its own code-behind file like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
public int[] anArray;
}

What I'd like to do is access to "anArray" from a C# class (not tied to a page) declared in App_Code folder. What can I do?

Edit: As said in the first comment, I really apreciate your about refactoring my connection objects. However, what I'm really doing here is to rewrite an old PHP application in order to get comfortable with basic C# and ASP.NET, so this code will never go really live. So, I'm still intersted in a way (if any) to access an object declared in a code-behind code from a standard C# class.

Edit2: I removed the OdbcConnection object in order to focus to the real problem: how to refer to an object istantiated in a code-behind file from a C# class situated in App_Code?

View 4 Replies

Databases :: Upload CSV To Ms-Access?

Sep 23, 2010

i am looking for a source code which will do following operation

1 it will ask user to select txt/csv file only when user click on browse

2 after this when user click on upload it should load all records into existing database table.

View 3 Replies

Databases :: Way To Access Datas Using SQL?

Jul 12, 2010

I read a lot of tutorials to learn what was the way to manage accessdata on a MySQL database from my ASP.NET, but there still something to whichremains unclear is the formatting of data and the ideal time to do so.For example, if I have a sentence like the following:"Je voudrais t'aider à résoudre ton problème"
When I pass the variable that contains this sentence, I wonder who the quotea problem because the SQL query in this setting look like this:"'I want to help you solve your problem'The quote of "t'aider" comes as the end of ther string in the query string. So I have to the format the string to double the quote to be able to pass it in the database..Maybe I missed the good tutorials, so if you have any links

View 10 Replies

Web Forms :: Access Control - Not Created By Master Page?

Jul 30, 2010

i am making an asp.net web application.. i wants user to give the facility to login and

View 3 Replies

Granting Write Access To Text File Created In .net

Jul 1, 2010

I have created a .txt file from .net using File.WriteAllText which works fine. Problem is, after being written, I want to grant the file write access so it can be overwritten at some point down the line.

View 3 Replies

Access Session Variable Created In Page From MasterPage?

Oct 21, 2010

I am creating some sessions on successful login and I need to access them from my master page. How do I go about this?

public void showUser()
{
if (!string.IsNullOrEmpty(Session["User"].ToString()))
{
Response.Write(Session["User"].ToString());
}
else
{
Response.Write("Not Logged In");
}
}

View 1 Replies

C# - Access Values Of Controls Dynamically Created On Postback?

Jun 11, 2010

My problem is:

I've got a table, dynamically created, fill with a lot of dropdownlists witches IDs are dynamically created.

When a button is pressed, I need to scan all controls in the table and save their value.

But after the postback I can't no longer access to the table.

View 2 Replies

AJAX :: Can't Access Dynamically Created Textbox In Postback

Sep 20, 2010

I have a script which creates a dynamic textbox (and more) in an AJAX async post back. But when I try to acess the textbox I am told "Object reference not set to an instance of an object". I have been strugleing with this for a long time. This is written in C# .Net 4. The line causing the problem is the very last one where I have tbGameName.Text.Trim()

[Code]....

View 2 Replies

Jquery - Access A Dynamically Created Control Through Javascript?

Sep 25, 2010

I've a JavaScript function in my page through which i make some elements in the page as 'JQuery UI droppable'.

function setDroppableTargets()
{
$(.cssDockZone).droppable();
}

But the elements with the class cssDockZone is created dynamically upon user interaction. So in the code behind i create the control first and finally at the end i register a scriptblock which calls setDroppableTargets().

//set droppable targets ClientScript.RegisterClientScriptBlock(this.GetType(), "setDroppableTargets", "setDroppableTargets()", true);

But the javascript function is invoked before the controls are created eventhough i register the script at the end (after creating the controls) and i cross checked it by getting the elements with class name '.cssDockZone' and i getting it as 0.

$(.cssDockZone).length

View 2 Replies

Access :: Two Databases In One Select Statement?

Jun 10, 2010

"SELECT a.fibunr, " & _

View 14 Replies

Web Forms :: Unable To Access A Dynamically Created User Control

Feb 10, 2010

I have a dynamically created address user control (on a customer administration screen) that is created through the use of a place holder. A customer can have multiple addresses, so they dynamically dropped onto the page.

I have got this far, but now I need to be able to save the updated addresses for the customer but I can't get any event to fire on the user controls. When I check to see run plhAddress.HasControls() it returns false?

The way I am generating the user controls is as follows.. private UserControl LoadControl(string UserControlPath, params object[] constructorParameters)

View 9 Replies

Web Forms :: Access The Custom Headers Created With System.Net.Mail?

Sep 13, 2010

I've created some custom headers for my emails. I've used a breakpoint to see that they are being added to the collection correctly. I don't understand how to access these from the email that's generated though. I'm currently dropping the emails into a pickup directory on my local machine and viewing them with Windows Mail. I have "view all" headers checked in Windows mail but still don't see them when I open my emails in the pick up directory.

how to access the headers that I added? Below is an example of how I did it. I'm hoping to add things like name, address, phone... etc, and then have them visible in the email.

Is this even the correct use of custom headers?

[Code]....

View 1 Replies

Databases :: Access Data From Excel Sheet Using C#

Jan 6, 2010

i want to find data from excel sheet using c# my excel sheet like this

Sr. No.
Store Code
Store Name
City
State
1
3062
C.G.Road.
Ahmedabad
Gujarat
2
3103
Iscon Mega Mall 2
Rajkot
Gujarat
3
3113
New Gandhi Nagar
Ghaziabad
Delhi
4........................

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved