how can connect the database

Question

snifer 0 Newbie Poster

16 Years Ago

hi friends,
i had a problem when connecting the database to the asp.net. My database is SQL server 2005

asp.net

5 Contributors
4 Replies
105 Views
16 Hours Discussion Span
Latest Post 16 Years Ago Latest Post by Paladine

Jx_Man 987 Nearly a Senior Poster

16 Years Ago

this following code to connect asp.net with sqlserver

Imports System.Data
Imports System.Data.SqlClient

Module ConnectionDB
    Public conn As New SqlConnection("Server = j3rry;" & "initial Catalog = PP60;" & " Trusted_Connection=yes")
End Module

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Bombdrop 0 Newbie Poster · Answer 1 · 2008-01-22T22:13:03+00:00

the following site shows connection string for all manor of DB's Connectionstrings.com/

ericstenson 5 Posting Whiz in Training Team Colleague · Answer 2 · 2008-01-23T03:38:46+00:00

... try using the New SQL Datasource option to make sure your creds are good.

Paladine 138 Master Poster Team Colleague · Answer 3 · 2008-01-23T08:41:20+00:00

You could also place this "connection" in a Web.config file, for security purposes...

And to be sure... what version of ASP.NET are you speaking of? .Net 1.0, 1.1, 2.0, 3.0 ?

2.0 Tutorial: http://aspnet.4guysfromrolla.com/articles/110905-1.aspx