going nuts with connection

[Mike]

I'm trying to connect to a SQL 2000 db and i'm getting the following error:


'Login failed for user 'sa'. Reason: Not associated with a trusted sql
server connection'

Here is my connection string:

dim conStr as string =
"server=localhost;database=TechForum;uid=sa;password=;"

am i missing something something or what? I looked online and found some
information and tried it but nothing worked. I need some help on this

thx

 

[William Ryan [eMVP]]

YOu aren't using Integrated security... http://www.connectionstrings.com
This link should help.

Bill