Recordset for saving file

Results 1 to 2 of 2

Thread: Recordset for saving file

  1. #1
    Join Date
    Dec 1969

    Default Recordset for saving file

    Hi, i&#039m having trouble opening a recordset for saving a file. Could someone please tell me the open string for doing so.<BR><BR>Error Type:<BR>ADODB.Recordset (0x800A0E7D)<BR>Operation is not allowed on an object referencing a closed or invalid connection.<BR><BR>*****************************<B R>Const adUseClient = 3<BR>Const adOpenStatic = 3<BR>Const adVarChar = 200 <BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Cu rsorType = adOpenStatic<BR>objRS.CursorLocation = adUseClient<BR>objRS.Open<BR>objRS.Save "images/people/" & file<BR>******************************

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset for saving file

    You need to reference an open connection or include a valid connection string and some indication of how to open it in your statement.<BR><BR> "select * from sometable", "Provider=Microsoft.Jet.3.51;User ID=Admin;Password=;Data Source=c:dbfilesmydb.mdb", 1, 1, 1<BR> "filename", saveformat (0 for advanced tablegram; 1 for xml)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts