ASP.NET Development Setup

You want irony.... I am running CS3 on my MAC as well. I setup my remote and testing servers as the IP address of the website, and was able to create a connection to the database without any issue at all. Yet on my PC, I can't. How's that for irony? Personally, I'd much rather develop on my MAC anyway, but I still don't understand what the heck is wrong with the PC and why I can't connect to a local ODBC or SQL connection with ASP.NET development.

If I understand what you're asking, I select from the list of options found under the build for OLE DB the appropriate thing I believe, whether that be the default SQL connection, or an ODBC connection, etc. I've tried an access DB through the ODBC, SQL Server through the ODBC, SQL Server directly, etc.... same results. Connection = Success!... followed by a dozen warning messages about the catalog. It's so strange to me, because if I develop an ASP.OLD website, it connects to all of these things without an issue, and if I'm using MS Visual Web Developer... no issues with these sources, but Dreamweaver 8 will have no parts of it. I'm sure this has happened to someone else... is there a tutorial that step by step sets up this work environment up?

When defining the connection, have you selected the option to use a driver
from your machine not the testing server.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET

even if I try to connect to an access database using the OLE DB access drivers... i get the same message.... so it's not just a sql server situation it seems

2000 full version and 2005 express
windows authentication

I should mention that I have visual studio express, and it connects with no issues.

"jsteinmann" <webforumsuser@macromedia.com> wrote in message
news:flnj87$j0q$1@forums.macromedia.com...
> I keep getting the following message when attempting to setup an asp.net
> environment connected to a local sql server:
>
> login failed. catalog information cannot be retrieved
>
> I am able to test the connection, and it says Success!... followed by
> about 10
> warning like above. As an experiment, I turned off the firewall, turned
> off
> virus software... no difference. Any suggestions?

What version of MS SQL Server are you running, 2000-2005, full
version/Express/MSDE?
Are you authenticating using SQL Server or Windows Security?
To check if you can login using Windows Security (Trusted Connection) open a
command prompt,
navigate to the SQL server installation path/Tools/binn and execute the
command

osql.exe -E

If this succeeds you probably need to allow logins using SQL Server security
(Mixed Mode)
http://support.microsoft.com/kb/319930

HTH

Joris