PDA

View Full Version : SQL Express connection problem


cozybuilder
09-08-2006, 03:29 PM
Let me say that I am a big NB at this, but have high stakes on the line.

I have connected dreamweaver to the express server, but the only dbase that shows up is the "Master". I am connecting with a DSN through a ODBC. This is all local, for prototyping only at this point.

How and Where do I direct the connection to the proper database and not the master? Should I be using a custom connection string?

Any suggestions?
Any help would be greatly appreciated.

Jack Fairchild

cozybuilder
09-08-2006, 08:04 PM
Ok, I figured that out. Problem was with the ODBC. The default database was set to master.

Now I have moved on and am trying to connect via OLE DB. I am using Windows NT Security. When I test the connections in the data link properties windows all is good. But when I hit test in the OLE DB connections window I get the "Cannot open database "blahblah" requested by the login. The login failed."

What is causing this?