I recently set up an OLE DB connection to SQL Server and I encountered problem by picking up the error:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/user/connections/classifieds.asp, line 4

This is the classifieds.asp coding.
<%
set objConn = Server.CreateObject("ADODB.Connection")
    objConn.provider = "sqloledb"
    objConn.Open "Server=GRACELAN-AD2786;Database=reminderservice;Integrated Security=SSPI"
%>

The thing is everything work well when i secure access to database except when online.

ASP pages run as a dfferent user (generally IUSR_MachineName). This is the user to which you must grant access to the database.

Also you can try giving your SQL server IP address there(Server=GRACELAN-AD2786) to see if that works. Then it may be a name resolution problem.

-Vijay G

i have same problem and i found why i have it:

<a href='http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B888228'>http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B888228</a>

but solution still bothers me,
i have MSDE sql server and that's why connection string won't work.

Any suggestion ???

Hi guys and gals i have got a question , and you seem to know a bout it i do not Xsacly know what an SQL syntax error is and i've got wone can you help me on this
---------------------------------------------------------------------
SELECT * FROM tbl_gallery WHERE selVIPTYPE = 0 LIMIT , 10
MySQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 1

This script cannot continue, terminating.
thanks in advance

The LIMIT clause can take the form where a is the offset from the first record returned and b is the number of records to return or where c is the number of records to return.
You therefore either need to add an offset of loose the comma.

HTH,

Chris