Skip to main content
Participating Frequently
July 22, 2006
Question

SQL connection

  • July 22, 2006
  • 1 reply
  • 384 views
Hello there

I am working with Dreamweaver8 using ASP language + MS Access2003 = Everything is OK

I am trying now to upgrade from Access to SQL server,
But I dont know how to coonect

????
Can you please show how to do it


Thanks in advance

This topic has been closed for replies.

1 reply

Inspiring
July 22, 2006
There is a pretty good upsize wizard in Access 2003.


--
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


"MaroOom" <webforumsuser@macromedia.com> wrote in message
news:e9tl21$4li$1@forums.macromedia.com...
> Hello there
>
> I am working with Dreamweaver8 using ASP language + MS Access2003 =
> Everything
> is OK
>
> I am trying now to upgrade from Access to SQL server,
> But I dont know how to coonect
>
> ????
> Can you please show how to do it
>
>
> Thanks in advance
>
>
>


MaroOomAuthor
Participating Frequently
July 23, 2006
thank you for that hint,


But I know how to Upgrade and the new DB is on my local SQL server with the"nothwindDB"

But my question was how shall I connect
I am using connection string :
"Provider=sqloledb;Data Source=MARO;Initial Catalog=maroDB;Integrated Security=SSPI;"

When I try to test it using the opition " Using driver on this mahchine" it is succesfull
but when I select the option "using driver on testing server"
I get this msg:
"Login failed for user 'Maro\IUSR_Maro'"

----------------------------------------------------------------------------------------------------------------------
some extra points:
*my testing server is local host (under wwwroot)
*I've installed SQL server client and server SWs
*I dont have and ID or Password for my DBs, they are trusted Authentication
*Also I've tried the replace my DB name with northwindDB in the connection string .... I got the same results
----------------------------------------------------------------------------------------------------------------------

When I preview my page I get this error msg:

Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'MARO\IUSR_MARO'.
/jazariSite/Admin/TMPzch12v33q.asp, line 9


I read about this error msg, and that is related to Id and password, but as i mentioned aboved I am using trusted authentication and I dont have any UID or PSW

Can you please help me

Thanks in advance