Connecting to local SQL database

[Marequi]

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

[Newsgroup_User]

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
>

[Marequi]

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?

[Newsgroup_User]

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

[Marequi]

I'm using ASP and SQL Server as the database file but I don't have a dedicated SQL server. I have the database file in my local machine.
I was able to establish a connection to the database but when I view the Tables, it does not show me the table names, in stead it shows me something like DBO.spt.. something under Tables. What does that mean and why can't I see the tables?

Thank you again.

[Newsgroup_User]

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
>

[Newsgroup_User]

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?