Results 1 to 5 of 5

Thread: SQL Connectivity problem from WIN 98

  1. #1
    Join Date
    Nov 2002
    Posts
    84

    SQL Connectivity problem from WIN 98

    Hi,

    We have a client machine that has Win98. From that they are running VB app that connects SQL 2000 Server.
    Here is the code in the registry under

    HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\Appname folder

    for running that application.

    Provider=SQLOLEDB.1;Initial Catalog=dbname;Data Source=xxxx;Integrated Security=SSPI

    From ODBC the system can connect to the database.

    But from SQLOLEDB

    It comes back with error:
    -2147467259

    Unable to connect.

    Any ideas?

    Thanks,
    Anu

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    did you connect to SQL Server using windows authentication using ODBC?

    Does the login that runs vb app has access to sql server?

  3. #3
    Join Date
    Nov 2002
    Posts
    84
    The NT Authentication works under ODBC connection. by not using this registry key.

    The VP App has been set up to use this registry key to login.

    It works on the Machines that has Windows 2000 but not Win98.

    Thanks,
    Anu

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can try this.

    Run SQL Server client network utility to specify the protocol to use for the server.

  5. #5
    Join Date
    Nov 2002
    Posts
    84
    Thanks Skanal.

    Anu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •