PDA

View Full Version : ERROR 4104 As below - Help please



kelly
25-Aug-2010, 09:44 PM
Hello All,

Please can someone help us.

Error 4104 (odbc)(sql server) Multi part Identifier {Field} can not be bound

I am trying to write a report in Visual Report Writer and I keep on getting this error on Preview (@ design time) Can you please tell me what I am doing wrong. I setup this odbc connection and have used it successfully in another report

Thanks
Kelly

Vincent Oorsprong
26-Aug-2010, 12:49 AM
Kelly,

Can you please go to the Show SQL Query window after the error and copy the generated SQL statement? Can you also script the table definition and send both to support@dataaccess.eu ?

kelly
2-Sep-2010, 03:30 PM
Hello Vincent.

Sorry i have just been playing with VRW myself and have come up with the same error code but it has different details. I have finally worked out what you meant by the Show SQL so i have got that and also have put the table definitions on to an email and have sent it to the email address you have given me.

Look forward to your urgent reply.

Thanks
Kelly

kelly
16-Sep-2010, 06:59 PM
Hello, we have solved the problem. I was unaware that you had to click on the field you wanted to link and then drag it to the one you wanted to link it to. Problem solved.

Thanks,
Kelly