Re: Create SQL Server database from VB6.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Just what I needed.

Thanks very much!


"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
news:%23we8vgWtFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
> Any version of VB6 can execute the correct DDL commands to SQL Server to
> create databases. Some versions of VB6 can do it right in the IDE.
> See http://betav.com/Files/Content/code/SampleCode.htm if this link
> (Sample application) can help. IIRC (and it's been awhile since I looked
> at it) it can create databases etc.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "dave m" <davem@xxxxxxxxxxxxxx> wrote in message
> news:ugs3BeWtFHA.3896@xxxxxxxxxxxxxxxxxxxxxxx
>> Is it possible to create a Sql Server database from a VB6 application via
>> DDL? I've found the 'Create' method isn't supported by the OLE DB
>> providers for SQL Server.
>>
>> Also, when working with SQL Server databases from a VB6 app., what
>> specific referencces need to be added to the project?
>>
>>
>> Thanks in advance for any help.
>>
>> Dave M.
>>
>
>


.

Relevant Pages

  • Re: Create SQL Server database from VB6.
    ... Any version of VB6 can execute the correct DDL commands to SQL Server to ... Some versions of VB6 can do it right in the IDE. ... can create databases etc. ...
    (microsoft.public.vb.database)
  • Re: Im very confused about the different databases!
    ... I'm confused about the different databases. ... There's DAO, ADO, ADO.NET, Jet, SQL, SQL Server ... SQL Server 2005 with VB6 LE. ... to convert their VB6 code to VB.Net, or even another language. ...
    (microsoft.public.vb.general.discussion)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)