2. ASPRunnerPro General questions
  3. Ambiguous Column
This topic is locked

Ambiguous Column

 		7/29/2007 8:19:49 PM
ASPRunnerPro General questions
M
 mfred author

I am transfering an application to a different server. I setup the tables in the ms sql just as on the original server. However, I am getting an error for 1 column. It says "Microsoft OLE DB Provider for SQL Server error '80040e14' Ambiguous column name 'Permission'. ". Can you help me to define this error?
Sergey Kornilov admin 7/30/2007

What is the SQL query that you use and which page gives you this error?
M
 		mfred author 7/30/2007

The column 'Permission' is simply a column in the table. The page given the error is the add page as I go to it.
Sergey Kornilov admin 7/30/2007

This info is not enough.
M
 		mfred author 8/1/2007

Looking closer into it, it appears to be involved with the lookup wizard. The original permission field uses a permission field in a separate table for the lookup menu. When I change the field to a text foeld, I do not get the error message. When I turn the field back to a lookup menu, I get the error message. However, the lookup works fine on the original server.
Sergey Kornilov admin 8/1/2007

It looks like something is different on the database side.
Try to publish your app to Demo Account. If you can reproduce this error there send the URL to support@xlinesoft.com.