Hello. How can i know the data source of my sql 2008?
Dim strconnection As String = "Data Source=.............;Initial Catalog=DatabaseConnection;Integrated Security=True;"
How am i suppose to know the the data source?
i it my computer name?
elianeasmar 0 Newbie Poster
Minimalist 96 Posting Pro
'SQL Connection String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"
ryanjayson -4 Newbie Poster
If your using MySQL then use standard Connector:
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
on your code:
Dim strconnection As String = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
For more connectionString reference visit here
G_Waddell 131 Posting Whiz in Training
Book mark the following link www.connectionstrings.com It will explain and show all the different types of connections strings for you.
ryanjayson -4 Newbie Poster
For more connectionString reference visit here
Sorry for wrong link address, it should be www.connectionstrings.com
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.