Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

asp.net database problems!!

New Here ,
Aug 19, 2006 Aug 19, 2006

Copy link to clipboard

Copied

hi everyone

I'm trying to set up a shopping cart to go with my dreamweaver mx 2004. I was previously using ASP. VBScript and the program i'm using for the shopping cart requires ASP.NET.


I'm not very familiar with how ASP.NET works, so I'm feeling pretty lost.

I've tried to set up my database to work with the website in much the same way as the VBScript site - I've defined it in the Applications- Database - OLE DB Connection
I'm using Access

The connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\TheWarLord\main.mdb"

and the database connection works, everything is all good BUT

when i try to made a dataset for a results page, I select the database (main) but the TABLE column shows *** No Table Found

I have one table in the database, so it should show up.

Can someone please help me figure out why this is happening?

thanks so much!!
Ness
TOPICS
Server side applications

Views

201
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 21, 2006 Aug 21, 2006

Copy link to clipboard

Copied

LATEST
You have two potential problems here.

The connection issue is probably caused by an issue that was introduced in
Windows XP SP2, for which you need to download a patch from the Adobe site.
So a search for the term "Localhost + SP2"

The bigger issue is that unless your shopping cart has been written to use
the Macromedia version of ASP.Net controls then you may run into problems
bringing them together.


--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"nesnrus" <webforumsuser@macromedia.com> wrote in message
news:ec8f4f$q6s$1@forums.macromedia.com...
> hi everyone
>
> I'm trying to set up a shopping cart to go with my dreamweaver mx 2004. I
> was
> previously using ASP. VBScript and the program i'm using for the shopping
> cart
> requires ASP.NET.
>
>
> I'm not very familiar with how ASP.NET works, so I'm feeling pretty lost.
>
> I've tried to set up my database to work with the website in much the same
> way
> as the VBScript site - I've defined it in the Applications- Database - OLE
> DB
> Connection
> I'm using Access
>
> The connection string is
> "Provider=Microsoft.Jet.OLEDB.4.0;
> Data Source=C:\Inetpub\wwwroot\TheWarLord\main.mdb"
>
> and the database connection works, everything is all good BUT
>
> when i try to made a dataset for a results page, I select the database
> (main)
> but the TABLE column shows *** No Table Found
>
> I have one table in the database, so it should show up.
>
> Can someone please help me figure out why this is happening?
>
> thanks so much!!
> Ness
>
>


Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines