connecting to remote server using sql server with vb 6.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: connecting to remote server using sql server with vb 6.0

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    connecting to remote server using sql server with vb 6.0

    how can i connect an instance of sql server with remote server using visual basic 6.0.
    example conecting to instance of sql server using one computer is :
    inializing the connection
    con.provider="sqloledb"
    provstr="server myserver; Database = mydatabse trusted_connection=yes"

    with one pc i connect using the Above code but remote server con't how i ???
    ali ibrahim

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Take a look at the examples here: http://www.connectionstrings.com . If you're using ADO, you want the OLE DB examples.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Problem connecting to SQL server
    By Gab in forum VB Classic
    Replies: 2
    Last Post: 11-07-2001, 07:29 PM
  2. Replies: 2
    Last Post: 03-05-2001, 03:55 PM
  3. Comparing NULL values (VB, ADO, SQL Server)
    By Heather in forum VB Classic
    Replies: 1
    Last Post: 02-08-2001, 04:55 PM
  4. VB & SQL server
    By Becky in forum VB Classic
    Replies: 1
    Last Post: 09-12-2000, 11:32 AM
  5. vb, sql server and the web
    By Suzanne Haig in forum authorevents.kurata
    Replies: 2
    Last Post: 04-18-2000, 07:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center