Strange SQL error when starting VCServer

[Former Member]

Hello,

I just installed the Visual Composer Server on the same box as my EP6SP2.

When I, from a client, tries to access http://server/VCServer/ the application starts up, and launches a window where I must make a new model. If i here tries to enter anything in any of the text-fields, it comes up with an errormessage:

ERROR

-

---

SQL Query "SELECT m.ID, m.login_name, m.kit_name, m.kit_version, r.name, owner FROM MODELS m, RULES r WHERE r.id = m.owner_id ORDER BY login_name" in invalid:

[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid columb name 'id'.

The MSSQL database seems to be created during installation with no problems. The MSSQL 2000 is running SP3.

Any help and directions would be appreciated.

Jonas

[Former Member]

Hi!

we have the same problem and we have try to apply your suggestions but with the same result.

We have EP sp11 with windows 2003.

another idea?

thanks

Regards,

María Jesus

[Former Member]

Hi All

I used to get this error when I installed VC on Windows XP SP1 and is connected to MS SQL 2000 (SP3).

The reason was that the MDAC components where not upto date. Hence I had to upgrade my system to SP2 level with the latest version of MDAC. After that everything worked fine.

I strongly recommend the usage of the following tools to figure out such problems:

1)MICROSOFT MDAC COMPONENT CHECKER

2)Visual Composer Analyser - This is just an executable HTML file where you may need to add a few log lines to get a better result.

Regards

Manu

[darren_hague]

Hi Jonas,

I just solved this one (finally!) - when you create the "VCDB" database in SQL server, the database name must be in CAPS, otherwise no tables get created by the installer.

Cheers,

Darren

[Former Member]

If reinstalling does not help, please open a CSN message.

Gabi Koifman

Dev. support

[Lisi]

Hi Jonas,

Did you install all the Visual Composer prerequisites on the client machine? (MSXML 4.0, SVG Viewer 3.0)

Regards,

Lisi

Message was edited by: Elizabeth Gutt

[Former Member]

Yes.

MS XML 4 and Adobe SVG Viewer is installed. The Visual Composer UI starts up with no problems, so it seems to be an error somewhere on the server it self?

Regards

Jonas Daugaard

[Former Member]

Hi,

This indeed seems to be a server problem.

Did you install the VC patches that were released?

Lior

[Former Member]

I just found that the new patch 3 is out, so my plan is to apply this tomorrow, and hopefully this will fix my problem. I will keep you updated

Regards

[Former Member]

Okay, applying patch 3 still does not solve my initial problem with the SQL-error. I will now try to reinstall the whole VCServer setup, and hopefully that will help.