ADOX?

[pk]

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

[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/de...ALTERTABLE.asp

Ken
-----------------------
"pk" <an*******@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...

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

[Ken Tucker [MVP]]

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" <an*******@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com...

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

[pk]

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" <an*******@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com..

Hi

Can anyone tell m
->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

[Sudhakar Sadasivuni[MVP]]

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:

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