ASP.NET 1.0 and 1.1 BasicsASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
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?
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
'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"
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