I am running asp runner on a MySQL database running on a Windows 2000 machine. I've been using this for about 6 weeks now and now I start getting these
annoying error message when I create a new table:
Cannot retrieve columns information. Please modify SQL query and try again.
This happens only on new tables moving from step 5 of 12 to step 6.
My code looks like this:
select System,
Owner_Initials,
Contact_Number,
Group,
Date_From,
Date_To,
General_Time,
Project_Number,
Test_Notes
From inhouse_sys_sched
The only way to get past this error message at this point is to change the code to:
select *
From inhouse_sys_sched
This gets me through all the steps of ASPRunner but then then I get an ASP error:
Error number -2147217900
with an abvious cause:
select Index, * From inhouse_syssched
Existing tables works just fine so I suspect that the problem does not lie with ASPRunner but any other interfaces gets the data from my database and the new tables, so I'm stumped as to the reason for this error message.
Can anyone shed some light on this for me. Any help or pointers will be appreciated.
Thanks in advance
