-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|