PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Word > Microsoft Frontpage > Database connection script problem

Reply
Thread Tools Rate Thread

Database connection script problem

 
 
Mettá
Guest
Posts: n/a
 
      27th Jun 2005
The following is a "simple" select distinct query in a form...


<%Dim DSN_NAM33
DSN_Name1 = Application("DB11_ConnectionString")
set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_NAM33
Set RSCat = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
RSCat.Open SQL, Connection
%><select name="County" size="1">
<option value="<%=Request("County")%>"><%=Request("County")%></option>
<% while NOT RSCat.EOF %>
<option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
<%
RSCat.MoveNext
wend
RSCat.Close
%>

Can anyone see anything wrong in this??

Thanks
M
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jun 2005
Yes, you haven't set/assigned DSN_NAM33.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The following is a "simple" select distinct query in a form...
>
>
> <%Dim DSN_NAM33
> DSN_Name1 = Application("DB11_ConnectionString")
> set Connection = Server.CreateObject("ADODB.Connection")
> Connection.Open DSN_NAM33
> Set RSCat = Server.CreateObject("ADODB.RecordSet")
> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
> RSCat.Open SQL, Connection
> %><select name="County" size="1">
> <option value="<%=Request("County")%>"><%=Request("County")%></option>
> <% while NOT RSCat.EOF %>
> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
> <%
> RSCat.MoveNext
> wend
> RSCat.Close
> %>
>
> Can anyone see anything wrong in this??
>
> Thanks
> M
>
 
Reply With Quote
 
Mettá
Guest
Posts: n/a
 
      27th Jun 2005
Thanks for your response but that is not the error, see post above for
correct error script, NAM33 is used throughout the script...

M

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Yes, you haven't set/assigned DSN_NAM33.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> The following is a "simple" select distinct query in a form...
>>
>>
>> <%Dim DSN_NAM33
>> DSN_Name1 = Application("DB11_ConnectionString")
>> set Connection = Server.CreateObject("ADODB.Connection")
>> Connection.Open DSN_NAM33
>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>> RSCat.Open SQL, Connection
>> %><select name="County" size="1">
>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>> <% while NOT RSCat.EOF %>
>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>> <%
>> RSCat.MoveNext
>> wend
>> RSCat.Close
>> %>
>>
>> Can anyone see anything wrong in this??
>>
>> Thanks
>> M
>>
>
>
 
Reply With Quote
 
Mettá
Guest
Posts: n/a
 
      27th Jun 2005
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd00 Thread 0xc7c
DBC 0x11d0a6c Jet'.

M

"Mettá" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for your response but that is not the error, see post above for
> correct error script, NAM33 is used throughout the script...
>
> M
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Yes, you haven't set/assigned DSN_NAM33.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WebMaster Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> The following is a "simple" select distinct query in a form...
>>>
>>>
>>> <%Dim DSN_NAM33
>>> DSN_Name1 = Application("DB11_ConnectionString")
>>> set Connection = Server.CreateObject("ADODB.Connection")
>>> Connection.Open DSN_NAM33
>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>> RSCat.Open SQL, Connection
>>> %><select name="County" size="1">
>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>> <% while NOT RSCat.EOF %>
>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>> <%
>>> RSCat.MoveNext
>>> wend
>>> RSCat.Close
>>> %>
>>>
>>> Can anyone see anything wrong in this??
>>>
>>> Thanks
>>> M
>>>
>>
>>
>
>
 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jun 2005
Is this on your local or the remote server? Have you reset the database connection under Tools | Web
/ Site Settings?

80004005 is a indication of a permission problem.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
> (volatile) Jet DSN for process 0xd00 Thread 0xc7c DBC 0x11d0a6c Jet'.
>
> M
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks for your response but that is not the error, see post above for correct error script,
>> NAM33 is used throughout the script...
>>
>> M
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Yes, you haven't set/assigned DSN_NAM33.
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>> WebMaster Resources(tm)
>>> http://www.ycoln-resources.com
>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>> ==============================================
>>> If you feel your current issue is a results of installing
>>> a Service Pack or security update, please contact
>>> Microsoft Product Support Services:
>>> http://support.microsoft.com
>>> If the problem can be shown to have been caused by a
>>> security update, then there is usually no charge for the call.
>>> ==============================================
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> The following is a "simple" select distinct query in a form...
>>>>
>>>>
>>>> <%Dim DSN_NAM33
>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>> Connection.Open DSN_NAM33
>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>> RSCat.Open SQL, Connection
>>>> %><select name="County" size="1">
>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>> <% while NOT RSCat.EOF %>
>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>> <%
>>>> RSCat.MoveNext
>>>> wend
>>>> RSCat.Close
>>>> %>
>>>>
>>>> Can anyone see anything wrong in this??
>>>>
>>>> Thanks
>>>> M
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Mettá
Guest
Posts: n/a
 
      27th Jun 2005
Hi I have just reset and it is sort of working!!

The problem has arisen as I have two of these which then produce a DRW
result based on..

Select County
then on search there is an option to select post code/zip based on County

Then the DRW is supposed to produce all matching records... Its working on
line (Win2003 FP server) but not locally WinXP Pro??? so I can no longer
publish any updates!!!!

<td><% If Request("Desc")>"" Then %>
<%Dim DSN_Name
DSN_Name = Application("DB11_ConnectionString")
set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_Name
Search=Request("Description")
Set RSCat = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT DISTINCT County FROM Names WHERE (Desc LIKE '%" &Search& "%')
ORDER BY County"
RSCat.Open SQL, Connection
%><select name="County" size="1">
<option value="<%=Request("County")%>"><%=Request("County")%></option>
<% while NOT RSCat.EOF %>
<option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
<%
RSCat.MoveNext
wend
RSCat.Close
%>
<%Else%>
Enter Search Term<%End IF%></td>
</tr>
<tr>
<td>Post Code:</td>
<td><%If Request("County")>"" Then%>
<%Dim DSN_Name2
DSN_Name2 = Application("DB11_ConnectionString")
set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_Name2
Search=Request("Desc")
Search2=Request("County")
Set RSCat = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT DISTINCT Pc1 FROM Names WHERE (Desc LIKE '%"&Search& "%' AND
County LIKE '%" &Search2& "%') ORDER BY Pc1"
RSCat.Open SQL, Connection
%>
<select name="Pc1" size="1">
<option><%=request("Pc1")%></option>
<% while NOT RSCat.EOF %>
<option value="<%=RSCat("Pc1")%>"><%=RSCat("Pc1")%></option>
<%
RSCat.MoveNext
wend
RSCat.Close
%><%Else%>SELECT COUNTY<%End IF%></td>

.... DRW





"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is this on your local or the remote server? Have you reset the database
> connection under Tools | Web / Site Settings?
>
> 80004005 is a indication of a permission problem.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Error Type:
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
>> registry key 'Temporary (volatile) Jet DSN for process 0xd00 Thread 0xc7c
>> DBC 0x11d0a6c Jet'.
>>
>> M
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Thanks for your response but that is not the error, see post above for
>>> correct error script, NAM33 is used throughout the script...
>>>
>>> M
>>>
>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Yes, you haven't set/assigned DSN_NAM33.
>>>>
>>>> --
>>>> ==============================================
>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>> WebMaster Resources(tm)
>>>> http://www.ycoln-resources.com
>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>> ==============================================
>>>> If you feel your current issue is a results of installing
>>>> a Service Pack or security update, please contact
>>>> Microsoft Product Support Services:
>>>> http://support.microsoft.com
>>>> If the problem can be shown to have been caused by a
>>>> security update, then there is usually no charge for the call.
>>>> ==============================================
>>>>
>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> The following is a "simple" select distinct query in a form...
>>>>>
>>>>>
>>>>> <%Dim DSN_NAM33
>>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>>> Connection.Open DSN_NAM33
>>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>>> RSCat.Open SQL, Connection
>>>>> %><select name="County" size="1">
>>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>>> <% while NOT RSCat.EOF %>
>>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>>> <%
>>>>> RSCat.MoveNext
>>>>> wend
>>>>> RSCat.Close
>>>>> %>
>>>>>
>>>>> Can anyone see anything wrong in this??
>>>>>
>>>>> Thanks
>>>>> M
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Mettá
Guest
Posts: n/a
 
      27th Jun 2005
The actual error I now get is

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xd00 Thread 0xb90
DBC 0x11d0064 Jet'.

Thanks
M


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is this on your local or the remote server? Have you reset the database
> connection under Tools | Web / Site Settings?
>
> 80004005 is a indication of a permission problem.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Error Type:
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
>> registry key 'Temporary (volatile) Jet DSN for process 0xd00 Thread 0xc7c
>> DBC 0x11d0a6c Jet'.
>>
>> M
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Thanks for your response but that is not the error, see post above for
>>> correct error script, NAM33 is used throughout the script...
>>>
>>> M
>>>
>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Yes, you haven't set/assigned DSN_NAM33.
>>>>
>>>> --
>>>> ==============================================
>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>> WebMaster Resources(tm)
>>>> http://www.ycoln-resources.com
>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>> ==============================================
>>>> If you feel your current issue is a results of installing
>>>> a Service Pack or security update, please contact
>>>> Microsoft Product Support Services:
>>>> http://support.microsoft.com
>>>> If the problem can be shown to have been caused by a
>>>> security update, then there is usually no charge for the call.
>>>> ==============================================
>>>>
>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> The following is a "simple" select distinct query in a form...
>>>>>
>>>>>
>>>>> <%Dim DSN_NAM33
>>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>>> Connection.Open DSN_NAM33
>>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>>> RSCat.Open SQL, Connection
>>>>> %><select name="County" size="1">
>>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>>> <% while NOT RSCat.EOF %>
>>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>>> <%
>>>>> RSCat.MoveNext
>>>>> wend
>>>>> RSCat.Close
>>>>> %>
>>>>>
>>>>> Can anyone see anything wrong in this??
>>>>>
>>>>> Thanks
>>>>> M
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jun 2005
Not related to the error, but avoid using just Request("variable") always specify which request
object you want to use, this avoid having SQL Injection risks, use Request.Form("variable"),
Request.QueryString("variable"), etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:epBTF%(E-Mail Removed)...
> Hi I have just reset and it is sort of working!!
>
> The problem has arisen as I have two of these which then produce a DRW result based on..
>
> Select County
> then on search there is an option to select post code/zip based on County
>
> Then the DRW is supposed to produce all matching records... Its working on line (Win2003 FP
> server) but not locally WinXP Pro??? so I can no longer publish any updates!!!!
>
> <td><% If Request("Desc")>"" Then %>
> <%Dim DSN_Name
> DSN_Name = Application("DB11_ConnectionString")
> set Connection = Server.CreateObject("ADODB.Connection")
> Connection.Open DSN_Name
> Search=Request("Description")
> Set RSCat = Server.CreateObject("ADODB.RecordSet")
> SQL = "SELECT DISTINCT County FROM Names WHERE (Desc LIKE '%" &Search& "%') ORDER BY County"
> RSCat.Open SQL, Connection
> %><select name="County" size="1">
> <option value="<%=Request("County")%>"><%=Request("County")%></option>
> <% while NOT RSCat.EOF %>
> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
> <%
> RSCat.MoveNext
> wend
> RSCat.Close
> %>
> <%Else%>
> Enter Search Term<%End IF%></td>
> </tr>
> <tr>
> <td>Post Code:</td>
> <td><%If Request("County")>"" Then%>
> <%Dim DSN_Name2
> DSN_Name2 = Application("DB11_ConnectionString")
> set Connection = Server.CreateObject("ADODB.Connection")
> Connection.Open DSN_Name2
> Search=Request("Desc")
> Search2=Request("County")
> Set RSCat = Server.CreateObject("ADODB.RecordSet")
> SQL = "SELECT DISTINCT Pc1 FROM Names WHERE (Desc LIKE '%"&Search& "%' AND County LIKE '%"
> &Search2& "%') ORDER BY Pc1"
> RSCat.Open SQL, Connection
> %>
> <select name="Pc1" size="1">
> <option><%=request("Pc1")%></option>
> <% while NOT RSCat.EOF %>
> <option value="<%=RSCat("Pc1")%>"><%=RSCat("Pc1")%></option>
> <%
> RSCat.MoveNext
> wend
> RSCat.Close
> %><%Else%>SELECT COUNTY<%End IF%></td>
>
> ... DRW
>
>
>
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> Is this on your local or the remote server? Have you reset the database connection under Tools |
>> Web / Site Settings?
>>
>> 80004005 is a indication of a permission problem.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WebMaster Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Error Type:
>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
>>> (volatile) Jet DSN for process 0xd00 Thread 0xc7c DBC 0x11d0a6c Jet'.
>>>
>>> M
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Thanks for your response but that is not the error, see post above for correct error script,
>>>> NAM33 is used throughout the script...
>>>>
>>>> M
>>>>
>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> Yes, you haven't set/assigned DSN_NAM33.
>>>>>
>>>>> --
>>>>> ==============================================
>>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>>> WebMaster Resources(tm)
>>>>> http://www.ycoln-resources.com
>>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>>> ==============================================
>>>>> If you feel your current issue is a results of installing
>>>>> a Service Pack or security update, please contact
>>>>> Microsoft Product Support Services:
>>>>> http://support.microsoft.com
>>>>> If the problem can be shown to have been caused by a
>>>>> security update, then there is usually no charge for the call.
>>>>> ==============================================
>>>>>
>>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> The following is a "simple" select distinct query in a form...
>>>>>>
>>>>>>
>>>>>> <%Dim DSN_NAM33
>>>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>>>> Connection.Open DSN_NAM33
>>>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>>>> RSCat.Open SQL, Connection
>>>>>> %><select name="County" size="1">
>>>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>>>> <% while NOT RSCat.EOF %>
>>>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>>>> <%
>>>>>> RSCat.MoveNext
>>>>>> wend
>>>>>> RSCat.Close
>>>>>> %>
>>>>>>
>>>>>> Can anyone see anything wrong in this??
>>>>>>
>>>>>> Thanks
>>>>>> M
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jun 2005
What type of connection are you using FP file system (fpdb folder) or System DSN ?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:%23yfgt%(E-Mail Removed)...
> The actual error I now get is
>
> Database Results Error
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
> (volatile) Jet DSN for process 0xd00 Thread 0xb90 DBC 0x11d0064 Jet'.
>
> Thanks
> M
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>> Is this on your local or the remote server? Have you reset the database connection under Tools |
>> Web / Site Settings?
>>
>> 80004005 is a indication of a permission problem.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WebMaster Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Error Type:
>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
>>> (volatile) Jet DSN for process 0xd00 Thread 0xc7c DBC 0x11d0a6c Jet'.
>>>
>>> M
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Thanks for your response but that is not the error, see post above for correct error script,
>>>> NAM33 is used throughout the script...
>>>>
>>>> M
>>>>
>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> Yes, you haven't set/assigned DSN_NAM33.
>>>>>
>>>>> --
>>>>> ==============================================
>>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>>> WebMaster Resources(tm)
>>>>> http://www.ycoln-resources.com
>>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>>> ==============================================
>>>>> If you feel your current issue is a results of installing
>>>>> a Service Pack or security update, please contact
>>>>> Microsoft Product Support Services:
>>>>> http://support.microsoft.com
>>>>> If the problem can be shown to have been caused by a
>>>>> security update, then there is usually no charge for the call.
>>>>> ==============================================
>>>>>
>>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> The following is a "simple" select distinct query in a form...
>>>>>>
>>>>>>
>>>>>> <%Dim DSN_NAM33
>>>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>>>> Connection.Open DSN_NAM33
>>>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>>>> RSCat.Open SQL, Connection
>>>>>> %><select name="County" size="1">
>>>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>>>> <% while NOT RSCat.EOF %>
>>>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>>>> <%
>>>>>> RSCat.MoveNext
>>>>>> wend
>>>>>> RSCat.Close
>>>>>> %>
>>>>>>
>>>>>> Can anyone see anything wrong in this??
>>>>>>
>>>>>> Thanks
>>>>>> M
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jun 2005
See if the following helps:

http://support.microsoft.com/default...b;en-us;315456

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> What type of connection are you using FP file system (fpdb folder) or System DSN ?
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:%23yfgt%(E-Mail Removed)...
>> The actual error I now get is
>>
>> Database Results Error
>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
>> (volatile) Jet DSN for process 0xd00 Thread 0xb90 DBC 0x11d0064 Jet'.
>>
>> Thanks
>> M
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>> Is this on your local or the remote server? Have you reset the database connection under Tools |
>>> Web / Site Settings?
>>>
>>> 80004005 is a indication of a permission problem.
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>> WebMaster Resources(tm)
>>> http://www.ycoln-resources.com
>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>> ==============================================
>>> If you feel your current issue is a results of installing
>>> a Service Pack or security update, please contact
>>> Microsoft Product Support Services:
>>> http://support.microsoft.com
>>> If the problem can be shown to have been caused by a
>>> security update, then there is usually no charge for the call.
>>> ==============================================
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Error Type:
>>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>>> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary
>>>> (volatile) Jet DSN for process 0xd00 Thread 0xc7c DBC 0x11d0a6c Jet'.
>>>>
>>>> M
>>>>
>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> Thanks for your response but that is not the error, see post above for correct error script,
>>>>> NAM33 is used throughout the script...
>>>>>
>>>>> M
>>>>>
>>>>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>>>>> news:%(E-Mail Removed)...
>>>>>> Yes, you haven't set/assigned DSN_NAM33.
>>>>>>
>>>>>> --
>>>>>> ==============================================
>>>>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>>>>> WebMaster Resources(tm)
>>>>>> http://www.ycoln-resources.com
>>>>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>>>>> ==============================================
>>>>>> If you feel your current issue is a results of installing
>>>>>> a Service Pack or security update, please contact
>>>>>> Microsoft Product Support Services:
>>>>>> http://support.microsoft.com
>>>>>> If the problem can be shown to have been caused by a
>>>>>> security update, then there is usually no charge for the call.
>>>>>> ==============================================
>>>>>>
>>>>>> "Mettá" <(E-Mail Removed)> wrote in message
>>>>>> news:(E-Mail Removed)...
>>>>>>> The following is a "simple" select distinct query in a form...
>>>>>>>
>>>>>>>
>>>>>>> <%Dim DSN_NAM33
>>>>>>> DSN_Name1 = Application("DB11_ConnectionString")
>>>>>>> set Connection = Server.CreateObject("ADODB.Connection")
>>>>>>> Connection.Open DSN_NAM33
>>>>>>> Set RSCat = Server.CreateObject("ADODB.RecordSet")
>>>>>>> SQL = "SELECT DISTINCT County FROM Names ORDER BY County"
>>>>>>> RSCat.Open SQL, Connection
>>>>>>> %><select name="County" size="1">
>>>>>>> <option value="<%=Request("County")%>"><%=Request("County")%></option>
>>>>>>> <% while NOT RSCat.EOF %>
>>>>>>> <option value="<%=RSCat("County")%>"><%=RSCat("County")%></option>
>>>>>>> <%
>>>>>>> RSCat.MoveNext
>>>>>>> wend
>>>>>>> RSCat.Close
>>>>>>> %>
>>>>>>>
>>>>>>> Can anyone see anything wrong in this??
>>>>>>>
>>>>>>> Thanks
>>>>>>> M
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
 
Reply With Quote
 
 
 
Reply

« Can't open web in live mode on server | new hit counters stopped working_strange numbers »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Connection problem Raymondo Microsoft Frontpage 6 27th Jan 2008 05:09 PM
Database Connection problem vanessa via OfficeKB.com Microsoft Excel Crashes 0 22nd Feb 2006 04:03 AM
Problem with Timer script in MS Access database ghadley_00@yahoo.com Microsoft Access VBA Modules 0 6th Feb 2006 02:43 AM
Re: Database connection script problem Mettá Microsoft Frontpage 1 27th Jun 2005 08:08 PM
Database Connection Problem Robert Teasdale Microsoft Frontpage 4 13th May 2004 03:53 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 02:34 AM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top