Search Result

Collapse
10 results in 0.0013 seconds.
Keywords
Members
Tags
ado
  •  
  • emilyjac
    started a topic cannot find action ou select distinct queries
    in Access

    cannot find action ou select distinct queries

    Hi.

    I have a function that produces some temporary queries. I create the queries instead of just executing from VB because I need one temp query to depend on another temp query. All the queries are named "rqt_tmp_someth ing" and once I'm done with them I run this handy procedure to find and delete them.
    This one query called "rqt_tmp_pop_gr p_struc_distinc t" doesn't delete.
    I have noticed while watching...
    See more | Go to post
    • John Doe
      started a topic recordset gets messed up by EOF/ reading in it ?
      in PHP

      recordset gets messed up by EOF/ reading in it ?

      This is a copy of an old post in here, but (presumably because it is so old) I cannot post an answer to, so I am re-creating it....

      =============== =============== ==========


      Seems like a $rs-> EOF messes up the record set ?
      (using php 4.2.2 and MSSQL database)
      I try to read the ntext-field "body".



      THIS WORKS !!

      Code:
      $dbMail = new COM("ADODB.Connection");
      ...
      See more | Go to post
      Last edited by Niheel; Jun 15 '11, 10:39 AM. Reason: added code tags
      • newsco
        started a topic VB6 ADO retrieve image file stored in the Access 2007 attachment data type
        in Visual Basic

        VB6 ADO retrieve image file stored in the Access 2007 attachment data type

        Dear all,

        I use VB6 ADO connect to Access 2007 accdb database, everything is fine except I cannot retrieve image file stored in the Access 2007 attachment data type.

        Can anyone show me some vb code on how to do that?

        Thanks.

        Patrick
        See more | Go to post
        • whizcompzm
          started a topic ADODC and MS Access Database Record limiting
          in Visual Basic

          ADODC and MS Access Database Record limiting

          I have ado code that connects my program to access(2000) database. The records in the table linked are 1000+.

          In the vb form, only 993 records are returned. But the report(Crystal Report) shows all the records.

          Does Ado have a limit to records that can loaded?

          If not, what could be the problem?
          See more | Go to post
          • thomasbihn
            started a topic Change Connection string for designer table at runtime
            in C Sharp

            Change Connection string for designer table at runtime

            I'm new to C# development. I am familiar with setting up connection strings and working with databases in ADO in VB6, but this is a bit more involved.

            I have a very basic application in which I created a connection to a production database table with three fields. I drug the table onto the form and was pleasantly surprised to see how it not only created the table on the form, but also gave me navigation controls. Unfortunately, now...
            See more | Go to post
            • ppletkov
              started a topic Why am I getting a compile error when i try to use the .find method (ADO, Recordset)?
              in Visual Basic

              Why am I getting a compile error when i try to use the .find method (ADO, Recordset)?

              Hi -
              I apologize if this is a simple question in advance :-) (hopefully it is so its quickly resolved!)

              i'm trying to figure out why i keep getting an error (Compile Error : expected function or variable) for my .find method. I have checked the format of this statement and it appears correct...?
              Code:
              Dim ItemNumberWLO As String
Dim ItemNumberWLN As String

While Not WLO.EOF

    If WLO.Fields.Item(1).Value
              ...
              See more | Go to post
              Last edited by debasisdas; Dec 12 '09, 02:19 PM. Reason: Formatted using code tags.
              • zman77
                started a topic Entity Data Model and stored procedures
                in C Sharp

                Entity Data Model and stored procedures

                Hi.
                My solution (working in VS 2008) has a C# console app, and a C# web service. The service has an entity data model. It has numerous stored procedures. For one of the stored procs, which just returns data (SELECT blah blah FROM...), I added a function import called "Iservice." I saved all, then in my console app, updated the service reference to my C# service. Now, in my console app, I am trying to do the following:
                ...
                See more | Go to post
                • nkoriginal
                  started a topic Ado Recordset in PHP
                  in PHP

                  Ado Recordset in PHP

                  Hello I would like to know if exist any way to create something like this in PHP

                  I need to insert in mysql an entire form, but I've to many field and I want a code to insert in the DB without to write in code each variable.

                  Thanks for you help

                  Code:
                   <% if request.Form("submit") = "submit" then 
Dim rs, data_source
Set rs = Server.CreateObject("ADODB.Recordset")
                  ...
                  See more | Go to post
                  Last edited by Markus; Mar 9 '09, 10:44 AM. Reason: Added [code] tags.
                  • saumitra75
                    started a topic VB Oracle Connection Data Retrieval
                    in Oracle

                    VB Oracle Connection Data Retrieval

                    I have a VB 6 application to connect to a Oracle database using ADO Connection. It works fine with Access. But when I try with my Oracle Database it does not retrieve any data. It can only show the Structure of the Tables. But no. of Rows is always 0. I have used Datagrid but only column names are displayed. Please help me. Its urgent for my exam also I m New to VB. The Connection Codes are given Below.

                    Option Explicit
                    Public...
                    See more | Go to post
                    • Jim Johnson
                      Guest started a topic import ADO DLL
                      in SQL Server

                      import ADO DLL

                      I have an application that needs to import a DLL file for some
                      database call like -

                      #import "c:\Program Files\Common Files\System\AD O\msado15.dll" \
                      rename("EOF", "EndOfFile" )

                      the path is OS dependent - what if I run on some other PC but the
                      msado15.dll is not specificed in the path specified? for this case -
                      #import "c:\Program Files\Common Files\System\AD O\...
                      See more | Go to post
                      Previous template Next
                      Working...