Robert Rodgers
|
Posted: 05/15/2002, 5:00 PM |
|
Hi all,
Using Studio Beta 3
MSSQL7
ASP+Templates
WIN2k Server
Local Network
I keep getting this error on the Bugtrack example app
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The column 'project_id' was specified multiple times for 'cnt'.
/bugtrack/Classes.asp, line 1412
And this error on the
EmplDir example app.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The column 'department_id' was specified multiple times for 'cnt'.
/empldir/Classes.asp, line 1412
I am guessing it is something I am doing but I haven't figured it out. has
anyone seen this before?
Thanks.
Rob
|
|
|
Robert Rodgers
|
Posted: 05/15/2002, 5:03 PM |
|
Those errors happen when trying to open the default.asp page
"Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
news:abusr7$8vu$1@news.codecharge.com...
> Hi all,
>
> Using Studio Beta 3
> MSSQL7
> ASP+Templates
> WIN2k Server
> Local Network
>
> I keep getting this error on the Bugtrack example app
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> The column 'project_id' was specified multiple times for 'cnt'.
> /bugtrack/Classes.asp, line 1412
>
>
> And this error on the
> EmplDir example app.
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> The column 'department_id' was specified multiple times for 'cnt'.
> /empldir/Classes.asp, line 1412
>
> I am guessing it is something I am doing but I haven't figured it out.
has
> anyone seen this before?
>
> Thanks.
> Rob
>
>
|
|
|
Alexey Alexapolsky
|
Posted: 05/16/2002, 2:30 AM |
|
Did you modify this example ?
--
Alex
CodeCharge Developer
"Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
news:abusr7$8vu$1@news.codecharge.com...
> Hi all,
>
> Using Studio Beta 3
> MSSQL7
> ASP+Templates
> WIN2k Server
> Local Network
>
> I keep getting this error on the Bugtrack example app
>
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> The column 'project_id' was specified multiple times for 'cnt'.
> /bugtrack/Classes.asp, line 1412
>
>
> And this error on the
> EmplDir example app.
> Error Type:
> Microsoft OLE DB Provider for SQL Server (0x80040E14)
> The column 'department_id' was specified multiple times for 'cnt'.
> /empldir/Classes.asp, line 1412
>
> I am guessing it is something I am doing but I haven't figured it out.
has
> anyone seen this before?
>
> Thanks.
> Rob
>
>
|
|
|
Robert Rodgers
|
Posted: 05/16/2002, 5:54 AM |
|
Only the connection settings. I even uninstalled and reinstalled CC Studio
and the DB twice. Still no go.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:abvu7h$3t3$2@news.codecharge.com...
> Did you modify this example ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
>news:abusr7$8vu$1@news.codecharge.com...
> > Hi all,
> >
> > Using Studio Beta 3
> > MSSQL7
> > ASP+Templates
> > WIN2k Server
> > Local Network
> >
> > I keep getting this error on the Bugtrack example app
> >
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80040E14)
> > The column 'project_id' was specified multiple times for 'cnt'.
> > /bugtrack/Classes.asp, line 1412
> >
> >
> > And this error on the
> > EmplDir example app.
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80040E14)
> > The column 'department_id' was specified multiple times for 'cnt'.
> > /empldir/Classes.asp, line 1412
> >
> > I am guessing it is something I am doing but I haven't figured it out.
> has
> > anyone seen this before?
> >
> > Thanks.
> > Rob
> >
> >
>
>
|
|
|
Robert Rodgers
|
Posted: 05/16/2002, 1:24 PM |
|
Alexey,
Ok, After doing the tutorial I figured out what the problem was.
For the grid on the default page. For both of the example projects
mentioned. The Data source was incomplete.
On a newly installed CC Studio Beta 3 I went to the Default.asp; Emps Grid;
Data Source. I pressed the Select Query button and the table diagram did
not have any columns selected. After selecting the proper columns the error
went away.
Anyway it works ok now
Thanks for your help.
Rob
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:abvu7h$3t3$2@news.codecharge.com...
> Did you modify this example ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
>news:abusr7$8vu$1@news.codecharge.com...
> > Hi all,
> >
> > Using Studio Beta 3
> > MSSQL7
> > ASP+Templates
> > WIN2k Server
> > Local Network
> >
> > I keep getting this error on the Bugtrack example app
> >
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80040E14)
> > The column 'project_id' was specified multiple times for 'cnt'.
> > /bugtrack/Classes.asp, line 1412
> >
> >
> > And this error on the
> > EmplDir example app.
> > Error Type:
> > Microsoft OLE DB Provider for SQL Server (0x80040E14)
> > The column 'department_id' was specified multiple times for 'cnt'.
> > /empldir/Classes.asp, line 1412
> >
> > I am guessing it is something I am doing but I haven't figured it out.
> has
> > anyone seen this before?
> >
> > Thanks.
> > Rob
> >
> >
>
>
|
|
|
|