Not returning values?




I'm trying to do a count on the number of combinations of country/state codes that are invalid (in Australia) for driving licences.

Code: select COUNTRY_CODE, STATE_CODE, count(*) from (select COUNTRY_CODE, STATE_CODE from CUSTOMER_TABLE where DRIVING_LICENCE is not null and not (COUNTRY_CODE in ('AUST') AND STATE_CODE in ('VIC', 'NSW', 'SA', 'QLD', 'NT', 'TAS', 'WA', 'ACT'))) group by COUNTRY_CODE, STATE_CODE

The output is okay...for example I get these results:

INT INT
NZ SI
NZ INT
AUST INT
NZ NSW
NZ

However, what I am missing is the combination of "AUST" & for country/state respectively.

Am I writing the code correctly
Posted On: Monday 31st of December 2012 01:50:38 AM Total Views:  319
View Complete with Replies

RELATED TOPICS OF Oracle PROGRAMMING LANGUAGE




syntax for making the column as unique

I need help in finding out the syntax for adding unique constrant on the column. I have one column called username, which is NOT NULL already, but I also want this column to be unique(no duplicate). I could not find syntax which is working.
VIEWS ON THIS POST

310

Posted on:

Wednesday 7th November 2012
View Replies!

web server IIS issue - Oracle Related?

Hi Not too sure what forum to ask this in, but this problem may be Oracle Client Software related, so maybe someone on here has experience of this type of issue Approx. once a day (sometimes twice), the Intranet becomes unavailable as a result of IIS hanging. 90% of the time, restarting IIS fixes the problem. The crash logs and event viewer show nothing of importance, you just see entries for IIS being restarted but nothing before that. The problem seems to be unrelated to any particular webpage/site or activity/volume on the server. The problem mostly occurs between 2-3am when activity on the server is very low. The config of the web server is... Windows 2000 IIS 5.0 Oracle Client 8.1.7.0.0 MDAC 2.7 sp1 REFRESH Microsoft ODBC for Oracle driver Msorcl32.dll version 2.573.9030.00 Oracle ODBC driver SQORA32.dll version 8.01.07.00 SQL Server driver SQLSRV32.dll version 2000.81.9031.38 We have several ASP pages which access Oracle databases, one page even retrieves results from 4 different Oracle databases. We have come across the following Microsoft Knowledge article which exhibits our exact symptoms and points to the Oracle versions on the server. http://support.microsoft.com/default...b;en-us;253449 Has anybody experienced anything like this My apologies if this is not an Oracle Related Problem.
VIEWS ON THIS POST

192

Posted on:

Wednesday 7th November 2012
View Replies!

Rman report

In Rman, if you issue the command REPORT OBSOLETE and you get the report back, what does this mean Do you have to delete the record from tape Oisaya
VIEWS ON THIS POST

169

Posted on:

Wednesday 7th November 2012
View Replies!

Unique Constraints With Out having duplicate records. Or the other way round.

Hi , Please read this post fully ( Appriciate Ur Patientence ) PK_YTCURR exists on the coulmns (kurst, fcurr, tcurr, gdatu) of table YTCURR in both PRO and ACP. Code: WWCIW_DBA@WW15> truncate table wwciw_sap.ytcurr; Table truncated. WWCIW_DBA@WW15> copy from wwciw_dba@ww04 to wwciw_dba@ww15- > insert ytcurr- > using- > select * from ytcurr FROM TO Array fetch/bind size is 5000. (arraysize is 5000) Will commit after every 5 array binds. (copycommit is 5) Maximum long size is 80. (long is 80) SQLRCN in cpytbl failed: -1075 SQLRCN in cpyyerr failed: -1075 ERROR: ORA-00001: unique constraint (WWCIW_SAP.PK_YTCURR) violated WWCIW_DBA@WW15> select name from v$database; NAME --------- WW15 WWCIW_DBA@WW15> truncate table wwciw_sap.ytcurr; Table truncated. WWCIW_DBA@WW15> insert into ytcurr select * from ytcurr@ww04; 594951 rows created. -- Now it dosent error, Strange WWCIW_DBA@WW15> commit; Commit complete. Now i use some temp table to check if really duplicates exists. Code: WWCIW_DBA@WW15>truncate table temp_ytcurr; Table truncated. WWCIW_DBA@WW15>copy from wwciw_dba@ww04 to wwciw_dba@ww15- > insert temp_ytcurr- > using- > select * from ytcurr FROM TO Array fetch/bind size is 5000. (arraysize is 5000) Will commit after every 5 array binds. (copycommit is 5) Maximum long size is 80. (long is 80) SQLRCN in cpytbl failed: -1075 594951 rows selected from wwciw_dba@ww04. 594951 rows inserted into TEMP_YTCURR. 594951 rows committed into TEMP_YTCURR at wwciw_dba@ww15. WWCIW_DBA@WW15>select kurst, fcurr, tcurr, gdatu, count(1) from temp_ytcurr 2 group by kurst, fcurr, tcurr, gdatu 3 having count(1) > 1 4 / KURS FCURR TCURR GDATU COUNT(1) ---- ----- ----- -------- ---------- M GRD USD 19990320 2 P USD PTE 19960901 2 -- Now I Load into YTCURR(after truncating it) excluding these records WWCIW_DBA@WW15>Truncate table TEMP_YTCURR; Table truncated. WWCIW_DBA@WW15>insert into TEMP_YTCURR select * from YTCURR@ww04; 594951 rows created. WWCIW_DBA@WW15>select kurst, fcurr, tcurr, gdatu, count(1) from temp_ytcurr 2 group by kurst, fcurr, tcurr, gdatu 3 having count(1) > 1 4 / no rows selected -- Now begins the interesting part. WWCIW_DBA@WW15> ed Wrote file afiedt.buf 1 Select kurst, fcurr, tcurr, gdatu from 2 ( 3 select ltrim(rtrim(t.KURST)) Kurst, ltrim(rtrim(t.FCURR)) FCURR, ltrim(rtrim(t.TCURR)) TCURR, ltrim(rtrim(t.GDATU)) GDATU 4 from temp_ytcurr t 5 minus 6 select ltrim(rtrim(y.KURST)) Kurst, ltrim(rtrim(y.FCURR)) FCURR, ltrim(rtrim(y.TCURR)) TCURR, ltrim(rtrim(y.GDATU)) GDATU 7 from ytcurr y 8* ) WWCIW_DBA@WW15> / KURS FCURR TCURR GDATU ---- ----- ----- -------- M GRD USD 19990320 P USD PTE 19960901 -- AS Expected. WWCIW_DBA@WW15> ed Wrote file afiedt.buf 1 Select * from ytcurr where (kurst, fcurr, tcurr, gdatu) in 2 ( 3 Select kurst, fcurr, tcurr, gdatu from 4 ( 5 select ltrim(rtrim(t.KURST)) Kurst, ltrim(rtrim(t.FCURR)) FCURR, ltrim(rtrim(t.TCURR)) TCURR, ltrim(rtrim(t.GDATU)) GDATU 6 from temp_ytcurr t 7 minus 8 select ltrim(rtrim(y.KURST)) Kurst, ltrim(rtrim(y.FCURR)) FCURR, ltrim(rtrim(y.TCURR)) TCURR, ltrim(rtrim(y.GDATU)) GDATU 9 from ytcurr y 10 ) 11* ) 12 / no rows selected -- AS Expected. WWCIW_DBA@WW15> ed Wrote file afiedt.buf 1 Select * from ytcurr where (ltrim(rtrim(kurst)), ltrim(rtrim(fcurr)), ltrim(rtrim(tcurr)), ltrim(rtrim(gdatu))) in 2 ( 3 Select kurst, fcurr, tcurr, gdatu from 4 ( 5 select ltrim(rtrim(t.KURST)) Kurst, ltrim(rtrim(t.FCURR)) FCURR, ltrim(rtrim(t.TCURR)) TCURR, ltrim(rtrim(t.GDATU)) GDATU 6 from temp_ytcurr t 7 minus 8 select ltrim(rtrim(y.KURST)) Kurst, ltrim(rtrim(y.FCURR)) FCURR, ltrim(rtrim(y.TCURR)) TCURR, ltrim(rtrim(y.GDATU)) GDATU 9 from ytcurr y 10 ) 11* ) WWCIW_DBA@WW15> / no rows selected -- Can expect it. WWCIW_DBA@WW15> select * from ytcurr where kurst like '%M%' and FCURR like '%GRD%' and TCURR like '%USD%' 2 and GDATU like '%19990320%'; MAN KURS FCURR TCURR GDATU UKURS FFACT TFACT CYDT CYTM XTFLNM --- ---- ----- ----- -------- ---------- ---------- ---------- -------- ------ ---------- 155 M GRD USD 19990320 .00339 1 1 19990319 235900 CENA01 155 MV GRD USD 19990320 .00339 1 1 19990319 235900 CENA01 -- Jus see the first record it indeed exists in main table YTCURR. This is were i am confused WWCIW_DBA@WW15> ed Wrote file afiedt.buf 1 select * from temp_ytcurr where kurst like '%M%' and FCURR like '%GRD%' and TCURR like '%USD%' 2* and GDATU like '%19990320%' WWCIW_DBA@WW15> / MAN KURS FCURR TCURR GDATU UKURS FFACT TFACT CYDT CYTM XTFLNM --- ---- ----- ----- -------- ---------- ---------- ---------- -------- ------ ---------- 155 M GRD USD 19990320 .00339 1 1 19990319 235900 CENA01 155 MV GRD USD 19990320 .00339 1 1 19990319 235900 CENA01 -- IN Temp Table we have same records. More confused I suspect some special characters to be present in a record, but again its not showing up with search by using like predicate '%--%' Please help Abhay.
VIEWS ON THIS POST

231

Posted on:

Wednesday 7th November 2012
View Replies!

Oracle/ColdFusion/bind variables

Folks, Im trying to resolve the performance issue related to ColdFusion and dynamic list of variables in IN-list clause for various SQL statements. ColdFusion is not very good with bind variables and after several attempts developers made a decision not to use them. As a result, database is flooded with a bunch of similar SQL statements with the only difference in IN clause. The result high latch waits/contention and poor overall performance. The solution get back to bind variables. Do you know what be the best approach to it Unfortunately, I dont have a lot of experience in this area. Your help will be greatly appreciated.
VIEWS ON THIS POST

164

Posted on:

Wednesday 7th November 2012
View Replies!

TO Rohitsn

Mr. rohitsn Let me know more abaut this prompt tkyte@THINK1.US.ORACLE.COM> Who do you configuew this prompt and if i do another connection wiht other user and database the prompt change for the new user connected e new database\t
VIEWS ON THIS POST

99

Posted on:

Wednesday 7th November 2012
View Replies!

RMAN: what if you use Veritas Net Backup?

For our backups, we use Veritas Net Backup to establish a connection with a remote server and cut the backup tapes on that server. I was wondering if RMAN supports that kind of configuration, or if you have to cut tapes on the source server Does anybody currently use RMAN and have their backup tapes cut on a remote server
VIEWS ON THIS POST

131

Posted on:

Wednesday 7th November 2012
View Replies!

qq...how do you keep objects in RAC instance

qq...I just wanted to confirm that in order to pin objects in the shared pool in a Rac database, I need to pin in all the instances or just run once for any of the instance. I thought it was for all the instances...just confirming.
VIEWS ON THIS POST

158

Posted on:

Wednesday 7th November 2012
View Replies!

suggestion required

Can anybody suggest me for this problem Here we have Oracle 8i on Windows NT set up. I run the following Query to check how many number of times full table scan is taking place and got the following result select name,value from v$sysstat where name='table scans(long tables)'; name value table scans(long tables) 24519 The value for the Parameter DB_FILE_MULTIBLOCK_READ_COUNT is 16 My question is should I increase this value for the better performance.How much should I increaseWhat is the maximum limit for this parameter in Windows NT environment.
VIEWS ON THIS POST

222

Posted on:

Wednesday 7th November 2012
View Replies!

pctfree - chained rows

I need to increase the pctfree on a couple of tables with lots of updates, currently set at the default value. Is this alright to change via DBA studio while the database is up and running
VIEWS ON THIS POST

154

Posted on:

Wednesday 7th November 2012
View Replies!

Partitioning Doubt ???

Row-wise partitioning is possible. However, what about column-wise partioning. Is this possibe
VIEWS ON THIS POST

109

Posted on:

Wednesday 7th November 2012
View Replies!

Question about Memory used by process id

This could be a common question- When I use the top command on the Unix systems, I get a report like below 9811 oracle 11 59 0 172M 133M sleep 0:23 0.00% oracle 9844 oracle 11 58 0 171M 133M sleep 0:33 0.00% oracle 9854 oracle 11 58 0 171M 137M sleep 0:00 0.00% oracle 9852 oracle 11 59 0 171M 133M sleep 0:00 0.00% oracle 9821 oracle 1 58 0 170M 131M sleep 0:00 0.00% oracle 9823 oracle 1 59 0 170M 131M sleep 0:00 0.00% oracle 9842 oracle 105 58 0 169M 135M sleep 0:08 0.00% oracle 9809 oracle 54 59 0 169M 134M sleep 0:12 0.00% oracle 9813 oracle 22 58 0 168M 134M sleep 8:00 0.00% oracle 9846 oracle 16 58 0 168M 133M sleep 6:50 0.01% oracle 27284 oracle 11 59 0 167M 129M sleep 0:00 0.00% oracle 9840 oracle 1 59 0 166M 133M sleep 0:00 0.00% oracle 9807 oracle 1 58 0 166M 133M sleep 0:00 0.00% oracle I want to know as to why should I get all the processes showing the same memory usage. 1) Does the above memory (eg: 171M,168M etc really used by Oracle processes like smon,pmon etc) 2) How do we relate each process to the actual task.. for example top gives me the above output and I need to run ps -ef |grep pid to get the actuall process. Is there a command to combine both. Any hints/clarification are helpful.
VIEWS ON THIS POST

157

Posted on:

Wednesday 7th November 2012
View Replies!

Role Based Authorization

I have seen articles on Role Based Authorization in MS-Sql server-Asp.net but i did not find any article in MySql-ASP.net/vb.net, can any one help metodevelop.i am acheived this cpncept using session user namei am enabling certain parts of website to group Aand certain parts of site to GroupB but when i have more groups i cannot use this method. Myrequirement is\t In Web applications, typically there exist certain parts of the site that only certain folks, or groups of persons can access. For example, imagine Web site used to administer the content on a company's public Internet Web site, where the public Web site lists products sold by the company. From the administrative site, all company employees might be able to make minor changes to the products' descriptions, quantity, and other such non-essential information. However, perhaps only a subset of trusted employees might be able to change the products' prices. And even a smaller subset of employees would be able to add new products or delete existing products from the database I would be delighted if any one provide the solution
VIEWS ON THIS POST

110

Posted on:

Wednesday 7th November 2012
View Replies!

VB.net help

Ok i'm teaching myself VB.Net now and atm I have 1 form with 2 text boxes labelled "Username" and "Password" These are called UsernameTextBox and PasswordTextBox. There is also 2 buttons. One button is "Register" which I have working perfectly fine. It takes the username and password from the text boxes and adds them to a remote mysql database. Now the other button is the login which is designed to login using info FROM mysql. ImportsMySql.Data.MySqlClient PublicClassLoginWindow DimconnectionStringAsString="Database=DATABASENAME;DataSource=HOST;UserId=USERNAMEFORDATABASE;Password=DBPASSWORD;ConnectionTimeout=30" DimconnectionAsNewMySqlConnection(connectionString) PrivateSubLoginWindow_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load EndSub PrivateSubRegisterButton_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesRegisterButton.Click DimInsertQryAsString="INSERTINTOMembers(Username,Password)VALUES('"+UsernameTextBox.Text+"','"+PasswordTextBox.Text+"')" DimSendQryAsNewMySqlCommand(InsertQry,connection) DimQryResultAsInteger=0 connection.Open() QryResult=SendQry.ExecuteNonQuery() connection.Close() MsgBox("UserCreated!NowLogin!") Try CatchexAsException MsgBox(ex.Message) EndTry EndSub PrivateSubLoginButton_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesLoginButton.Click DimLoginQryAsString="SELECTPasswordFROMMembersWHEREUsername="+UsernameTextBox.Text+"" DimSendQryAsNewMySqlCommand(LoginQry,connection) DimResultAsDataTable DimadapterAsNewMySqlDataAdapter connection.Open() SendQry.ExecuteNonQuery() adapter.SelectCommand=SendQry adapter.Fill(Result) connection.Close() IfResult=PasswordTextBox.TextThen MsgBox("LoginSuccessful") Else MsgBox("LoginFailed") EndIf EndSub EndClass That is the full code. Now I need the very last bit to work which is the compare password but I don't know how to check the single cell for the correct password needed. Also It returns a huge error If i type in a username that is not in the database and crashes the program [code] Unknown column 'john' in 'where clause' [/code] Errors Returned: A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll System.Transactions Critical: 0 : http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/UnhandledUnhandled exceptionLightSysMessenger.vshost.exeMySql.Data.MySqlClient.MySqlException, MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44dUnknown column 'john' in 'where clause' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() \t at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) \t at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) \t at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) \t at MySql.Data.MySqlClient.MySqlDataReader.NextResult() \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() \t at LSMessenger.LoginWindow.LoginButton_Click(Object sender, EventArgs e) in C:\Users\Rayth\AppData\Local\Temporary Projects\WindowsApplication1\Login.vb:line 39 \t at System.Windows.Forms.Control.OnClick(EventArgs e) \t at System.Windows.Forms.Button.OnClick(EventArgs e) \t at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) \t at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) \t at System.Windows.Forms.Control.WndProc(Message& m) \t at System.Windows.Forms.ButtonBase.WndProc(Message& m) \t at System.Windows.Forms.Button.WndProc(Message& m) \t at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) \t at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) \t at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) \t at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) \t at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) \t at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) \t at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun() \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel() \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine) \t at LSMessenger.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 \t at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) \t at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) \t at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() \t at System.Threading.ThreadHelper.ThreadStart_Context(Object state) \t at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) \t at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) \t at System.Threading.ThreadHelper.ThreadStart()MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'john' in 'where clause' \t at MySql.Data.MySqlClient.MySqlStream.ReadPacket() \t at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) \t at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) \t at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) \t at MySql.Data.MySqlClient.MySqlDataReader.NextResult() \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() \t at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() \t at LSMessenger.LoginWindow.LoginButton_Click(Object sender, EventArgs e) in C:\Users\Rayth\AppData\Local\Temporary Projects\WindowsApplication1\Login.vb:line 39 \t at System.Windows.Forms.Control.OnClick(EventArgs e) \t at System.Windows.Forms.Button.OnClick(EventArgs e) \t at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) \t at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) \t at System.Windows.Forms.Control.WndProc(Message& m) \t at System.Windows.Forms.ButtonBase.WndProc(Message& m) \t at System.Windows.Forms.Button.WndProc(Message& m) \t at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) \t at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) \t at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) \t at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) \t at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) \t at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) \t at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun() \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel() \t at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine) \t at LSMessenger.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 \t at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) \t at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) \t at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() \t at System.Threading.ThreadHelper.ThreadStart_Context(Object state) \t at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx) \t at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) \t at System.Threading.ThreadHelper.ThreadStart()Server Error Code1054
VIEWS ON THIS POST

141

Posted on:

Wednesday 7th November 2012
View Replies!

Using Database Explorer without installing drivers

Hi! I use Visual Studio with a computer where I don't have any administrator rights so I'm not able to install anything. I would like to see the database in the Server Explorer like in this tutorial http://www.asp.net/learn/data-access/tutorial-01-cs.aspx. On my private computer I have installed a MySQl ODBC Driver. Then it is easy to get visual Studio to show it in the Database Explorer after adding a connection to the ODBC Data Source Administrator in the Control Panel. Is there a way to get my database to show up in the Datebase Explorer without installing any drivers ... or is it, as an alternative, possible to use the dataset files (.xsd) and their simple design view when connecting to the database programmatically; adding the connectors dll file in the bin folder of my project and connect the old fashion way (if this is understandable) ... or do I simply have to realize that it's not possible... Does anyone have anything to say
VIEWS ON THIS POST

241

Posted on:

Wednesday 7th November 2012
View Replies!

Cannot find Oracle.DataAccess.dll

I have installed Oracle9i on my server and the Orcal9i client on my machine and I cannot find the Oracle.DataAccess.dll file. Where should it be
VIEWS ON THIS POST

178

Posted on:

Wednesday 7th November 2012
View Replies!

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'.

everybody. I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error : MicrosoftOfficeExcelcannotaccessthefile'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'.Thereareseveralpossiblereasons: \tThefilenameorpathdoesnotexist. \tThefileisbeingusedbyanotherprogram. \tTheworkbookyouaretryingtosavehasthesamenameasacurrentlyopenworkbook. At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required. Please help. I am in great trouble.
VIEWS ON THIS POST

249

Posted on:

Wednesday 7th November 2012
View Replies!

Trying to Connect to Informix from asp.net

Hi , I am trying to connect informix using oledb from .NET. First of all let me tell my requirements: I dont want to buy any licensed software for just this connection to informix. Informix DB instance belongs to thirdparty.My application just pul the Data. I know the credentials to connect to this. I cannot use ODBC b'se of maintenance work on production server by their team. So i am interested to use OLEDB so that application doesn't required to maintain any other software for this connection purpose. Is it possible with Microsoft .NET framework with its default drivers/providers. I did some research and what i felt was it is not possible to connect to informix with out having any IBM trusted provider. That is IBM Informix Client SDK. But i want to know is this licensed software. Is itavailable for free. I downloaded IBM Informix client SDK (clientsdk.3.50.TC3DE.WIN.zip) from some link on web and tried to link. Am not sure is this trail version or ..But when i tried to connect using VS2005 server explorer, Data Source: ; Data Provider: .NET Framework Daat Provider for OLE DB; OLE DB Provider: IBM Informix OLE DB Provider; Server: xyz; Username:x1;Password: P1; With all this test connection is successful buti cant see the Tables list. giving message as "Attempted to read or write protected memory.". Any body help me in this regard.
VIEWS ON THIS POST

117

Posted on:

Wednesday 7th November 2012
View Replies!

mySQL connector/net will work in development but not on webserver...help

hello, i got mySQL connector/net v6.0 to finally work on my development computer. I uploaded the asp/vb page to my webserver, along with an added assembly reference in my web.config and updated the bin folder on the webserver, however i am gettting the error 'MySqlCommand' is ambiguous in the namespace 'MySql.Data.MySqlClient'. anyone know how i can fix this my web.config looks like this \t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t\t \t \t \t\t\t \t\t\t \t \t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t\t \t\t\t\t
VIEWS ON THIS POST

193

Posted on:

Wednesday 7th November 2012
View Replies!

cannot access oracle throught SQL SOURCE

I am trying to access Oracle 10g DB throught asp.net. I have downloaded and isntalled ODP, In my code behind i have using Oracle.DataAccess.Client; I have a gridview and want to access data and allow it to be deleted/updated/selected. I was using System.Data.OracleClient, this would select data fine but when it comes to updating it wouldnt work, i keep getting the 'ORA-01036: illegal variable name/number error. I read up on a few baords which suggested using providerName="Oracle.DataAccess.Client", i have tried changing my connections in my web.config file from providerName="System.Data.OracleClient"\tto providerName="Oracle.DataAccess.Client", however when i add a SQLSOURCE to my aspx page,. it is not showing the web.config connections in my list. now i have addded Oracle.DataAccess.dll to my project in the Bin directory, it is also located on C:\oraclexe\app\oracle\product\10.2.0\server\BIN I am using VS 2005 and .net 2.0 am i missing something else
VIEWS ON THIS POST

205

Posted on:

Wednesday 7th November 2012
View Replies!

Excel Automation Reference Not Valid Error in PIVOT

Hi all, I created a webpage using ASP .NET for Excel 2010 automation. I did the following Created one excel file with 2 sheets. Sheet1 - Data (Formatted as Table) Sheet2 - PIVOT (Refers the Table in Sheet1) I am populating the data in Sheet1 using Excel Objects and allowing the file to be downloadable by user. It opens up and shows the data perfectly and PIVOT also, but there is one problem, when the user refreshes or filters the PIVOT, it says reference not valid, Please let me know what to do to avoid this.
VIEWS ON THIS POST

110

Posted on:

Wednesday 7th November 2012
View Replies!

Trigger not firing

DBA's I have created a trigger on update, insert and delete on a table to insert a row into an audit table. When in sql plus and I perform any insert,update and delete the trigger fires as required. When the update is performed from a web based application the trigger does not fire. Has anyone else out there experienced a similar problem If so what can I try to resolve the issue.
VIEWS ON THIS POST

97

Posted on:

Thursday 15th November 2012
View Replies!

parameter must be defined error on mysql with c#

the below code gives Parameter '@row' must be defined error on filling data adaptor what is wrong with my code ... best regards \t\t\t StringBuilder sql = new StringBuilder(); \t\t\t sql.Append("SET @row:=0;"); \t\t\t sql.Append("SELECT * From ("); \t\t\t sql.Append("Select @row:=@row+1 As Rec_No, _Col1, _Col2"); \t\t\t sql.Append("From _Tab1) As _T1"); \t\t\t sql.Append("WHERE Rec_No > 1 And Rec_No
VIEWS ON THIS POST

666

Posted on:

Tuesday 20th November 2012
View Replies!

OracleProfileProvider

Does anyone have a working example of how to use the OracleProfileProvider\t I have been hunting and pecking for two days and can't find any solid examples (even on Oracle's site).
VIEWS ON THIS POST

69

Posted on:

Tuesday 20th November 2012
View Replies!

Connects to oracle database in debugging mode but doesn't when hosted on IIS

all, I have an application that connects to oracle 9.2 remote database and retrieves data on the ASP development server (debugging) but once i publish the website and host it on IIS it doesn't connect. Everything is done under one username without administrator privileges. If i change the account to a username with admin access even in the debugging phase, the application won't connect to the oracle database. Is there some admin variable i have to change so this admin user can access the remote database as well This application is running on VS 2005. Thank you for your help
VIEWS ON THIS POST

228

Posted on:

Tuesday 20th November 2012
View Replies!

Excel - Format of the initialization string does not conform to specification starting at index...

... I'm trying to retreive info from a Excel file (Office XP) but I keep getting the same ERROR over and over again.I cant seem to get the connectionString to GET the Excel file. The ERROR is: Format of the initialization string does not conform to specification starting at index 48... Here's my code: public static List GetInfo() { \t\t\t\t\t string filename = "@C:\File.xls"; \t\t\t\t\t string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+filename+";Extended Properties=Excel 9.0;"; \t\t\t\t\t \t\t\t\t\t DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"); \t\t\t\t\t List returnList = new List(); \t \t\t\t\t\t using (DbConnection connection = factory.CreateConnection()) \t\t\t\t\t { \t\t\t\t\t\t\t connection.ConnectionString = connectionString;\t\t //Here's where the ERROR occurs \t\t\t\t\t\t\t \t\t\t\t\t\t\t using (DbCommand command = connection.CreateCommand()) \t\t\t\t\t\t\t { \t\t\t\t\t\t\t \t .......... \t \t \t \t \t \t .......... \t\t\t\t\t\t\t\t\t .......... I've searched the net, i've been at this for hours, i'm loosing my pacience [:P] I've seen that this error has occured to a lot of people but their solutions haven't helped at all [:^)] Can someone please help me out
VIEWS ON THIS POST

457

Posted on:

Tuesday 20th November 2012
View Replies!

PL/SQL PROCEDURE using Cursor Loops and SINGLE PARAMETER

**
VIEWS ON THIS POST

166

Posted on:

Saturday 29th December 2012
View Replies!