Creating SQL Database through VB Code

Question

Date: 11 January 2008 Dear Sir As per your instructions vide mail dated 11.01.2008 I have registered myself for this site. I am Rahul Dave from India. I am a VB 6.0 programmer using MS Access as Database. Kindly guide me how to create SQL Server 2000 Database through VB 6.0 Code; how to attach it to the SQL Server and how to detach it from the SQL Server 2000. Awaiting your prompt & descriptive reply at an early date. Thanks in anticipation Regards

Mike Gold · Answer

this site is really for C# Programmers (and maybe VB.NET). I suggest you post this question on a VB site. That said my guess is you can use recordsets from the ADODB COM library to do what you need to do. You could probably run a SQL script from VB to create your tables in SQL Server. Best -Mike