Error opening recordset - 'Too few parameters'

[emvy681]

I have a problem on programming, i am not that good but i can read and implement some programs.

I just wanna ask help on this code

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/pang/view_station.as p, line 14
which is "myrec.Open sql"

i did all suggestion from the net but still i can't solve it.
Any help is higly appreciated.

thanks
Meynard

<% 
Session("GB_DATABASE") = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_db/links.mdb")  
Set Conn = Server.CreateObject("ADODB.Connection")  
Conn.Mode = 3
Conn.Open Session("GB_DATABASE")
%>
<%
Set myrec = Server.CreateObject ("ADODB.Recordset")
Set myrec.ActiveConnection = conn
Dim sql
sql = "select * from station WHERE name =" & Request.QueryString("neym")
myrec.CursorType = 3
myrec.Open sql
%>

[DrBunchman]

Hi Meynard,

Welcome to Bytes! I hope you find the site useful. Please take the time to read the Posting Guidelines. Please also wrap any code you print in CODE tags using the # button at the top of the editor window as they make your posts much easier to read.

The problem is that you haven't specified the connection you are using to open your recordset. Try the following instead:

myrec.Open sql, conn

Hope this helps,

Dr B

[Jerry Winston]

<% 
Session("GB_DATABASE") = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_db/links.mdb")  
Set Conn = Server.CreateObject("ADODB.Connection")  
Conn.Mode = 3
Conn.Open Session("GB_DATABASE")
%>

looks like you're missing your connectionstrin g. Use your session variable GB_DATABASE as the connection string. try this:

<% 
Session("GB_DATABASE") = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_db/links.mdb")  
Set Conn = Server.CreateObject("ADODB.Connection")  
Conn.Mode = 3
Conn.connectionstring Session("GB_DATABASE")
Conn.Open 
%>