Re: SQL Server login dialog issue

From: Darren (post2Group_at_Only.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 20:30:48 +0100

If similar in nature to a database we have, the VB code was generated to
look to a system dsn file for its connection to SQL Server.

If this be so, you will need to create a system dsn via the Control Panel,
in here you point it to the SQL Server database and specify the username and
password, then when the VB app is run, it will connect to the database via
the dsn that in turn sends the authentication to the SQL Server instance.

"Baskar" <Baskar@discussions.microsoft.com> wrote in message
news:586A2240-F08B-409C-BA45-43BC5B67B608@microsoft.com...
> Hi
>
> We developed an application in VB 6.0 with SQL 2000 as Back-End.
> Our application is working fine in our office. In the client place if we
run our application every time it is asking to enter (SQL server Login) user
name & PWD (sa/empty) in
> SQL Server login dialog.
>
> This some thing related with SQL setting i believe.
>
> It will be great if somebody help to fix this issue.
>
> Anticipating reply
>
> Baskar
>

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
Quantcast