Connecting to local SQL database

You don't connect to a database file, you connect to a database server. The
location of the file is therefore irrelevant. Unless you were inaccurate in
your first post and are connecting to something like Access...

Make sure the service is running and set up to listen for connections on the
port you're using (default is 1433 for TCP/IP connections).

Check your connection string against the examples at
www.connectionstrings.com


"Marequi" <webforumsuser@macromedia.com> wrote in message
news:efe1bb$2pi$1@forums.macromedia.com...
>I tried local but I don't have any luck. Does the database file need to be
>on a specific location or can it be anywhere in my local machine?

And posting your connection string would be helpful.


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"David Alcala - Adobe" <supportinfo@macromedia.com> wrote in message
news:efe94f$cia$1@forums.macromedia.com...
> Are you using MS SQL Server? If so, what version?
>
> What server model are you using (ASP, ColdFusion, PHP, etc.)?
>
> How have you filled out the DW database connection dialog box so far?
>
> What error(s) are you seeing? Is the error in DW or in the browser?
>
> --
> David Alcala
> Adobe Product Support
>

Are you using MS SQL Server? If so, what version?

What server model are you using (ASP, ColdFusion, PHP, etc.)?

How have you filled out the DW database connection dialog box so far?

What error(s) are you seeing? Is the error in DW or in the browser?

--
David Alcala
Adobe Product Support

I tried local but I don't have any luck. Does the database file need to be on a specific location or can it be anywhere in my local machine?

Use (local) as your data source.

"Marequi" <webforumsuser@macromedia.com> wrote in message
news:efcl0m$931$1@forums.macromedia.com...
>I have tried everything to connect to a SQL database which is located on
>the
> same machine I'm using for development. Is there any special way of doing
> this. I tried to create a new connection in every way possible and I
> can't
> seem to be able to establish a connection. i would appreciate your input
> with
> this problem.
>
> Thank you,
>
> Marequi
>