i'm new in vb, got some problem in connect to sql server 2000.
i use the following code to connect, n got error.
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Driver={sql server};server= ABC ;database= test"
conn.ConnectionTimeout = 30
conn.Open
The error i got in vb is
Run-time error -2147467259(80004005):
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
but i hav start my sql server already.
need help on this problem, thank for helping!
Hi there,
Is the SQL Server software installed in your local machine? If it's a local machine then you should change the server name to 127.0.0.1, hope it helps. Good luck & take care.