Hi,

  I am using Microsoft access for the database.I am using the following 

code.

<%

dim strConn

set strConn= Server.CreateObject("ADODB.Connection")

strConn.Open "FILEDSN=fpsun"

 SQL_query = "SELECT image From fpsun where firstname 

like '%"&firstname&"%'"

 Set RS = strConn.Execute(SQL_query)

 WHILE NOT RS.EOF

%>

 <%

 image=RS("image")

 RS.MoveNext

 WEND

 RS.Close

 strConn.Close

%>



but when i execute the above code i get the following error



Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 



[Microsoft][ODBC Microsoft Access Driver] Internal OLE Automation error 



can anyone please help me why i am getting the above error

Regards

urmi

urmilla



i think there is a problem with dsn which u created.



try with this dsn less code



set con=server.CreateObject("ADODB.connection")

 Con.Open "DBQ=" & Server.Mappath("db/magsdb.mdb") &

";Driver={Microsoft Access Driver (*.mdb)}; "



still if u r not getting let me know soon.







--- urmilla <urmi_tikoo@m...> wrote:

> Hi,

>   I am using Microsoft access for the database.I am using

> the following 

> code.

> <%

> dim strConn

> set strConn= Server.CreateObject("ADODB.Connection")

> strConn.Open "FILEDSN=fpsun"

>  SQL_query = "SELECT image From fpsun where firstname 

> like '%"&firstname&"%'"

>  Set RS = strConn.Execute(SQL_query)

>  WHILE NOT RS.EOF

> %>

>  <%

>  image=RS("image")

>  RS.MoveNext

>  WEND

>  RS.Close

>  strConn.Close

> %>

> 

> but when i execute the above code i get the following

> error

> 

> Microsoft OLE DB Provider for ODBC Drivers error

> '80040e07' 

> 

> [Microsoft][ODBC Microsoft Access Driver] Internal OLE

> Automation error 

> 

> can anyone please help me why i am getting the above

> error

> Regards

> urmi

> 

>