We want to provide Crystal Reports (designed in the CR 11 IDE) for our application, which interfaces with Oracle 10g.
We want the reports to connect directly to the Oracle database to retrieve data, not use any .NET datasets or other DTO type of objects, so we've used the Crystal Reports driver...
Ah, I got it working...the issue was that we were trying to push the data in as Object, but that wasn't working. However, switching it to dbtype.binary did the trick. The file is now being saved to the db.
w00t!
D
Thanks for the reply Rick. We've got an added headache in that we're using DAAB (Microsoft Data Access Application Block), which by default doesn't utilize the Oracle data types...which means I don't have direct access to the Blob datatable when creating the parameter (we've been trying to pass...
I'm trying to save an uploaded file from a C# asp.net page into a Blob field in an Oracle table.
I'm putting the file into a byte array and passing that as the parameter value, but when I execute the Oracle command object (using the System.Data.OracleClient namespace), it throws an error saying...
I'm trying to save an uploaded file from a C# asp.net page into a Blob field in an Oracle table.
I'm putting the file into a byte array and passing that as the parameter value, but when I execute the Oracle command object (using the System.Data.OracleClient namespace), it throws an error saying...
I'm creating reports off of a pre-existing database (I didn't create the database). I need to generate a report, and part of it will have this functionality:
If there is no data entered in for two fields, or if there is data entered for two fields, then display. Otherwise, don't. Possible...
ok, so one other thing I've tried:
DateDiff("n",[date1],[date2])/60
Which will give me a fractional value:
So 1h 15min = 1.25
But I need this still shown as
1:15
There's gotta be an easier way than resorting to vba...
D
Hey guys,
I'm having some issues getting the time difference between two values.
Two dates:
05/10/2006 10:00:00 AM (we'll call this date1)
06/10/2006 10:21:00 AM (we'll call this date2)
The output I need is 24:21
Here's what I'm experiencing:
DateDiff("Short Time",[date1],[date2])
And I get...
Also, if you're planning on doing any scanning functionality (like with a flatbed scanner), you'll need the Advanced licensing (found that out the hard way).
D
We've got a weird issue...clients can access either internet explorer or Outlook 2003 as published applications.
If I set the font size in the browser settings to largest, then close and re-open the browser through Citrix, the setting persists. But if I click on an email link on a webpage and...
I had totally forgotten about this conversation until I came accross an interesting best-practice in the vs.net 2005 help files:
Do not rely on exceptions in your code Exceptions can cause performance to suffer significantly, so you should avoid using them as a way to control normal program...
You could also store your database connection strings in a config file...just encrypt it, and have your code decrypt it when it gets read in (.NET 2.0 has this functionality built in).
D
You can run the frameworks side by side though. In the virtual directory settings, you can specify what version of the framework you want your app to use.
When you install 2.0 it doesn't override 1.1, just installs side by side.
D
So I uninstalled the VS.NET 2K5 Beta and installed the production version.
Problem is that now I don't seem to have my VSS plug in available, and I can't figure out for the life of me how to re-install it.
Groan groan...
Thoughts?
D
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.