This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » ASP » Ms SQL DB Connection

Ms SQL DB Connection
Andy None Member Since: 30 Apr 2009 Posts: 17	Posted 28 Oct 2009 18:14:24 Hi - I'm using the connect string below to connect to my MS SQL DB (all local). When i test the recorsets in Dreamweaver, all works fine. But when i browse the .asp page, i get this error! "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabase" requested by the login. The login failed." As far as i'm aware, i have setup the MS SQL Database (migrated from Access DB) as 'Windows Authentication". Anyone else experienced the same or knows what the problem is? Thanks in advance - Andy -------connection string-------- Dim MM_conn_STRING MM_conn_STRING = "Driver={SQL Server}; Server=WEBDESIGNAH\SQLEXPRESS; Database=mydatabase; UID=; PWD=;" Hi - I'm using the connect string below to connect to my MS SQL DB (all local). When i test the recorsets in Dreamweaver, all works fine. But when i browse the .asp page, i get this error! "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabase" requested by the login. The login failed." As far as i'm aware, i have setup the MS SQL Database (migrated from Access DB) as 'Windows Authentication". Anyone else experienced the same or knows what the problem is? Thanks in advance - Andy -------connection string-------- Dim MM_conn_STRING MM_conn_STRING = "Driver={SQL Server}; Server=WEBDESIGNAH\SQLEXPRESS; Database=mydatabase; UID=; PWD=;"

Ms SQL DB Connection

Andy None
Member

Since: 30 Apr 2009
Posts: 17

Posted 28 Oct 2009 18:14:24

Hi - I'm using the connect string below to connect to my MS SQL DB (all local). When i test the recorsets in Dreamweaver, all works fine. But when i browse the .asp page, i get this error!

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabase" requested by the login. The login failed."

As far as i'm aware, i have setup the MS SQL Database (migrated from Access DB) as 'Windows Authentication".

Anyone else experienced the same or knows what the problem is?

Thanks in advance -

Andy

-------connection string--------
Dim MM_conn_STRING
MM_conn_STRING = "Driver={SQL Server}; Server=WEBDESIGNAH\SQLEXPRESS; Database=mydatabase; UID=; PWD=;"

Hi - I'm using the connect string below to connect to my MS SQL DB (all local). When i test the recorsets in Dreamweaver, all works fine. But when i browse the .asp page, i get this error!

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabase" requested by the login. The login failed."

As far as i'm aware, i have setup the MS SQL Database (migrated from Access DB) as 'Windows Authentication".

Anyone else experienced the same or knows what the problem is?

Thanks in advance -

Andy

-------connection string--------
Dim MM_conn_STRING
MM_conn_STRING = "Driver={SQL Server}; Server=WEBDESIGNAH\SQLEXPRESS; Database=mydatabase; UID=; PWD=;"

Javier Castro Total freaking Member Since: 09 Sep 2004 Posts: 454	Replied 12 Dec 2009 04:05:47 Check you db permissions. It could be that.

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!