Re: [RadiusNT] Access to SQL (error when adding user account)

Josh Hillman ( (no email) )
Thu, 12 Oct 2000 08:37:36 -0400

If you're trying to insert (or update) the MasterAccounts.CustomerID field
via ISQL or Enterprise Manager, you can't--it's an auto-incrementing number
that's handled by SQL Server anytime a new row of data is added.

Josh

----- Original Message -----
From: "Steven E.Greenwalt Jr." <steven@ectisp.net>
To: "RadiusNT List" <radiusnt@iea-software.com>
Sent: Wednesday, October 11, 2000 6:10 PM
Subject: [RadiusNT] Access to SQL (error when adding user account)

> Back Ground:
> Radius 3.0.175
> SQL 6.5
> The Access database came from radius 3.0
> The users that I had in the original database can login, thorough SQL
>
> What I am trying to do is move my access data into SQL. That went will.
> But when I try to add a user through the SQL database I get this error.
> (The column CustomerID in table dbo.billing may not be null (#233))
>
> It does show to be link in the relationship for the data to be added to
> the billing table.
>
> I am filling in the Blank for billing.
>
> Has any one done what I am trying to do, and did you run into this
> problem?
>
> Thank You
> Steven
> ECTISP
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart