Search results for query: *

Thank you for the reply SQL Developer does have a feature that will display dependencies. It is also great to know how to do it with SQL also. I'm able to do the research that I required.

Is it possible to search in SQL Developer for where a view or packages is used? An example, view is view_a, I want to know all objects where view_a is mentioned. is this possible in SQL Developer search function? How?

It appears that the OracleXETNSListener is unable to start. When I did netstat, did not see port 8080. C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleXETNSListener The OracleXETNSListener service is starting. The OracleXETNSListener service could not be started. The...

I installed the Oracle Express 10g. When I click to "Go To Database Home Page", I get an error. Using Windowx XP w/ SP3 and IE 8. Error is standard IE8 error, "Diagnose Connections Problems" I'm able to ping 127.0.0.1. What steps should I do to resolve this issue?

I'm assume that "YourSheeName" is replace by the sheetname where the data is imported. Mot on sheet1 where sheet2 is referenced via VLookups I changed the name from Debug_Error I also received an error message on saving; about a macro-free workbook. Saved the workbook as a xlsm type. The...

Hope I did this correctly. Would not the drive letter depend on where the user has the network share drive mapped on their individual PC? Sub Debug_Error() ' ' Debug_Error Macro ' Macro recorded 1/6/2011 by bfhmem0 ' ' Range("A1").Select With Selection.QueryTable .Connection =...

The open and re-save file didn't have any affect. The path is: \\network_drive\Directory\filename. Didn't use a drive letter. example: \\networkdrivea\folder1\file1.csv

The csv file is the output of an Oracle job. I could understand if the it was only the users, but the senior programmer is also unable to access. On the properties tab of the file, I'm listed as the current owner. I believe that is the reason it is workign for me.

Using MS Office 2003. I created a workbook that contains 3 sheet. Sheet 1 retrieves data from sheet 2 and 3. Sheet 2 import data from an external csv file in the same directory as the workbook. When the workbook is open, the Query Refresh dialog box is displayed. When the "Enable...

I have a Console Application written is VB.Net 2005. I need to moved it to a server for QA testing. Should I publish it using the Publish Wizard or copy the .exe? If I publish it, after install is executed on the server, what do I execute in a scheduled task? Is it the .application member?

I have 2 VB.NET Console Applications that executed at different times from a web server. In most cases, the web server will not be logon. One of the console Applications executes daily at 5:30 am and the other every 25 minutes. It has been suggested to code a Windows Service to start these...

No, but I might not have the permission to perform the task. I do have it in another environment, that I used to code and test the app and it worked there. When I moved it to different environment is when it started failing. That is why I thought it was a permission issue.

I have a VB.Net (VS2005) Console Application. It is reference a csv file on a different server. At the end of the program it is require to copy the csv file to another directory on the other server and append the date to it for archive purpose. It then deletes the csv file. It is receiving...

Thank you for the reply. Yes, Session Variables are for ASP pages. I hoping that there is a way to get the database server name. Question on the Select suggestion from George. Doesn't it have to be connect to a database first? My problem is that I'm trying to find the server name, so that...

I have a VB.Net Console Application, it uses SQL Server. I have 4 SQL server/VB environments (DEv, QA, TrNg, Prod). I want to retrieve the SQL Server name from a session variable is available. How do I do this? The other alternative is to pass it in, but don't know how to do this when the...

I have a structure that contains variables (i.e. Name, Address, Cit, State, Zip, telephone). Is there a way to clear the structure with 1 command, like structure.clear? or must I clear each variable?

I'm new to VS 2005 using VB.Net. I found a free ware documenter program (GhostDoc) for VB. In using and viewing the results. I found that I have methods included from web references that I included into my project. Is there a way to exclude the methods used be references and web references...

DaveInIowa Thank you, that corrected the problem.

This is a newbie question. Is this possible? I want to group variables into something I'm able to pass to Sub modules. One module will load the variables the others will read and process based on the variables. I built a Structure. but after the load module ended the contents of the...

I noticed that I didn't mention that this has no UI (User Interface), it is a Console Application that executes once per day to update information on the database. I was hoping to write the config and never have to do it again for the 4 environments that we have. Thanks for the input