Registration

[IPconfig]

where in the sql server does it keep it's info on the License ID and the company name which has purchased/used it's software? I am currently having a slight problem with this at the moment , the sql server cant seem to pick up the License ID and the Company so i cant save anything at the moment.
[Error]

Error Validating changes: [Microsoft][OBDC SQL Server Driver][SQL Server] Invalid object name 'Licenses'. [SELECT Company License ID FROM Licenses]

from this error i assume that the sql engine is trying to pick up the License and company name from it's db, i have not written any sql statement's at the moment i have just tried to save a configuration of an entity that is running over the sql server and it is closely bonded with the sql server. So my query is do i have to create a table with a License ID and Company Field or does the software place it somewhere within the db , i would really appreciate some help on this .

thx

 

[foxdev]

i have just tried to save a configuration of an entity that is running over the sql server and it is closely bonded with the sql server

My guess is that it is this other application, which apparently uses SQL Server as its database (perhaps like Commerce Server), that is not finding its own data, rather than SQL Server itself. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[IPconfig]

so what do you suggest i should do for this !! what would be my next option

 

[tlbroadbent]

SQL Server is telling you that the Table (or view) named Licenses doesn't exist in the current database. I'm not aware of any standard SQL Server table named Licenses. As Robert said the application you are running is the likely culprit. Which application are you running when you get the error message? Knowing this would help us help you.

I do have one suggestion. Examine the SQL Server to determine if any of the databases contains a table named Licenses. If you find the database, then modify the DSN for the ODBC connection to make sure it opens in that database. Then rerun your application. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[IPconfig]

[snip]

Which application are you running when you get the error message? Knowing this would help us help you
[/snip]

I have installed EZACCE$$( pre-paid internet software)

http://www.aspintl.com

if you wish to have a look.
well now on installation it installs a EZACCE$$ db plus a RadiusNT db , all these go into the sql server , so what happens is after i have to create a DSN for Radius to communicate with sql server ..when i do the test's it tells me tests successful, where the error comes about is when i am using the web interface to configure the RadiusNT after configuring and then trying to save the configs i get that error , someone had told me something similar i.e probably not having a License table , but i assumed if i am to have one would'nt that be a default install or something after setting up the db's since thats where it tries to pick up the info ...? i looked into the db's that it uses but i did not see a table called licenses, so i am not sure what to do next..!! i hope this gives you an almost or clear picture of what i am trying to achive..

thx