"Failed to get schema!"

I have entered an sql demand in the wizard of a grid view for a table (on a form). But i cannot go any further because it gives me the message ... "Failed to get schema!"...

A frined came over by and with him, it worked...

the sql is correct, it calculates sums based on the dates of another table... let me show it:

INSERT INTO SumeU
(ID_var_u, s_x, s_y, s_xx, s_yy, s_xy)
SELECT ID_var_u, SUM(val_x) AS sx, SUM(val_y) AS sy, SUM(val_x * val_x) AS sxx, SUM(val_y * val_y) AS syy, SUM(val_x * val_y) AS sxy
FROM DateU
GROUP BY ID_var_u

"ID_var_u" connects the two tables to another one called "model" (where it is primary key)

Now... please help me... again!

Sounds like a security issue, I'll move your question to a SQL forum for a better answer...
|||

The message you mentioned does not resemble any SQL Server error message. Is that copied verbatim or from memory? Can you post the actual error message?

Thanks
Laurentiu

"Failed to create web application" error during installation of SQL 2k5b2

I was installing SSRS 2005 Beta 2 and near completion of the installation, i encountered the following error. I don't know what causes this. How can i avoid this? I've installed the rest of the whole SQL 2K5 package.

Machine : xxxxx
Product : Microsoft SQL Server 2005 Reporting Services Beta 2
Product Version : 9.00.852
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0017_xxxxxx_RS.log
Last Action : InstallFinalize
Error String : The setup failed to create web application: /LM/W3SVC/1/Root/Reports. The error code is -2146959355.

Ok its working now. the MS DTC was enabled but not all its options were selected. I selected all of them, and reinstalled it worked.

If there's anyone just as blurr as i am, its available in WinXP thru the

Administrative tools > Component Services option.

In the left console, Expand 'Console Root > Component Services > Computers'. You should see My Computer as the next node.

The funny thing is, on my pc, when right-clicking on My Computer, i couldn't see the 'Properties' option. I had to click 'Configure My Computer' button at the toolbar (should be the last button) to enable MS DTC. AFter that , the properties option was visible on the menu.

Hope this helps anyone who might face this problem.

"Failed to acquire connection" when running a package from within another package.

I am receiving an error on my master package that executes a number of other packages. The individual packages work fine when executed by themselves. However, I am getting the following error when I attempt to execute it from another package:

Error: Failed to acquire connection "conneciton". Connection may not be configured correctly or you may not have the right permissions on this connection.

Thanks in advance for your help.

You could use this technique: http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx to help diagnose why your package is failing.

-Jamie