Log in error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SF - 05 Dec 2003 07:49 GMT

Hi,

I have one form for user to login consist of two fields, txtUserName and
txtPassword. I have one button that have the following code.

dim oConn as new ADODB.Connection
dim cnStg as string

cnStg = "Persist Security Info=False;Data Source=LC2000;Integrated
Security=SSPI;Initial Catalog=SFKC;Data Provider=SQLOLEDB.1"
Set oConn = CurrentProject.OpenConnection(cnStg, Me.txtUserName,
Me.txtPassword)

I got error message

SF

Reply to this Message

Uwe Ricken - 05 Dec 2003 10:58 GMT

Hi SF,

> cnStg = "Persist Security Info=False;Data Source=LC2000;Integrated
> Security=SSPI;Initial Catalog=SFKC;Data Provider=SQLOLEDB.1"

You are using integrated security

>;Integrated Security=SSPI

If you would like to connect with a sql user account the string has
to look like that:

Persist Security Info=False;
Data Source=SQL2000\SERVER2000;
User ID=YourUserName;
Password=YourPassword;
Initial Catalog=DefaultDB;

HTH ;-)

Signature

Gruß, Uwe Ricken
MCP for SQL Server 2000 Database Implementation

GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm

Reply to this Message