Database Connection

[mahesh123]

Hi,

I am using the ADODB Connections for SQLServer2000. When I Connecting to the SQL Server I am getting an error

"SQL Server Does not Exits or Acess Dennied"

so please tell how can we solve this error.

[jamesd0142]

My guess is your connection string, or file path have some error in it,.

ensure the path to your database is correct.
-------
Are you using the app.path method? if yes then this can cause problems if you put you *.mdb file in the wrong location.
----------

[mahesh123]

My guess is your connection string, or file path have some error in it,.

ensure the path to your database is correct.
-------
Are you using the app.path method? if yes then this can cause problems if you put you *.mdb file in the wrong location.
----------

I am Using the SQL Server. Sometimes it will connected to the SQL Server and some time it will not connected to the SQL Server.

[jrtox]

I am Using the SQL Server. Sometimes it will connected to the SQL Server and some time it will not connected to the SQL Server.

Hello,

Check your SQL Server if its Running everytime you used it.

what you are using in establishing connection from your VB to your DB?

Regards
Ervin

[mahesh123]

Hello,

Check your SQL Server if its Running everytime you used it.

what you are using in establishing connection from your VB to your DB?

Regards
Ervin

I am using the ADODB Connection for the SQL Server.

the Connection String is used by me

conn.ConnectionTimeout = 15
conn.ConnectionString = "driver={SQL Server};server=" & Server2003 & ";UID=" & EmployeeLogin & " ;password=" & mahesh & ";database=" & emplogin & ""
conn.Open
If conn.State <> adStateOpen Then
MsgBox ("SQL Server is not started. Please contact administrator")
End If
connectDatabase = enumDBConnection.DBConnected

Here EmployeeLogin is the Seperate User created by the admin with all permissions for accessing the emplogin database.

[jrtox]

I am using the ADODB Connection for the SQL Server.

the Connection String is used by me

conn.ConnectionTimeout = 15
conn.ConnectionString = "driver={SQL Server};server=" & Server2003 & ";UID=" & EmployeeLogin & " ;password=" & mahesh & ";database=" & emplogin & ""
conn.Open
If conn.State <> adStateOpen Then
MsgBox ("SQL Server is not started. Please contact administrator")
End If
connectDatabase = enumDBConnection.DBConnected

Here EmployeeLogin is the Seperate User created by the admin with all permissions for accessing the emplogin database.

Hello,

Maybe my attachment(sample.zip) will help you, just the Connection string.

Follow this link
http://www.thescripts.com/forum/thread719352.html

Regards
Phils Ervin