VB 6 app denied access to DB

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-05-06
A VB 6 app is unable to get access to a DB (DAMS) (MSSQL 2005). The connection string appears is correct. Please see code snippet.

An account is set up in SQL 2005 and it is added as a user of DAMS. Well, it is not working. Error messages from both VB 6 and SQL are useless.

I'm not a MS-SQL admin. Regardless, this was "tossed" to me. Any help would be appreciated. If any more info is needed, please ask. Thank you.

cCnString = "Provider=SQLOLEDB;"
    cCnString = cCnString & "User ID=DAMS2_User;"
    cCnString = cCnString & "Password=xxxxxxi;"
    cCnString = cCnString & "data source=sharepoint.database.parks;"
    cCnString = cCnString & "initial catalog=DAMS"

Open in new window

Question by:bobcann
  • 3
  • 2
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24152649
>Error messages from both VB 6 and SQL are useless.
maybe to you, so please post them anyhow

Author Comment

ID: 24152856
VB: Run-time Error 5
Invalid procedure call or argument.

Calls and arguments are correct. SQL returns:

Err.Description = Login failed for user 'DAMS2_User'.

Hope this helps. If not please ask for any info you need. Thanks.
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24152975
>Err.Description = Login failed for user 'DAMS2_User'.

means that DAMS2_User either does not have the password you specified, or that the sql instance is configured for Windows Authentication only (which is the default).

I presume you did double-check the password, so please check the second item: sql server properties -> security tab -> mixed authentication + restart sql server

Author Comment

ID: 24153090
Thanks angel. I'm finished for the day. Tomorrow I'll check the authentication method and get back to you.

BTW, the pw was triple checked :)

Author Comment

ID: 24188203
The problem is no longer mine. It went to a person who has as much SQL admin knoeledge as I.

Sorry to split the points, but the system presented you as two different members.

Thanks again.


Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question