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
Ah, the issue for us seems to be that the Date variable apparantly must be in the M/d/yyyy format and you can't shove a dd/MM/yyyy formatted string into a date variable.
D
Hey all,
I have a date that I need to stick into Oracle. If...
Regional Settings = MM/dd/yyyy
and
Format in code = MM/dd/yyyy
this will go through no problem.
Regional Settings = dd/MM/yyyy
and
Format in code = MM/dd/yyyy
this will error out at the Oracle level
Regional Settings = dd/MM/yyyy...
For anyone that happens by this post, the issue was Sharepoint. We installed Sharepoint services on the box, and by default Sharepoint will intercept any web request and pass it through its own filters. We have an issue accessing the Sharepoint config database, adn because it couldn't hit it...
We've got a wonky server running IIS 6.0...it doesn't want to serve, well, anything. If we create a web share and stick an html page in it, and navigate to the page, we get a 404-Page Not Found error. I've seen many posts that talk about how IIS 6 will only serve static pages by default, but...
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.