I have a SQL 2005 server that has my iMIS database. Unfortunately, iMIS requires that the compatibility mode of SQL be set to 80 (SQL 2000). I'm trying to use the function asi_SplitString in my code, but I get an error when I call it telling me to change the compatibility level to 90 (not supported by iMIS). I want to use the function so that I can easily search the multi-instance field setup in an iMIS demographics table.

I attended a Microsoft presentation last night on the new ADO.NET Entity Framework which was released on Monday (11 Aug 08) as part of VS 2008 SP1 and .NET Framework 3.5 SP1.

The essential idea is to allow developers to use LINQ to work against a conceptual model of the database instead of the physical model.

The Entity Framework uses two XML mappings

SSDL - Store Schema Definition Language (the physical schema)

We need to customize the web interface for our client. I am new in iMis, and our version is iMis15.
Seems simply change the master pages under /templates/masterpages/ folder doesn't affect the front-end look. However if I delete public.master, it reports error. If I put an empty public master page there, it still works as before I made the changes.
I notice all pages are inherited from Asi.Bae.Web.xxxx, does that mean we don't have any easy ways to modify the interface?

I'm trying to figure out how to call IQA Queries. Just for a test I'm trying to call a standard IQA query, pass a value, and read the results or dump into a data set etc...

I can't seem to find even a basic sample on this. Any help would be greatly appreciated.

A bit of help please? Questions would be:
- Am I even on the right track?
- Am I creating the container correctly?
- Does the container need to be further initialized?
- Am I using the QueryBuilder correctly?
- How do I add the parameter to this querybuilder? I see just one key
- Am I executing the QueryBuilder correctly?

SAMPLE CODE,

    public void callIQA()
    {
        //Create the container using a common standard query anyone with iMIS should have
        Asi.Business.BusinessContainer myContainer;
        myContainer = new Asi.Business.BusinessContainer("$.Common.Queries.Search.CsContact.Name");

        //Does something else need to be done to finish initializing the container?


        //Make a querybuilder to be able to execute the query?
        Asi.QueryBuilder.Query myQuery = Asi.QueryBuilder.Query.NewQuery(myContainer);


        //If everything so far is correct, how is the string key formatted for adding parameters? 
        //Example, the above built in container has a possible 'Name' that can be added.  What would
        //be entered to pass the query a   [Last First]=DOE
        //NOTE: the above CsContact.Name sample requires [Last First] to be provided at least one value

        //myQuery.Parameters.Clear();
        //myQuery.Parameters.Add("string key");


        //Execute the query, and see what we get, which is nothing, something's wrong
        System.Data.OleDb.OleDbDataReader myReader;
        myReader = myQuery.GetList();

        if (myReader != null)
        {
            while (myReader.Read())
            {
                Response.Write("  

We are on iMis15 and need to be able to have “new members” join through the web. Once the non-member pays membership fees then be able to register to our conference as members. Has anyone done that ?

I’ve added a page to IC for recording details of release schedules for software used by iMIS – for example the next versions of Microsoft SQL Server or Microsoft Office.

http://www.imiscommunity.com/microsoft_and_other_vendor_software_release...

If you come across any information on release schedules for products that we use or integrate with can you update it here.

I found this here - it is pretty useful

http://weblogs.asp.net/bradleyb/archive/2005/12/09/432802.aspx

This is how to add a command to the shell to open a folder as a web site in Visual Studio 2005 or 2008.

Visual Studio 2005/2008 does not support this by default but you can enable the scenario by writing a macro.

To do this, create a new macro either in an existing module or in a new module. For this example I’m going to add a module call Website to the MyMacros project.

Passing this exam gives you MCTS – SQL Server 2005 certification. It’s a prerequisite for the MCITP: DBAdmin cert, but it’s not an elective for MCPD (unlike the 70-229 SQL 2000 exam for MCSD).

The Transcender test is available on DEVEXAM, and it’s helpful. It includes simulations that work like the ones on the actual test. I also used the ExamCram book by Thomas Moore, which had good test-specific material. I’ll pass it on to Mark D. for the Dev library.

I just passed my first in the Microsoft .NET Framework 2.0 series of exams, MCTS 70-528 "Microsoft .NET Framework 2.0 Web-Based Client Develoment". This is one of the two tests required for MCTS .NET Framework 2.0 Web Applications certification. The other test required for this cert is MCTS 70-536 "Microsoft .NET Framework 2.0 Application Development Foundation", which I'm planning to take sometime soon.

Problem Description
I have a problem with iBO.COM inserts in SQL 2005 on an Australian server.

We have a live and a test site, with respective databases.

The live site is showing this in the SQL trace when iBODataServer user connects. Inserts work.

- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on