How to create database and table into SQL server using ADOX

How to create database and table into SQL server using ADOX

Post by ABO » Sat, 12 Jan 2002 18:30:21



Pateform: VC 6.0, NT4.0, ADOX
Datyabase: SQL Server 2000

Hi,
Is it possible to create SQL Server database and table using ADOX. If
possible, please let me know how that can be created.

Thank in advance.

Regards
Vijay

 
 
 

How to create database and table into SQL server using ADOX

Post by Sue Hoegemeie » Tue, 15 Jan 2002 13:26:17


You don't need to use ADOX, you can use ADO and SQL
statements (create database and create table).
I don't think you can create a database through ADOX. For
tables, you can use the append method of the tables
collection. There is an example of how to do this in the ADO
hlep file.

--Sue

On Fri, 11 Jan 2002 14:30:21 +0500, "ABO"


>Pateform: VC 6.0, NT4.0, ADOX
>Datyabase: SQL Server 2000

>Hi,
>Is it possible to create SQL Server database and table using ADOX. If
>possible, please let me know how that can be created.

>Thank in advance.

>Regards
>Vijay