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?

'SQL Connection String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb"

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

Book mark the following link www.connectionstrings.com It will explain and show all the different types of connections strings for you.

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.