Hi Arnie,
what is the data tpe of your TimeStamp column in Access?
I have just been experimenting with an Access database where the Timestamp
column was a 'Number' (ie an int in SQL talk) with no problem .
Cheers.
On Jul 19, 12:37pm, Arnie Roberts wrote:
> Subject: RE: (RADIATOR) Microsoft Access problems
> On Sunday, July 18, 1999 1:36 AM, Aaron Miles
[SMTP:[EMAIL PROTECTED]] wrote:
> > Arnie,
> > Try no ' marks for the numbers as they are not needed, this
> > could be even if the output field is text. Try this anyway :-)
> >
> >
> > Cheers.
> > Aaron
>
> Aaron,
>
> Do you mean have timestamp set as an integer? as in
>
> AcctColumnDef TimeStamp,Timestamp,integer
>
> problem stays the same
>
> DBD::ODBC::db do failed: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
err
> or in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
at R
> adius/SqlDb.pm line 189.
> Mon Jul 19 12:10:25 1999: ERR: do failed for 'insert into Users199907
> (UserName, NasIPAddress, InputOctets, ServiceType,
OutputOctets,
> SessionTime, TimeStamp)
> values
> ('test', '193.129.12.232', 134, 'Framed-User', 132, 50,
93238262
> 3)': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO
st
> atement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
>
> Is anyone using Access successfully and including the Timestamp?
>
> Arnie
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Arnie Roberts
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.