hi friends,
i had a problem when connecting the database to the asp.net. My database is SQL server 2005
snifer
0
Newbie Poster
Recommended Answers
Jump to Postthis 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
All 4 Replies
Bombdrop
0
Newbie Poster
ericstenson
5
Posting Whiz in Training
Team Colleague
... try using the New SQL Datasource option to make sure your creds are good.
Paladine
138
Master Poster
Team Colleague
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
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.