I have an issue that when I connecting to my data store. If I connect via SQL Server 2000 Dev I cannot access the file and get a generic 500 error. However using the same code I can connect to my Access, I have set permissions on SQL to allow connections etc.. even set to anonymous and still no connection on SQL. Any ideas?

How are you connecting, what is your connection string?
Jim

use your connection string in web config
www.whatusearch.net
www.powerofsearch.net

Sorry about that Here is the connection string.

Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")

Dim strDatabaseType
'Choose one of the following two lines, and comment out the other
'strDatabaseType = "Access"
strDatabaseType = "MSDE"

'Now we use this selection to open the connection in the appropriate way
If strDatabaseType = "Access" Then
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=C:\BeginningASP3\Movie2000.mdb;" & _
               "Persist Security Info=False"

Else
   objConn.Open = "Provider=SQLOLEDB;Persist Security Info=False;" & _
                "User Id=Josh;pwd=Test120;Initial Catalog=Movie;" &_
              "Data Source=C:\Program Files\Microsoft SQL Server\MSSQL\DATA\Movie2000SQL.mdf"

End If

use a sqlcommand object

dim objSqlConn as New SqlConnection

objSqlConn.ConnectionString = "workstation id=<pc name>;packet size=4096;user id=<id>;initial catalog=<db name>persist security info=True;password=<pw>"

Actually there were three things that I needed to do. First I had to setup the OLEDB in windows for SQL via the Administrative tools, second I had to go into the registry and reset the Authentication type as mixed for MYSQL was initially set as <default> or Windows Authentication only. Finally I had to change the connection string to the following

Else

  objConn.Open "Provider=SQLOLEDB;Data Source=<server>;Initial Catalog=Movie2000SQL;User Id=<Name>; Password=<Password>;"

End If
<server> = name of server in SQL
<name><password> = user defined name and password

I do appreciate the help though :)

Well you had stated you are using SQL Server 2000 in your original post. Based on that, my code will work. If you are using MySQL, it may be different, I don't know, I have never used it.