sql server connection

[powerpc]

when Iam trying to connect by using following connection string it is gin=ving error "server not existing or aceess denied".may I know the error pl.
-------------------------------------------
myconn = New SqlClient.SqlConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=prasad&quot

mycommand = New SqlClient.SqlDataAdapter("select * from Authors", myconn)
--------------------------------------------------
thanks

 

[Isadore]

Power: This is a good review on SQL connection syntax:

http://www.aspalliance.com/stevesmith/articles/dotnetconnectionstrings.asp

 

[Isadore]

Power: A whole host of articles on SQL Connection can be found at:

http://aspalliance.com/search/default.asp?keyword=sql connection

...not on SQL yet myself, so can't help you directly with your problem - but many good articles here.

 

[cjlarue]

Looks like the password is missing from the connection string.

 

[RiverGuy]

Ditto the password. I would use a different account for just selecting too.

 

[chiph]

I think .NET doesn't use the "provider" part of the connection string if you're using the Sql provider (SqlConnection vs. OleDbConnection)

Chip H.

 

[powerpc]

Thanks Friends
I got it by giving the connection as "Data Source=powerpc;Integrated Security=SSPI;Initial Catalog=pubs" and I created new login name as
powerpc/aspnet in sql server prevously it gives the
error as "login denied ".

 

[dvannoy]

Guys, this is an very good site for ALL types of connection strings..

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

hope this helps