Post reply

Cube Editor Error

  • October 29, 2003 at 7:52 am

    #106742

    Hello everyone:

    When I attempt to process a cube, I'm receiving the following error:

    Data source provider error: [Microsoft]

    [ODBC Microsoft Access Driver] Too few

    parameters. Expected 1.

    From my research, MDAC 2.1 cannot process a SELECT statement on columns with double quotes, but could with single quotes which it's doing. My question is this, is there a way I can edit the Process Cube function and replace the double quotes (") with single quotes (')?

    Thank you for your help on this.

    Peter

    Peter M. Florenzano

    Database Administrator

  • October 30, 2003 at 2:37 am

    #480255

    Probably some way to force it in the extended properties of the connection string...

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

  • October 30, 2003 at 7:10 am

    #480294

    Hi Keith,

    Where can I find the extended propertied for the connect string?

    Thanks,

    Peter

    Peter M. Florenzano

    Database Administrator

  • October 31, 2003 at 1:44 am

    #480409

    Right click the database connection and its the last tab along the top. What you can put in there involves trawling through the OLEDB for SQL server documentation.

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

  • November 3, 2003 at 10:01 am

    #480680

    Hi Keith,

    Thank you for the info. I'm not sure what value to put into the 'Data Link Properties' when I right click on the Data Source name and click on 'Edit Value'.

    Any information would be greatly appreciated.

    Peter

    Peter M. Florenzano

    Database Administrator

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply