ODBC call Failed Error

[dupati1]

Hi all,

I have replicated a DB (Access 2000 DB application using SQL Server 2000 as backend)and when i open the database and click on the drop down boxes on the forms i get a error message saying:

"ODBC-call failed
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'of'.(#156) "

But when i run the original design master it works perfectly fine.

Any Suggestions.

Thanks

VJ

 

[mission2java_78]

You asked this same question on the SQL Server forums.

You need to provide an ODBC connection to the database. Have you set one up?

 

[dupati1]

Thanks for the reply.

I havent set up ODBC connection. Could you please guide me on how to set up the ODBC connection.

Thanks

VJ

 

[mission2java_78]

Thanks for the reply.

I havent set up ODBC connection. Could you please guide me on how to set up the ODBC connection.

Thanks

VJ

start-settings->control panel->administrative tools->Data Sources (ODBC)

Answer the questions.

 

[dupati1]

Thanks,

Got it working.

Vj