Connection error for SQL Server OleDB

F

feng

I am connecting to SQL Server through OleDB provider. The
SQL server I am testing is running on the same machine
that my VB.Net app is running. Here is my connection
string:

"Provider=SQLOLEDB;Data
Source=MyMachine\MySQLInstance;Initial catalog=testDB;user
id=sa;Password=mypwd"

What I got is an error message that says "Login failed for
user 'sa'. Reason: Not associated with a trusted SQL
Server connection."

What am I doing wrong here?

Please help!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connecting SQL server using OleDb - Reg 2
SQL Server 2000 9
sql server setting concat_null_yields_null 2
Connection String Problem 6
Problems using SqlConnection 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
app.config Connection string 2
OleDb connection to SQL connection 6

Top