Problem connect vb6 to sql server

[Sky86]

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!

[willakawill]

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
Is the security for sql server set to Windows or mixed?

[sashi]

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.

[Sky86]

Hi
Is the security for sql server set to Windows or mixed?

the sql server security set to window.
which 1 is better or easy to linking

[willakawill]

the sql server security set to window.
which 1 is better or easy to linking

It is better for you to create a user with rights to the database and tables that you need. Then you can use the id and password for this user on any computer that uses your app. Otherwise you will get a lot of problems making a connection.

[Sky86]

It is better for you to create a user with rights to the database and tables that you need. Then you can use the id and password for this user on any computer that uses your app. Otherwise you will get a lot of problems making a connection.

thank
i got connect to sql already.

[vps021]

How you got it? Can you pl. reply to [e-mail]

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!