Post reply

Connect Remotely with a VB Data Environment

  • November 30, 2004 at 9:45 pm

    #65858

    I can't seem to get the setting right for the server name for the data environment in VB.  Usually you would put in the server name when you are local but I can't get it to work when I am remote.  Do I put in IP Addressor what?

     

    Any help would greatly be appreciated.

    Thanks,

    Brent Weitzel

  • November 30, 2004 at 11:17 pm

    #531999

    hi brent weitzel...

    i don't know u developing by VB6 or VB.NET, but i'll write a connection string using VB.NET

    to set up a connection to sql server , u must declare about

    1 - server name

    2- sql instance

    3 - database name that running in sql instance

    4 - user name and password if u used SQL authintication , if windows authintication use trusted connection

    5- connection timeout default value 15 sec

    syntax like this...

    connectionstring=(server name\SQL instance;database name; trusted connecton = true;

                              connection timeout =15)

    ex..

    connectionstring = (test\account;accounting;trusted connection = true ; connection timeout=15 )

  • December 1, 2004 at 8:51 am

    #532062

    This is for a vb6 application and its actually in the data environment form that is added.   I can connect locally and remotely with my normal connections but am using the data environment for vb reports component.

  • December 1, 2004 at 9:17 pm

    #532132

    Any Suggestions Anybody?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply