error

[Santhosh Kesav]

hi all,


am gettin error while export sql data to excel through c#.net windows application 2003, am getting this error ''Application' is an ambiguous reference" anybody help me to sove this error.......

[Stang02GT]

The ambiguous error usually means that you need to clarify where the data is. I had this problem with a SQL project in college and it was because i was trying to pull data and there was more then one table that had the data i was trying to pull.

Example:

If you had a select statement and where getting the ambiguous error....

SELECT last_name FROM employee

if that gave you the error chances are you have a customer table or something where there is a "last_name" field as well.

To fix this you need to specify which last_name you want....

SELECT employee.last_n ame FROM employee


So check to see if the data you are using could be in another table. Because thats where the error is coming from.

[Stang02GT]

Also if i wasn't clear let me know.

If you want you can also Google the error you are getting, and a lot of times it will bring up a lot of information about the error.

Good luck!