Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: dsn less connection


Message #1 by "yogesh ajmire" <yogeshajmere@h...> on Wed, 2 Jan 2002 20:51:30
Dam, 



HEre u opened a connection but u have nither declared or opened recordset.

First set recordset using 

set Rs=Server.CreateObject("ADODB.Recordset")

then use 

Rs.ActiveConnection = dbObj 

Rs.CursorType = adOpenKeySet 

Rs.LockType = adLockOptimistic 

Rs.Source = "TABLENAME"

Rs.Open 

Also check whether the directory where u placed access database has write 

privileges for all users.



yogesh





> Hi I have a problem with my dsn les conection when i try to acces toit i 

> have this error:

> Microsoft JET Database Engine error '80040e4d' 

> Impossible to start this application.....

> 

> set dbobj=Server.CreateObject("ADODB.connection")

> 

>   

> 

ChainConn="Provider=Microsoft.JET.OLEDB.4.0;DataSource=D:\Inetpub\Bd\HxC.md

> b;User ID=xxx;Password=xxx;"

> 

>  dbobj.Open ChainConn

>  

>  do while not rsobj.eof

> 	Reponse.write rsobj.fields("nom_groupe")

>  rsobj.movenext

>  loop%>

> 

> Thanks.

>            Dam


  Return to Index