Hi people i am busy writing a monitoring website Using ASP,the website need to get data from netbotz cams via SNMP. now i thought it would be a interesting subject to talk about if it is possible to query data straight from the cam using ASP or SQL and if not then how would you retrieve the data from the cams?

add

\0TRUSTED_CONNECTION

to your

SQLConfigDataSource

attributes

if you mean by not using code do you mean C# or SQL Code

it is easier to send the email using a stored procedure in SQL Server that is scheduled a job to send it if this is not the way you want to go please explain to me in more detail and ill try to help you

so this problem doesn't happen when you connect to the localhost but when you try from a other pc to connect to the server it doesn't work?

then i realy dont know sorry mate you will have to ask vs support on microsoft

ok i think i have a answer for you if you create a project and just run it. vs saves it in this temp folder as a read only file and if you try to edit it after you ran it then it can]'t be edited anymore try running the project first time then stop the program then save it as a other project name in a other folder then try editing it again if it still gives you the same error try saving it in a folder you choose from the start and then run it then try editing it again

and can you paste me a copy of the hole error message plz

Have You posted a message about this error on Microsoft yet?

Hi, We have event-based data currently being logged in relational database structures. For various reasons this data need to be stored elsewhere, possibly on our existing PI historian database. We need to ascertain whether PI can relatively easily store this type of event based data, and ultimately produce reports using RT Web Parts, also relatively easily. If not, we would rather log it in a SQL Server database. 1. This data are obtained via a SSIS package from flat files and stored in a SQL server database. 2. Currently we have around 550 event based jobs running parallel typically on a daily basis. 3. This constitutes in approximately 100 000 records every 5 minutes being logged. That’s more or less 350 records every single second. 4. These events are currently sorted on a BigInt type incremented number from low to high. Can PI log values at a micro sub second level so that the values can be displayed in the correct order it was logged? Or are there some other way to do this? 5. Note that EvTime only saves at second level. EvSeqNo is necessary here to sort the data sequentially, as many records are logged per second. 6. Can Pi handle this huge influx of data? 7. A sequence can constitute a various number of events, from starting that sequence by starting a job by an operator, holding or diverting it. Starting, holding, diverting and so forth constitutes an event. There are various other events as well 8. A job can start another job as well. 9. EvJob, EvLevel, EvLabel, EvKey,EvText, EvSeqNo are all stored in separate database columns. Must this be concatenated into one delimited string or is there an easier way to store the data in PI? 10. EVJob should typically the tag name. However when a job is started by an operator EVJOb can be something like :Citect which means that the actual job being started must be retrieved from the EvText string. 11. Once all this data is being logged, can it easily be retrieved to display in reports using RT Web Parts?