ASP.NET with database

[str8coding]

I am totally new to dynamic website development. I am currently trying to
develop a small business online catalog using Dreamweaver MX 2004.

I am using the ASP.NET C# model. I can successfully create a OLE DB
connection but the table listing does not appear under the database connection.
I tried to create a dataset using SQL commands on a table in know exists in
the database and a test returned the the fields from the table. Why is
dreamweaver telling me that there are no tables found. What am I doing
incorrectly.

I also tried using the ASP.NET VB model and the same thing happened. Any
suggestions would be greatly appreciated.

[PokerJIm]

I have the same problem usiing ASP.NET and VB. All is fine when I use
Dreamweaver and classic ASP and I built a test sight using Visual Studio and
connected to the DB without any problems.

You can download a Dreamweaver Extension called "WindowsXP SP2 DB Connectivity
Fix" Version 1.0.2 from the extensions area of this site but it didn't correct
the problem for me. I'd be interested to no if it helps you.

I contacted Support on April 30th with this problem. I got an automated
response stating that I would recieve a reply within 8 business hours but I
haven't heard from them yet. I'll pass on that reply when I get it.

[str8coding]

Poker Jim, I'll give that download a try and let you know what happens.

[clintonG]

Macromedia may have been late with support but Adobe provides no support to
speak of. The extent of Adobe's support is posting to their crippleware
forum at adobe.com. I pity Macromedia's former customers.

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL [url]http://metromilwaukee.com/[/url]
URL [url]http://clintongallagher.metromilwaukee.com/[/url]


"PokerJIm" <webforumsuser@macromedia.com> wrote in message
news:d5bkue$79b$1@forums.macromedia.com...

>I have the same problem usiing ASP.NET and VB. All is fine when I use
> Dreamweaver and classic ASP and I built a test sight using Visual Studio
> and
> connected to the DB without any problems.
>
> You can download a Dreamweaver Extension called "WindowsXP SP2 DB
> Connectivity
> Fix" Version 1.0.2 from the extensions area of this site but it didn't
> correct
> the problem for me. I'd be interested to no if it helps you.
>
> I contacted Support on April 30th with this problem. I got an automated
> response stating that I would recieve a reply within 8 business hours but
> I
> haven't heard from them yet. I'll pass on that reply when I get it.
>
>

[PokerJIm]

Originally posted by: str8coding
Poker Jim, I'll give that download a try and let you know what happens.

With ASP.NET you may also have file permission problems as well. When I
encountered this connection problem I grabbed a Visual Studio, ASP.NET tutorial
off the web to see if I could connect to a database outside of Dreamweaver and
had to get the file permissions set right before the connection was successful.
I also found that it was much easier to connect to an Access DB than to SQL
Server. Google: ASP.NET and SQL Server if you need info about file permissions.

I'm kinda new at this too but I did compare the database connection string
created by Dreamweaver in the web.config file to the same string in the Visual
Studio site that works correctly and they are structurally identical.

[str8coding]

Dreamweaver Extension called "WindowsXP SP2 DB Connectivity Fix" Version 1.0.2 .

That worked for me Poker Jim, thanks a lot man. Now I can move on.