User Profile

Collapse

Profile Sidebar

Collapse
codepirate
codepirate
Last Activity: Aug 19 '08, 04:52 PM
Joined: May 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • codepirate
    started a topic Pivot in SQL
    in SQL Server

    Pivot in SQL

    I have query that returns results like the following:

    request_id field_id field_value
    12345 2 abc
    12345 3 asdf
    12345 11 10
    12346 2 def
    12346 3 asdf
    12346 11 20

    and so on.
    I would like to display the results like this:

    request_id...
    See more | Go to post
    • codepirate
      started a topic outlook links in HREF
      in HTML CSS

      outlook links in HREF

      I have to open an email form when the user clicks on a link. I am using Outlook 2003. The form resides in "outlook://Public Folders/All Public Folders/xx/xx/~xxx xxx xxx (20007-02) " where the xx represent folders and xxx represent the subject of the mail item. The subject line ends with three spaces preceded by "(2007-02)" and preceded by 20 spaces. I tried using %20 for each space encountered in the above link. However,...
      See more | Go to post
      • codepirate
        started a topic Connecting to Outlook from C#
        in .NET

        Connecting to Outlook from C#

        Hi All,
        I've written code that connects to Outlook and retrieves emails from a folder that resides inside my inbox. My profile is on Exchange Server.

        Code:
        Outlook._Application olApp = new Outlook.ApplicationClass();
Outlook._NameSpace olNS = olApp.GetNamespace("MAPI");
olNS.Logon("****", "****", true, true);

Outlook.MAPIFolder newFolder = olNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);
        ...
        See more | Go to post
        • codepirate
          replied to Serverless/embedded PostgreSQL database
          in PostgreSQL
          Thanks for you input.
          See more | Go to post

            Leave a comment:

          • codepirate
            replied to Serverless/embedded PostgreSQL database
            in PostgreSQL
            I am honestly not sure if it can be done or not. But I tried to connect to PostgreSQL using some existing methods (ODBC, npgsql) from c# application assuming it to be a regular database server. However, I received errors with both mothods of connecting. With npgsql the error was something along the line of "server actively refused connection". And with ODBC it was more like "server doesn't support the version of method call"....
            See more | Go to post

              Leave a comment:

            • codepirate
              replied to Serverless/embedded PostgreSQL database
              in PostgreSQL
              Thank you for your reply. Unfortunately we have a product which comes with embedded PostgreSQL and I need to find a way to connect to the database, if possible. Or find another way to extract the information from the database. I have been googling for the past few days for some clue. But my search hasn't yielded anything fruitful yet.
              See more | Go to post

                Leave a comment:

              • codepirate
                started a topic Serverless/embedded PostgreSQL database
                in PostgreSQL

                Serverless/embedded PostgreSQL database

                Hi All,

                I am trying to connct to a serverless/embedded PostgreSQL database from a C# application using VS 2005. First of all, is this possible with PostgreSQL? I know this can be done with some other database providers (sqllite?). If anyone has connected to such a database using some other method/language I'd be greatful for the information.

                Thank you in advance for any information.
                See more | Go to post
                No activity results to display
                Show More
                Working...