ADOX?

[Guest]

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

 

[Cor Ligthert]

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

 

[Ken Tucker [MVP]]

Hi,

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

http://msdn.microsoft.com/library/d...ry/en-us/dnsqlmag04/html/InsideALTERTABLE.asp

Ken

 

[Guest]

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/default.asp?url=/library/en-us/dnsqlmag04/html/InsideALTERTABLE.as

Ke
----------------------

 

[Guest]

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.