ADOX?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pk
    #1

    ADOX?

    Hi

    Can anyone tell me

    ->What for ADOX is used
    ->Can I change Column DataTypes in SQL Server 2000 Table(Data already present) using ADOX features in VB.NET? If so, how

    Thanks in advance for your help
    p

    Tags: None
    • Cor Ligthert
      #2
      Re: ADOX?

      Hi Pk,

      The only thing I know that you only can do with ADOX is creating a mcAccess
      database.

      For the rest you can create SQL strings and process them using one of the
      different execute commands in Adonet.

      Cor


        Comment

        • Cor Ligthert
          #3
          Re: ADOX?

          Hi Pk,

          The only thing I know that you only can do with ADOX is creating a mcAccess
          database.

          For the rest you can create SQL strings and process them using one of the
          different execute commands in Adonet.

          Cor


            Comment

            • Ken Tucker [MVP]
              #4
              Re: ADOX?

              Hi,

              In addition to Cor's comments use Alter table to modify a sql server
              table.

              http://msdn.microsoft.com/library/de...ALTERTABLE.asp

              Ken
              -----------------------
              "pk" <anonymous@disc ussions.microso ft.com> wrote in message
              news:D78A1FD4-1505-48B2-BF4C-D0FBE9C8AB33@mi crosoft.com...[color=blue]
              > Hi,
              >
              > Can anyone tell me
              >
              > ->What for ADOX is used?
              > ->Can I change Column DataTypes in SQL Server 2000 Table(Data already
              > present) using ADOX features in VB.NET? If so, how?
              >
              > Thanks in advance for your help,
              > pk
              >[/color]


                Comment

                • Ken Tucker [MVP]
                  #5
                  Re: ADOX?

                  Hi,

                  In addition to Cor's comments use Alter table to modify a sql server
                  table.

                  http://msdn.microsoft.com/library/de...ALTERTABLE.asp

                  Ken
                  -----------------------
                  "pk" <anonymous@disc ussions.microso ft.com> wrote in message
                  news:D78A1FD4-1505-48B2-BF4C-D0FBE9C8AB33@mi crosoft.com...[color=blue]
                  > Hi,
                  >
                  > Can anyone tell me
                  >
                  > ->What for ADOX is used?
                  > ->Can I change Column DataTypes in SQL Server 2000 Table(Data already
                  > present) using ADOX features in VB.NET? If so, how?
                  >
                  > Thanks in advance for your help,
                  > pk
                  >[/color]


                    Comment

                    • pk
                      #6
                      Re: ADOX?

                      Thank you, Cor & Ken for explanations, suggestions

                      Rgds
                      p

                      ----- Ken Tucker [MVP] wrote: ----

                      Hi

                      In addition to Cor's comments use Alter table to modify a sql server
                      table

                      http://msdn.microsoft.com/library/de...eALTERTABLE.as

                      Ke
                      ----------------------
                      "pk" <anonymous@disc ussions.microso ft.com> wrote in message
                      news:D78A1FD4-1505-48B2-BF4C-D0FBE9C8AB33@mi crosoft.com..[color=blue]
                      > Hi[color=green]
                      >> Can anyone tell m
                      >> ->What for ADOX is used[/color]
                      > ->Can I change Column DataTypes in SQL Server 2000 Table(Data already
                      > present) using ADOX features in VB.NET? If so, how[color=green]
                      >> Thanks in advance for your help[/color]
                      > p
                      >[/color]

                        Comment

                        • Sudhakar Sadasivuni[MVP]
                          #7
                          RE: ADOX?

                          ADOX objects are available from Microsoft ADO Ext. 2.7 for DDL and Security.
                          This is avaiable from a library msadox.dll.

                          Typically ADOX can be used for DDL actions which are very similiar to SQL Server DMO.

                          "pk" wrote:
                          [color=blue]
                          > Hi,
                          >
                          > Can anyone tell me
                          >
                          > ->What for ADOX is used?
                          > ->Can I change Column DataTypes in SQL Server 2000 Table(Data already present) using ADOX features in VB.NET? If so, how?
                          >
                          > Thanks in advance for your help,
                          > pk
                          >
                          >[/color]

                            Comment

                            Previous template Next
                            Working...