DataEnvironment Connection to a remote SQL Server database

From: John Blair (john_blair_at_hotmail.com)
Date: 02/17/05

  • Next message: jim: "VB6 using ADO, sproc with return recordset" 
    Date: Thu, 17 Feb 2005 19:17:35 GMT

    Hi,

    I am trying to connect one PC (win98) to SQL Server located on another PC
    (winxp1) but am failing with an error message:

    Test connection failed because of an error in initializing provider.
    [DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access
    denied.

    I am able to connect locally to SQL Server on winxp1 so i know the database
    is ok. This is the first time i have tried to connect remotely. On the
    connection
    options i have tried to use Windows NT integrated security and
    tried using a specific user name and password.
    The database i am trying to connect to is the microsoft pubs sample
    database.
    I am thinking i need to configure this database to allow remote connections
    but not sure what?...any help appreciated. Thanks.

  • Next message: jim: "VB6 using ADO, sproc with return recordset"

    Relevant Pages

    • Re: My Book is Incomplete Regarding SQL Commands ;-(
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: (Newbie)Application Roles
      ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
      (microsoft.public.sqlserver.security)
    • Re: Help! Set up Windows Group to access application
      ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
      (microsoft.public.sqlserver.security)
    • Re: My Book is Incomplete Regarding SQL Commands ;-(
      ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
      (microsoft.public.dotnet.framework.adonet)
    • RE: Logging in in background
      ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
      (microsoft.public.access.modulesdaovba)
    • Quantcast