Hi everybody,
I am using Access 2007, i am trying to connect to sql server 2000 from a form in access 2007. I havent done this before, after some search i tried this code, can you advise me if it is correct:
Dim connsql1 As String
connsql1 = "test"
Dim connection1 As SqlClient.SqlConnection
connection1 = SqlClient.SqlConnection("Data Source=ServerName;Initial Catalog=DatabaseName;User Id=sa;Password=sa")
Dim myCMD As SqlCommand
myCMD = "select count(n0_period_no) from plu"
Text1.Text = myCMD
First of all i want to get an input from the program that the connection succeded, that is why i run this query and i want to display the result in the textox...
Any ideas are really appreciated,
Best Regards
I am using Access 2007, i am trying to connect to sql server 2000 from a form in access 2007. I havent done this before, after some search i tried this code, can you advise me if it is correct:
Dim connsql1 As String
connsql1 = "test"
Dim connection1 As SqlClient.SqlConnection
connection1 = SqlClient.SqlConnection("Data Source=ServerName;Initial Catalog=DatabaseName;User Id=sa;Password=sa")
Dim myCMD As SqlCommand
myCMD = "select count(n0_period_no) from plu"
Text1.Text = myCMD
First of all i want to get an input from the program that the connection succeded, that is why i run this query and i want to display the result in the textox...
Any ideas are really appreciated,
Best Regards
