Re: CONNECTION PROBLEM USING VB6 TO SQL SEVER 2000 PERSONAL EDITON

On Wed, 14 Jun 2006 15:40:16 +0500, "Abdul Hameed" <ahameed@xxxxxxxxxxxxxxxx> wrote:

¤ 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.
¤

Is your SQL Server configured for both SQL Server and Windows authentication? Based upon the error
message it would appear that it is configured for Windows authentication only.


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: ASP.NET and SQL Authentication: Login failed
    ... ¤ server with sql authentication. ... problem with windows authentication, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: 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 ... and VB6 and installed sql ... Is your SQL Server configured for both SQL Server and Windows ...
    (microsoft.public.vb.enterprise)
  • Re: Using MAPIControls with VB6
    ... If your SMTP server happens to be on your inside network, ... app will not have to go anywhere on the internet. ... Outlook Express client though the MAPI Contrls, ... ¤ Hi, ...
    (microsoft.public.vb.general.discussion)
  • Re: Migrating from DAO to ADO
    ... ¤ I am currently involved in migrating our backend DB from Acess to SQL ... I would look for some old ADO/SQL Server books. ... deals with ADO.NET and SQL Server. ...
    (microsoft.public.vb.general.discussion)
  • Re: connect remote Access database
    ... what is mean by "direct access to the resource through network"? ... > ¤ My server is a FTP server, ... > If you're accessing via FTP or HTTP that's a completely different issue. ...
    (microsoft.public.dotnet.framework.adonet)