PDA

View Full Version : Connecting to MS SQL DB


ShMiL
09-16-2002, 12:23 PM
I try to connect to SQL SERVER database with this string:
"Provider=SQLOLEDB; Data Source=BOOXA; Initial Catalog=hebexxx; User ID=Administrator; Password=1234;"
and I get this error:
Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.
What can I do?
Thanks!

allida77
09-18-2002, 04:55 AM
Is that the proper user login for the db?Check your user accounts and be sure that the user id has proper rights.

link:
http://www.able-consulting.com/ADO_Conn.htm