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

did you connect to SQL Server using windows authentication using ODBC?

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

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

You can try this.

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

Thanks Skanal.

Anu