Help! Newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
Any ideas(Resolutions)?
Thanks,,,,
Might want to try an Oracle newsgroup...this is for Microsoft SQL
Server...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:uW3na2p0FHA.2924@.TK2MSFTNGP15.phx.gbl...
> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)?
> Thanks,,,,
>
>

Help! Newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
Any ideas(Resolutions)'
Thanks,,,,Please do not multi-post.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:eUoysqp0FHA.3660@.TK2MSFTNGP15.phx.gbl...
> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)'
> Thanks,,,,
>
>|||> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)'
I'm afraid this is not Oracle group. This is MS SQL Server group.
Look for comp.database.oracle subgroups.
It's not a client application issue, so do not post it in client
subgroups.
As far as I know there's no way to get that password, but there
may be a way to log in without that password and to reset that
password to a new one (there is in Oracle 8i), but I do not know how.
You could probably also try uninstalling the server and reinstalling it.
Hilarion

Help! Newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I creat
ed
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActio
ns2005-10-09_04-22-59PM
Any ideas(Resolutions)'
Thanks,,,,Please do not multi-post.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:eUoysqp0FHA.3660@.TK2MSFTNGP15.phx.gbl...
> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I cre
ated
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActio
ns2005-10-09_04-22-59PM
> Any ideas(Resolutions)'
> Thanks,,,,
>
>|||> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I cre
ated
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActio
ns2005-10-09_04-22-59PM
> Any ideas(Resolutions)'
I'm afraid this is not Oracle group. This is MS SQL Server group.
Look for comp.database.oracle subgroups.
It's not a client application issue, so do not post it in client
subgroups.
As far as I know there's no way to get that password, but there
may be a way to log in without that password and to reset that
password to a new one (there is in Oracle 8i), but I do not know how.
You could probably also try uninstalling the server and reinstalling it.
Hilarion

Help! Newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
Any ideas(Resolutions)?
Thanks,,,,
Please do not multi-post.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:eUoysqp0FHA.3660@.TK2MSFTNGP15.phx.gbl...
> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)?
> Thanks,,,,
>
>
|||> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)?
I'm afraid this is not Oracle group. This is MS SQL Server group.
Look for comp.database.oracle subgroups.
It's not a client application issue, so do not post it in client
subgroups.
As far as I know there's no way to get that password, but there
may be a way to log in without that password and to reset that
password to a new one (there is in Oracle 8i), but I do not know how.
You could probably also try uninstalling the server and reinstalling it.
Hilarion

Help! newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
Any ideas(Resolutions)?
Thanks,,,,
On Sun, 16 Oct 2005 16:55:23 -0400, Taishi wrote:

>Situation: 1st time using Oracle for a training class. 1st install
(snip)
>Any ideas(Resolutions)?
Hi Taishi,
Try posting to one Oracle group, instead of three Microsoft SQL Server
groups.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:rgi5l1p68vbavfo3917ahah72pstq2f34a@.4ax.com...
> On Sun, 16 Oct 2005 16:55:23 -0400, Taishi wrote:
> (snip)
> Hi Taishi,
> Try posting to one Oracle group, instead of three Microsoft SQL Server
> groups.
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
Thanks.. Hugo..
I'm just trying to get an answer ASAP... I still don't have one...
Any ideas?
Taishi
|||On Sun, 16 Oct 2005 17:01:11 -0400, Taishi wrote:

>I'm just trying to get an answer ASAP... I still don't have one...
>Any ideas?
Yeah - stop spamming groups that have nothing to do with Oracle. I just
saw that you posted the same message to yet another two SQL Server
groups. You're wasting bandwith, wasting your time and wasting the time
of all people who are giving their time to help others.
You WON'T get an answer here. These groups are for SQL Server, a
Microsoft product. PLEASE take your questions on Oracle products to the
Oracle groups.
Here are some useful links for you:
http://www.aspfaq.com/etiquette.asp?id=5003
http://www.aspfaq.com/etiquette.asp?id=5004
http://www.aspfaq.com/etiquette.asp?id=5005
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
sql

Help! Newbie

Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
miserably. Panicing..
I can see the id in the logs.
Will the password be in the Logs?
C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
Any ideas(Resolutions)?
Thanks,,,,
Please do not multi-post.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:eUoysqp0FHA.3660@.TK2MSFTNGP15.phx.gbl...
> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)?
> Thanks,,,,
>
>
|||> Situation: 1st time using Oracle for a training class. 1st install
> Problem:
> I just went through the instructions for " Installing the Oracle9i
> Database[1]". My problem is that I don't remember the passwords I created
> and I'm following the instructions for loggin in... I am failing
> miserably. Panicing..
> I can see the id in the logs.
> Will the password be in the Logs?
> C:\Program Files\Oracle\Inventory\logs\installActions2005-10-09_04-22-59PM
> Any ideas(Resolutions)?
I'm afraid this is not Oracle group. This is MS SQL Server group.
Look for comp.database.oracle subgroups.
It's not a client application issue, so do not post it in client
subgroups.
As far as I know there's no way to get that password, but there
may be a way to log in without that password and to reset that
password to a new one (there is in Oracle 8i), but I do not know how.
You could probably also try uninstalling the server and reinstalling it.
Hilarion

HELP! - Cast from DBNull when there is Data

Hi,

I have built a few pages and a stored procedure and a class on the back of a SQL2000 dbase. and I get the following error:

Cast from type 'DBNull' to type 'String' is not valid.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.InvalidCastException: Cast from type 'DBNull' to type 'String' is not valid.

Source Error:

Line 111: Dim myWorkJobs As WorkJobsDATA = New WorkJobsDATALine 112:Line 113: myWorkJobs.CustomerID = CStr(parameterCustomerID.Value)Line 114: myWorkJobs.WorkID = CStr(parameterWorkID.Value)Line 115: myWorkJobs.DateOfQuote = CStr(parameterDateOfQuote.Value).Trim()

Source File:C:\Inetpub\wwwroot\Commerce\Components\WorkJobs.vb Line:113

My Database has 1 line of data (for testing) and all fields are populated. I am Querying a column called IndividualID which has a value of 3425243 at the moment. This is hardcoded in the aspx.vb at the moment.

ASPX VB:

Public Class WorkRequest
Inherits System.Web.UI.Page

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
End Sub

Private Sub btnEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnter.Click

'for now, send this value (stored in dbase under individualID) to the querystring

Dim IndividualID As String = "3425243"

Response.Redirect("WorkRequestMain.aspx?IndividualID=" & IndividualID)
End Sub
End Class

COMPONENTS\WorkJobs.vb (This is the class file)

Imports System
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient

Namespace ASPNET.StarterKit.Commerce

Public Class WorkJobsDATA

Public CustomerID As String
Public WorkID As String
Public DateOfQuote As String
Public QuoteAmount As String
Public Title As Decimal
Public FirstName As String
Public Surname As String
Public FirstLine As String
Public District As String
Public Town As String
Public Postcode As String
Public Telephone As String
Public Requirements As String
Public WorkRequired As String
Public EmailAddress As String

End Class

Public Class WorkJobs

Public Function GetWorkDetails(ByVal IndividualID As String) As WorkJobsDATA

Dim myConnection As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim myCommand As SqlCommand = New SqlCommand("SP_PendingQuotes", myConnection)

' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure

' Add Parameters to SPROC
Dim parameterIndividualID As SqlParameter = New SqlParameter("@.IndividualID", SqlDbType.NVarChar, 50)
parameterIndividualID.Value = IndividualID
myCommand.Parameters.Add(parameterIndividualID)

Dim parameterCustomerID As SqlParameter = New SqlParameter("@.CustomerID", SqlDbType.BigInt, 8)
parameterCustomerID.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterCustomerID)

Dim parameterWorkID As SqlParameter = New SqlParameter("@.WorkID", SqlDbType.NVarChar, 50)
parameterWorkID.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterWorkID)

Dim parameterDateOfQuote As SqlParameter = New SqlParameter("@.DateOfQuote", SqlDbType.DateTime, 8)
parameterDateOfQuote.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterDateOfQuote)

Dim parameterQuoteAmount As SqlParameter = New SqlParameter("@.QuoteAmount", SqlDbType.Money, 8)
parameterQuoteAmount.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterQuoteAmount)

Dim parameterTitle As SqlParameter = New SqlParameter("@.Title", SqlDbType.NVarChar, 50)
parameterTitle.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterTitle)

Dim parameterFirstName As SqlParameter = New SqlParameter("@.FirstName", SqlDbType.NVarChar, 50)
parameterFirstName.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterFirstName)

Dim parameterSurname As SqlParameter = New SqlParameter("@.Surname", SqlDbType.NVarChar, 50)
parameterSurname.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterSurname)

Dim parameterFirstLine As SqlParameter = New SqlParameter("@.FirstLine ", SqlDbType.NVarChar, 50)
parameterFirstLine.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterFirstLine)

Dim parameterDistrict As SqlParameter = New SqlParameter("@.District", SqlDbType.NVarChar, 50)
parameterDistrict.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterDistrict)

Dim parameterTown As SqlParameter = New SqlParameter("@.Town", SqlDbType.NVarChar, 50)
parameterTown.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterTown)

Dim parameterPostcode As SqlParameter = New SqlParameter("@.Postcode", SqlDbType.NVarChar, 50)
parameterPostcode.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterPostcode)

Dim parameterTelephone As SqlParameter = New SqlParameter("@.Telephone", SqlDbType.NVarChar, 50)
parameterTelephone.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterTelephone)

Dim parameterRequirements As SqlParameter = New SqlParameter("@.Requirements", SqlDbType.NVarChar, 3500)
parameterRequirements.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterRequirements)

Dim parameterWorkRequired As SqlParameter = New SqlParameter("@.WorkRequired", SqlDbType.NVarChar, 3500)
parameterWorkRequired.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterWorkRequired)

Dim parameterEmailAddress As SqlParameter = New SqlParameter("@.EmailAddress", SqlDbType.NVarChar, 100)
parameterEmailAddress.Direction = ParameterDirection.Output
myCommand.Parameters.Add(parameterEmailAddress)

myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()

parameterEmailAddress.Value.GetType()

Dim myWorkJobs As WorkJobsDATA = New WorkJobsDATA

myWorkJobs.CustomerID = CStr(parameterCustomerID.Value)
myWorkJobs.WorkID = CStr(parameterWorkID.Value)
myWorkJobs.DateOfQuote = CStr(parameterDateOfQuote.Value).Trim()
myWorkJobs.Title = CStr(parameterTitle.Value).Trim()
myWorkJobs.FirstName = CStr(parameterFirstName.Value).Trim()
myWorkJobs.Surname = CStr(parameterSurname.Value).Trim()
myWorkJobs.FirstLine = CStr(parameterFirstLine.Value).Trim()
myWorkJobs.District = CStr(parameterDistrict.Value).Trim()
myWorkJobs.Town = CStr(parameterTown.Value).Trim()
myWorkJobs.Postcode = CStr(parameterPostcode.Value).Trim()
myWorkJobs.Telephone = CStr(parameterTelephone.Value).Trim()
myWorkJobs.Requirements = CStr(parameterRequirements.Value).Trim()
myWorkJobs.WorkRequired = CStr(parameterWorkRequired.Value).Trim()
myWorkJobs.EmailAddress = CStr(parameterEmailAddress.Value).Trim()

Return myWorkJobs

End Function

End Class
End Namespace

And finally my stored procedure:

CREATE Procedure SP_PendingQuotes
(
@.IndividualID nvarchar,
@.CustomerID bigint OUTPUT,
@.WorkID nvarchar(50) OUTPUT,
@.DateOfQuote datetime OUTPUT,
@.QuoteAmount money OUTPUT,
@.Title nvarchar(50) OUTPUT,
@.FirstName nvarchar(50) OUTPUT,
@.Surname nvarchar(50) OUTPUT,
@.FirstLine nvarchar(50) OUTPUT,
@.District nvarchar(50) OUTPUT,
@.Town nvarchar(50) OUTPUT,
@.Postcode nvarchar(50) OUTPUT,
@.Telephone nvarchar(50) OUTPUT,
@.Requirements nvarchar(3500) OUTPUT,
@.WorkRequired nvarchar(3500) OUTPUT,
@.EmailAddress nvarchar(100) OUTPUT
)
AS

SELECT
@.IndividualID = IndividualID,
@.CustomerID = CustomerID,
@.WorkID = WorkID,
@.DateOfQuote = DateOfQuote,
@.QuoteAmount = QuoteAmount,
@.Title = Title,
@.FirstName = FirstName,
@.Surname = Surname,
@.FirstLine = FirstLine,
@.District = District,
@.Town = Town,
@.Postcode = Postcode,
@.Telephone = Telephone,
@.Requirements = Requirements,
@.WorkRequired = WorkRequired,
@.EmailAddress = EmailAddress

FROM
PendingQuotes

WHERE
IndividualID = @.IndividualID
GO

Any ideas anyone?

I appreciate this is a big amount of data, but if anyone wants to chat to me i'm available on MSN Messenger underwolvokid@.msn.com

The problem is in the stored procedure, you've defined @.IndividualID as nvarchar, specify the length, as it is defaulting to 1. Your query then returns no values because there is no record where IndividualID='3'|||

Call me muppett! It all becomes a blur after you go over and over everything a million times trying to find out whats wrong.

Thanks very much. It works now!