CONNECTION PROBLEM USING VB6 TO SQL SEVER 2000 PERSONAL EDITON

I am having a problem in my vb6 application when I try to connect to sql
server 2000 personal editon with the following connection string.( I am
using windows XP professional service pack 2. and VB6 and installed sql
server on the same system)

db.Open "Provider=sqloledb;Data Source=HAMEED;Initial Catalog=NTL;User
Id=sa;Password=;"


the error message is :

"Run time error '-2147467259 (80004005)');
login failed for user 'sa' . Reason: Not associated with a trusted SQL
server connection.


When I check with the server the server is running fine and I can open every
table of the database NTL.using SQL server enterprise manager.

can anybody help me in this regard.

Thanks in anticipations.

Abdul Hameed


.

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
Loading