Crystal Report using ODBC datasource with acess database.

[Former Member]

I have designed a Crystal Report which uses ODBC to connect to Access database,

report uses a query created which accepts parameter. But when i run the report it shows error as

"ODBC error:[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

[Former Member · Accepted solution]

Hi

Are you creating a Command object with parameters and when you click on Ok, it throws the error?

In this case, you need to check the SQL statement that you have written in the Command object as SQL is a bit different from what we use normally.

You can refer to this [PDF|http://www.informit.com/content/images/0789734176/downloads/AppendixA.pdf] to know the SQL syntax that works with Crystal Reports.

Hope this helps!!

Regards

Sourashree

[Former Member · Accepted solution]

Hi,

I have created a query in access97 which accepts one parameter.

Now i am creating a report using crystal report version 8.5, which uses this parameterized query.

Database is connected using ODBC as a datasource.

But when I refresh the report it throws me error as "ODBC error:[Microsoft][ODBC Microsoft Access Driver]Too few parameters.Expected 1."

Is there any other way of doing this.

Regards,

Viresh

[Former Member · Accepted solution]

Hi

It appears that Seagate Crystal Reports can no't report off Access tables containing parenthesis via an ODBC connection. The error does not occur if you connect to the database using the native driver.

Thanks

Shraddha

[Former Member]

Hi,

Do a small test to test your connection.

-Right Click on desktop ->

Create new text document->

Save as test.UDL->

double click and test connection by selecting driver name,datasource name,user id and password.

Click on Test Connection.

It should be succeed.

-Test DSN is properly created or not.

-Try to update database drivers.

Regards,

Shweta

[Former Member]

Hi,

Thanks for reply

DSN connected successfully,

I tried the report on two machines, but same results.

Regards,

Viresh