0
asp.net database problems!!
New Here
,
/t5/dreamweaver-discussions/asp-net-database-problems/td-p/1043404
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
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
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
LATEST
/t5/dreamweaver-discussions/asp-net-database-problems/m-p/1043405#M174978
Aug 21, 2006
Aug 21, 2006
Copy link to clipboard
Copied
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
>
>
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
>
>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

