User Profile

Collapse

Profile Sidebar

Collapse
MartinJackson
MartinJackson
Last Activity: Dec 17 '10, 08:59 AM
Joined: Dec 29 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MartinJackson
    replied to How to create sql server database file from VB6 application
    in Visual Basic
    My problem is to get connected so I can create my SS db from the VB6 application.

    The answer I needed was how to connect so I could run the SQL create DB.
    Your answer is Database=Master ;
    The rest is -

    ConnectionStrin g = "Provider=SQLNC LI;Server=YourS erverName;Datab ase=Master;Inte grated Security=SSPI;"

    Many thanks
    See more | Go to post

      Leave a comment:

    • MartinJackson
      started a topic How to create sql server database file from VB6 application
      in Visual Basic

      How to create sql server database file from VB6 application

      Using SQL Server 2005 Express.

      I want to create and maintain the SQL database and tables from within a VB6 application. First I need to create an empty database file. This I can't do.

      Using
      Set mcn = New ADODB.Connectio n
      mcn.Open mstrConnectStri ng

      I have tried various connection strings -
      mstrConnectStri ng="server=(loc al)\SQLEXPRESS; " & "integrated security=sspi;d atabase=;"...
      See more | Go to post
      No activity results to display
      Show More
      Working...