Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13619

Re: OLEDB syntax problems

From Neil <neil@myplaceofwork.com>
Newsgroups comp.databases.ms-access
Subject Re: OLEDB syntax problems
Date 2019-05-07 08:17 -0400
Organization A noiseless patient Spider
Message-ID <qart02$6tb$1@dont-email.me> (permalink)
References (5 earlier) <qainnf$m6q$1@dont-email.me> <qajrls$oq6$1@dont-email.me> <qakqpi$lvq$1@dont-email.me> <qapsis$e56$1@dont-email.me> <qapvet$lh$1@dont-email.me>

Show all headers | View raw

On 5/6/2019 2:46 PM, Ron Weiner wrote:
> 
> Can you post the Connection string are using to connect your app to the 
> Access Db, and the code your app is executing the sql?
> 
> I am pretty sure that ACE.OLEDB does work with ADO, but without seeing 
> your apps code that ececutes the query, and the Connection string you 
> are using, it is impossible from me to make an attempt at a Repro.
> 
> Rdub
> 

Connection String:
     Dst = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source= " & 
Server.MapPath("\[to dB file]\dBFile.accdb") & ";"

Command Syntax:
     rsx = "INSERT INTO [dBFile] (LogIn, Admin, Action) VALUES ('" & 
LogVal & "', '" & WhoAdm & "', '" & DidWhat & "') & ";"

     set DoConn = Server.CreateObject("ADODB.Connection")
     DoConn.ConnectionString = Dst
     DoConn.open

     Set DoCmd=Server.CreateObject("ADODB.command")
     WITH DoCmd
         .CommandText=rsx
         .CommandType=1
         set .ActiveConnection=DoConn
     END WITH

     DoCmd.Execute , , 128

     DoConn.Close
     set DoConn=Nothing
     set DoCmd=Nothing


-- 
best regards,

Neil

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 09:56 -0400
  Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-02 11:15 -0400
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 17:38 -0400
  Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-02 12:33 -0700
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 17:45 -0400
      Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-03 05:25 -0700
        Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-03 08:48 -0400
          Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-03 20:51 -0400
            Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-04 07:05 -0400
              Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-04 15:43 -0400
              Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-04 15:56 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-04 18:57 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-06 13:57 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-06 14:46 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 08:17 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 06:32 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 10:49 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 07:54 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 11:17 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 08:46 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 12:18 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 10:28 -0700
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-07 16:34 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 17:16 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-08 12:58 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 13:20 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-08 14:24 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 15:34 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-09 15:36 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-07 16:49 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 17:18 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-06 12:33 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-06 15:52 -0400
  Re: OLEDB syntax problems FreeToGolfAndSki <genoagroup@gmail.com> - 2019-05-08 06:41 -0700
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 13:26 -0400

csiph-web