Log in error

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

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
 
Hi SF,
cnStg = "Persist Security Info=False;Data Source=LC2000;Integrated
Security=SSPI;Initial Catalog=SFKC;Data Provider=SQLOLEDB.1"
Click to expand...

You are using integrated security
;Integrated Security=SSPI
Click to expand...

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 ;-)
--
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
 
Back
Top