Search:
Type: Posts; User: ducky
Search:
Search took 0.07 seconds.
-
Looks like maybe your missing quotes in the parameter field name, thus causing the subscript out of range. Try
rpt.ParameterFields("bill_amt").Value = Text5.Text
-
the crSilver, etc conditional formatting only works in the background or border color formula editors. Is that where you are placing the formula?
-
To limit the number of records per page use a formula along with the Section Expert.
Go to the Section Expert for the Details section, click the formula button for New Page After and use a formula...
-
Tried the SSPI connection string, and it still occurs. I switched the code over to use the Oracle ODP.Net provider and the same phenomenon happens. So my assumption is it is not a bug with the...
-
Thanks mendhak. I was able to get our DBA to do an audit as you suggested. It appears the application is trying initially to logon with the os user 'NT Authority\Anonymous Logon' from the web server...
-
Has anyone had success implementing an ASP.NET 2.0 appliction to use windows authentication via Micorosoft's trusted subsystem model to connect to an Oracle database? I have the model working for our...
-
It may be that the printer that the report was designed with is not found in your local printers on your machine. Try setting the printer to a valid printer to print to via code just before the...
-
If i recall correctly the dll specified should be "crdb_odbc.dll" for ODBC connections. Try it out.
-
Yes I would say believe your source. If you purchase any of the developer editions, those always include the components to integrate with development tools such as visual studio. The free crystal...
-
Did you uninstall the pro version before installing R2? Or did it ask you about it before letting you install? I seem to remember something about needing a clean install. Its been a while since I...
-
If you purchased a separate copy of Crystal XI as you say you have, then you may be able to download the XI R2 from their web site and install. Its available, just check the licensing restriction. I...
-
I use the MS .NET Oracle Data Provider (System.Data.OracleClient) for connecting to Oracle and selecting data from stored procedures just fine by setting the OracleCommand.CommandText to the...
-
If you have 2005 at work you may be able to install it at home too. Check the eula which may say you can install at home too. However since your company licensed it to you, if you're thinking of...
-
You could create a "Linked Server" in your SQL Server database that establishes a connection to your Oracle server. Then in your stored procedure do a query against the linked server connection, and...
-
If you just want to show a quick message as such, you can just create a shortcut to the shutdown.exe. This allows you to shutdown windows and accepts an optional parameter for adding a comment...
-
Create a Running Total Field. The field to summarize should be the field you are grouping by and the type of summay should be count. The running total should be set to evaluate on change of the group...
-
I never use a number other than 0 in the resultset. It will return all records into the recordset fine. No need to get fancy with the resultset notation. In fact I always define the first parameter...
-
I don't think so. I've always put my sys_refcursor as the first parameter in my procedures and don't recall any troubles otherwise.
-
Ok, I've included code below that works using you variable names, etc. To answer your questions, the cursor does not need to be an IN OUT, OUT is good enough. I do not use the OraOLEDB.Oracle driver,...
-
I upgrade my VS2003 with Crystal 10 by using the Crystal 10 Developer CD and chosing the option Install .NET Components. Does your Crystal 11 cd have something similar?
-
The trouble is the datafield is null and the formula does not know how to handle it. You can solve this in a couple of ways
1) Go into File/Report Options and check Convert Database NULL Values to...
-
I reviewed some of my web code that has this exact script/src tag. By viewing the web server log files you can clearly see it listed as a separate GET. However if multiple pages use the same...
-
I'm guessing in your formula was interpreted as a string now because you added the "-" in the formula by using a string concatenation like "-" & yournumber. You need to create a formula that retains...
-
Yea, I guess if your being contracted the big $ comes into question, give them what they want. Otherwise, if its an internal application for your employer, then I always pick the easy route.
-
You could just configure the web server to log the data you need, then create an application to monitor those log files.
-
As with any hardware update, it may find it on the hard drive already, or may ask for the OS install disk, or it may be a disk provided with the motherboard. I suggest you keep a backup of the drive...
-
Although not necessary to reinstall, realize that since your changing motherboards the OS will detect new hardware related to the new motherboard system resources. This may prompt for new drivers,...
-
Check out this forum
http://www.htpcnews.com/forums/index.php
-
Oracle on Linux is available. Don't be scared off by the previous post. Since Oracle and SQL Server can be linked databases, you have a native two way street between your data and anythings possible...
-
Find out what programming languages they offer at your university as an elective. Physics may require one anyhow. Choose one of those to start learning yourself, then take the class when you get...
-
Don't actually count with a shared variable on your detail record, create a separate formula say AwaitingOutcome10 with
If {tbl_Enquiry.AwaitingOutcome} = "Yes" Then 1
Else 0
Drop that on the...
-
No problem. You don't have to connect to a database. You can set Crystal Parameters, Formulas, etc at runtime or even create a recordset and use that all of which could display on your Crystal Report.
-
I know in the past I've had to manually install the export file types, for the export button. It seemed the export button dynamically looks for them and presents the options depending on what it...
-
My preference has always been to design reports with the Crystal Reports application, save as .rpt files and then reference them in my application by using either the crystal viewer control or...
-
Ok, try this for an example if you were to re-write the function. Create a new procedure as follows. I'll use the same exact parameters, just without a select statement.
CREATE OR REPLACE...
-
Just re-read the definition and see stub_get_cust_address is a function. You can not call oracle functions directly from vb ado. You need to convert the function into a procedure, or wrap it in a...
-
The ? is a place holder stating there is a parameter in the procedure call. So if you have another procedure that has only two parameters there would only be (?,?), three (?,?,?) etc.
ADO and the...
-
I don't know about 10g, but Oracle had previously provided personal editions of 8i and 9i you could download and use. The personal editions would install on a workstation and was good for as in this...
-
AFAIK, you'll have to keep track of it yourself. You can either use a boolean or long to track it. Examples:
connection.begintrans
blnInTran = true
In this case after every begintrans...
-
You're trying to use the AdCmdStoredProc command type that is not supported with the Oracle ODBC Driver from what I recall. That's why it bombs on the execute.
Change your code:
.CommandType =...
|
Click Here to Expand Forum to Full Width
|