Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jfrost10

    Best Practice for Designing Against Oracle

    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...
  2. jfrost10

    Saving a File to Oracle: Byte[ ] not the right data type for a Blob?

    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
  3. jfrost10

    Saving a File to Oracle: Byte[ ] not the right data type for a Blob?

    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...
  4. jfrost10

    Saving a File to Oracle: Byte[ ] not the right data type for a Blob?

    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...
  5. jfrost10

    Error Saving File to Blob Field: Doesn't it take a byte[ ]?

    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...
  6. jfrost10

    Why Can't It Read The Empty String?!

    That did it, thanks! D
  7. jfrost10

    Why Can't It Read The Empty String?!

    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...
  8. jfrost10

    Access Time Diff Woes

    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
  9. jfrost10

    Access Time Diff Woes

    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...
  10. jfrost10

    Enterprise, Advanced, Standard

    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
  11. jfrost10

    Outlook Clobbers IE Settings?!

    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...
  12. jfrost10

    Should methods return nulls or throw exceptions

    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...
  13. jfrost10

    Gah!! Assemblies can be viewed as plain text?!?!?!

    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
  14. jfrost10

    Asp.Net 2.0

    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
  15. jfrost10

    VSS Plug In Gone?

    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
  16. jfrost10

    Weird Date Formatting

    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
  17. jfrost10

    Weird Date Formatting

    Yes.
  18. jfrost10

    Weird Date Formatting

    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...
  19. jfrost10

    IIS 6.0 Won't serve .html

    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...
  20. jfrost10

    IIS 6.0 Won't serve .html

    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...

Part and Inventory Search

Back
Top