Oracle10g - Error : Column Ambiguously Define, When Migrate To Other Server
Oct 12, 2010
I have ASP.Net application, It using mix .net framework, there are project with ,net framework 1, 2.0 and 3.5. buat they are in separated project / location. And its running well before.I have a problem when I migrate my application from old development server to new one, FYI, my old server is windows server 2003 32 bit with oracle 10g, and my new server is windows server 2008 64bit with the same oracle version. I have set all configuration identically in both servers. using same database schemas, and same application.Overall, the application running well, but I was surprise when I found some error page while I running application in new server. error message is : ORA-00918: column ambiguously defined I don't know how the error happen, whereas in old server, no error at all with identically configuration.any one have same problem ?is it because 32bit & 64bit ?
View 1 Replies
Similar Messages:
Sep 13, 2010
I am using asp.net 3.5 in visual studio 2008; when ever tried to connect the DB through data connection in server explorer or in Gridview new connection it seek a user id ,password and the server name. while i provide all this it gives an error:
ORA 12514: TNS: listener does not currently know the connect descriptor.
I have googled the error but could not resolve it till now.
I am using windows XP as OS.
View 5 Replies
Aug 18, 2010
I have an ASP.NET project that also uses a SQL MDF File. My target server is SQL 2008R2 or SQL Azure.I would like to know what deployment options I have as I migrate from DEV to PROD. In case it matters I'm not under any regulation to maintain PII or similarly private data.
View 3 Replies
Jan 2, 2011
how to migrate two mail server, just passing source and destination mail id .
View 2 Replies
Jun 10, 2010
In the example below I have set the control style to 'controlName' I want to use this class to define what my textbox looks like in edit mode. This works ok, so far so good. The Problem In a button event I add the class "validationError" to this textbox if the data is incorrect. When the grid gets rendered I expect to get 'controlName validationError as the class applied to the textbox. Unfortunately, it seems that the declarative statement overrides this and simply ends up as 'controlName' how I can intercept the application of the declarative class so that I get what I desire here?
<asp:BoundField
DataField="Name"
HeaderStyle-CssClass="headerName"
ItemStyle-
CssClass="itemName"
ControlStyle-CssClass="controlName"
HeaderText="Name"
>
</asp:BoundField>
View 4 Replies
May 19, 2010
I want to migrate data from SQLite to MS SQL- Server using ASP.NET (not third party software).
View 1 Replies
Mar 10, 2010
Currently we are running an application build in VB6,ASP,Commerce Server2000 and Sql Server 2000. This application is running in Windows 2000 server.Now we are planning to migrate Windows server 2000 to Windows 2008.Will this application run in Windows 2008 or do we need to upgrade this application to dotnet and Sql 2008?
View 1 Replies
Mar 8, 2011
I have an insert table with identity specification set. And I getthis error. I'm using a stored procedure to store it. How do I correct it. I'm also using a details view on my insert page.
Exception Details: System.Data.SqlClient.SqlException: Cannot insert explicit value for identity column in table 'Insert' when IDENTITY_INSERT is set to OFF.
View 4 Replies
Apr 2, 2011
We have migrate from VS2005 to VS2010. CR2010 installed too.
We have 1 website and class project in one solution.
The assembly of web.config has point to new version of CR ver13 and also checked that the references is ver13 too.
WEB CONFIG:
[code]....
However in code behind, when "Go To Definition" the imported CrystalDesicions Namespace, it go to CR version10 location.
The class project has references to correct ver13.
In the end we get error of :
Error 17 The project currently contains references to more than one version of CrystalDecisions.CrystalReports.Engine, a direct reference to version 10.2.3600.0 and an indirect reference (through 'Web_cl.clsAccountRpt.GetAccountStatementSummaryRptDoc')
to version 13.0.2000.0. Change the direct reference to use version 13.0.2000.0 (or higher) of CrystalDecisions.CrystalReports.Engine. D:ProjectWebGlobal 4.0Web_developCpAdminReportFormAccountReportModule.aspx.vb 40 28 D:...Web_develop
The function in class has return ReportObject back to the website, because of the website reference did not really point to new version has causes this error. I have checked all references in web.config and project properties all is point to new version, but in program it seems still point to old one.
View 5 Replies
Aug 4, 2010
Is it possible to set the property of a server tag from a c# expression, i.e. something like <asp:TextBox Width='<%= [some c# expression] %>'/> I though this would be pretty straightforward, but I can't get such an expression to run.
View 2 Replies
Feb 28, 2011
I am using an adapter to get a list with IN where clause as:
[Code]....
I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5
However, it returns error of Error converting nvarchar value.
View 3 Replies
Dec 17, 2010
I am new to asp.net and wondering if anybody can help me defining SQL Server 2005 ConnectionString in web.config file and call/read anywhere in application on any button.Kindly provide me code example.
View 3 Replies
Dec 19, 2010
below is my query have one problem:-
[Code]....
In first time My sqlcommand returns null coz if its no data in table..
So on that time i need to show B0... how to do this
View 5 Replies
Feb 1, 2011
I want to change one of my table columns data type. Now the column data type is varchar and i want to change it to float. Updated all the column data to numeric and tried to convert the datatype with the following syntax
alter table vibration_values alter column dis_v float
but getting the error as
Error converting data type varchar to float.
The statement has been terminated.
Suprisingly every thing worked well in sqlserver 2005 and not working in sqlserver 2000.
View 6 Replies
Dec 2, 2010
m stuck at one place...i want to tranfer data from one database-1 to another database-2...both databases are for different web application.
Currently i am doing the same using dataset..but the problem is that when Large amount of data is coming in dataset so during the tranfer of data server gives me a Time out Error.
And another thing i am not want to utillise a server memory because there is Lacs of data into the Database for migrate.
View 2 Replies
Jan 25, 2011
I have designded a asp.net server control that have an embeded javascript file.
document.getElementById("div_Messages_Back").style.left = 0;
document.getElementById("div_Messages_Back").style.top = 0;
document.getElementById("div_Messages_Back").style.width = document.documentElement.clientWidth;
document.getElementById("div_Messages_Back").style.height = document.documentElement.clientHeight;
document.getElementById("tbl_Messages").style.left = (document.documentElement.clientWidth - 250) / 2;
document.getElementById("tbl_Messages").style.top = (document.documentElement.clientHeight - 120) / 2;
function btn_Close() {
document.getElementById("div_Messages_Back").style.visibility = "collapse";
document.getElementById("tbl_Messages").style.visibility = "collapse";
}
I want the first 6 line of my javascript file run at runtime. But I recieve error at runtime:
Error: Object Required.
View 1 Replies
Jan 15, 2011
I am using VS 2010, C# and Sql server 2008. I am having a list returned from the database. I am trying to convert the
list to a dataset.
I am getting the error as "Cannot set column 'column name' to be null. use DBNull instead.
This is the code i have used:
[Code]....
How to fix this?
View 1 Replies
Jan 16, 2011
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
View 4 Replies
Aug 10, 2010
I have a table converted from Access and the identity keys were lost. Now I need to make the id column the identity column, but it already has a lot of null values, how do I auto generate integer values for the null rows? The row ids are incremented, so if there is a way to auto increment the ids
View 7 Replies
Feb 17, 2011
I am creating dynamic view using two tables.one is emp_Tbl and 2nd table emp_salary which is created dynamically .creating view it gives error 'Create View or Function failed because no column name was specified for column 2.
my code is: create view [dbo].[Emp_Salary_pay] as select dbo.Emp_Tbl.Emp_Status, (select column_name + ', ' from information_schema.columns where table_name = 'Emp_salary' ) FROM dbo.Emp_Tbl INNER JOIN dbo.Emp_Salary ON dbo.Emp_Tbl.Emp_Id = dbo.Emp_Salary.Pay_Emp_Id
View 5 Replies
Aug 18, 2010
I have a SQL Server 2005 database which is queried by a web service which is called by an aspx page.
I inherited a messy and inefficient project, and I was working on cleaning up a GridView by making it dynamic and by having consistent field names in the database when I started getting an error of - Sys.WebForms.PageRequestManagerServerErrorException: Invalid column name: 'ASSIGNED_TO'
Assigned_to does not exist in the database, in the web service, or in the website solutions in any place. It was the name of one of the fields in one table, which I changed to USERID so that either of two datasets would fit into a Gridview (all other fields were the same). I then replaced all references of ASSIGNED_TO with USERID, which is when the issues began. The first of the two queries below causes the exception to be thrown, but the second one does not. I have tested both with the WCF Client and with a query within SQL Server to verify that they do work, so the issue has to be on the website side.
sSQL = "select distinct B.BADGE_NBR, a.REGId,B.CYC_RTE, b.USERID, a.MTRREAD,A.NEWMTRNUM, a.COMPTIME, B.FA_TYPE, CASE WHEN A.MTRCOMMENTS <> 'Null' THEN '*' END as Comment,a.MTRLAT,a.MTRLONG,a.WOFAID, b.ADDRESS, a.MTRREADFLAG, b.ROUT_SEQ from MobileDataReturn a,WORKORDERDIPATCHFILL b Where a.RegId = b.REGID and a.WOFAID = b.FA_ID and B.CYC_RTE " & route & "' and b.USERID " & worker & "' and B.BADGE_NBR " & badge & "' and a.MTRREADFLAG " & readflag & "' and b.FA_TYPE " & fatype & "' Order by a.COMPTIME desc"
sSQL = "select distinct BADGE_NBR, REGId,CYC_RTE, USERID,MTRREAD,NEWMTRNUM, COMPTIME, FA_TYPE, CASE WHEN MTRCOMMENTS <> 'Null' THEN '*' END as Comment,MTRLAT,MTRLONG,WOFAID, ADDRESS, MTRREADFLAG from MobileDataReturnArchive Where CYC_RTE " & route & "'and USERID " & worker & "'and BADGE_NBR " & badge & "' and MTRREADFLAG " & readflag & "'and FA_TYPE " & fatype & "' Order by COMPTIME desc"
The Gridview:
[Code]....
View 5 Replies
Nov 23, 2010
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
View 10 Replies
Jun 14, 2010
I having the project in Vb i want to migrate that project in the vb.net. i have tried a lot.i have not installed the visual basic.
View 4 Replies
Sep 23, 2010
I've created a small website with a simple sqlite database using vwd 2010 .net 4. In dev and test envionments everything works fine, however when i promote to my hosting provider i receive the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I've been configuring the connection strings (autogenerated from entity framework and attached db) but unable to get it working on the hosting provider, I'm assuming it's related to permissions but not entirely sure how to resolve - here's the web.config as it stands:
<add
name="ApplicationServices"
connectionString="data [code].....
For info the environments are set up as follows:
- Dev environment is vwd express 2010 with sqlite mdf attached
- Test environment is windows 7 server, iis 7 with appdomain identity set to network service
View 6 Replies
Jan 19, 2010
I have inherited an ASP.net website that was originally started back in 2007. I believe that a lot of the codebase was written in version 1.1, patched to 2.0 where necessary. The client is still not happy with some features and has requested changes to be made. In "peeling back the onion skin" I found that the codebase is rather outdated. I have asked and received approval to upgrade the entire application (website plus VB library) to ASP.net 3.5. Besides following the standard help instructions in VS 2008 and the advise of other posters on this site, can anyone direct me to specific resources to utilize in reviewing the 1.1/2.0 codebase and selecting the best 3.5 constructs that are most compatible? Do you favor the approach of converting the codebase in VS 2008, or do you start with a clean slate and copy/paste code where necessary? The original codebase uses Anthem and Free Textbox libraries. Do you favor upgrading these libraries to 3.5 where available, or are there other (free) libraries that will do a better job?
View 1 Replies