 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / September 2007La méthode 'Open' de l'objet '_Recordset' a échoué
Erreur d'exécution '-2147467259 (80004005)' La méthode 'Open' de l'objet '_Recordset' a échoué J'obtiens ce message d'erreur sur l'instruction suivante : Rs.Open sqlStr, Cnn, adOpenForwardOnly, , adCmdText Quelqu'un peut-il m'aider ? Merci. "Hassan" <aamrane@menara.ma>'s wild thoughts were released on Thu, 20 Sep 2007 10:20:50 -0000 bearing the following fruit: > Erreur d'exécution '-2147467259 (80004005)' > La méthode 'Open' de l'objet '_Recordset' a échoué [quoted text clipped - 6 lines] > >Merci. Show us where you dim Rs and cnn Are you sure you have a valid connection? And finally show us what sqlStr contains -- Jan Hyde https://mvp.support.microsoft.com/profile/Jan.Hyde Dim Rs as new ADODB.Recordset I have a valid connection. i use it before this instruction to read others tables. Thinks. > "Hassan" <aamrane@menara.ma>'s wild thoughts were released > on Thu, 20 Sep 2007 10:20:50 -0000 bearing the following [quoted text clipped - 21 lines] > > https://mvp.support.microsoft.com/profile/Jan.Hyde "Hassan" <aamrane@menara.ma>'s wild thoughts were released on Thu, 20 Sep 2007 15:10:24 -0000 bearing the following fruit: >Dim Rs as new ADODB.Recordset > >I have a valid connection. i use it before this instruction to read others >tables. > >Thinks. 'And finally show us what sqlStr contains' >> "Hassan" <aamrane@menara.ma>'s wild thoughts were released >> on Thu, 20 Sep 2007 10:20:50 -0000 bearing the following [quoted text clipped - 21 lines] >> >> https://mvp.support.microsoft.com/profile/Jan.Hyde -- Jan Hyde https://mvp.support.microsoft.com/profile/Jan.Hyde with sqlstr = "SELECT * FROM ...". It's works. but with sqlstr = "SELECT field1, field2, ... FROM" It's not works ! I found the problem. I used the words 'Input' and 'Output' as Alias in Select : Select field2 as Input, filed2 as Output,... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.