SQL Connection ??

[marylipscomb]

I am trying to connect to a sql server 2000.

I keep getting errors.. HELP Please!!!


Partial Class projectdevelopmentmain


Inherits System.Web.UI.Page
DIM SQLClient.SqlConnection as conn
Dim conSQL As New SQLClient.SqlConnection()
conSQL.ConnectionString= "Integrated Security=True;" &_
"Data Source =LocalHost;Initial Catalog=PDDB;"
conSQL.Open()

End Class

I get end of statement expected and I dont know what that means.
Declaration expected?/

HELP Please.

TIA!!!!

[Plater]

Have you checked:
http://www.connectionstrings.com/

[marylipscomb]

by the way, I am using VB.NET and ASP.NET... trying to connect to the SQL Server 2000

[marylipscomb]

no but I will try it, thanks!!

How do I know where my server address is??

[marylipscomb]

when I use this line it says there is a declaration expected on the Driver.

Driver={SQL Server};Server=local;Database=PDDB;Trusted_Connect ion=Yes;

[Plater]

You said you were using sql server 2000 right?

That website says:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
 

is the example connection string.


An alternative is to go through the wizzard in visual studio and then look at the connection string it creates and use that.