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 .
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
> 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
> or in INSERT INTO statement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
> adius/SqlDb.pm line 189.
> Mon Jul 19 12:10:25 1999: ERR: do failed for 'insert into Users199907
> (UserName, NasIPAddress, InputOctets, ServiceType,
> SessionTime, TimeStamp)
> ('test', '22.214.171.124', 134, 'Framed-User', 132, 50,
> 3)': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO
> atement. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1)
> Is anyone using Access successfully and including the Timestamp?
> 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,
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.