Password and ID

I am building a website in Dreamweaver. I have tried and tried to get a connection to SQL 2005. Everything works on the web except the stuff that requires the use of my SQL tables. WithOPEN_Conn ="Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=master" I get an error at the bottom of my page saying this:

Microsoft OLE DB Provider for SQL Servererror '80004005'

Invalid authorization specification

When I add a password and ID to the string the pages become very slow and I get this error:

Microsoft OLE DB Provider for SQL Servererror '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Using windows authentication when logging into SQL Server doesn't have a user id or password so maybe I just don't know what to put there. I have tried a mix of all the passwords and ID's I use on this computer. Do I even have to have the user ID and password and if not how do I fix the first error? All help appreciated.

youdo use ASP.NET, right? if that's the case, why do you se OLEDB provider? use this type of connection string (standard .net provider)

<connectionStrings>

<addname="myConnectionString"connectionString="Data Source=server_name;Initial Catalog=database;Integrated Security=True"providerName="System.Data.SqlClient"/>

</connectionStrings>

|||

I was trying to use inline VB script

|||

ok... I don't know what's wrong with the oledb why don't you try ODBC (you must install sql native client first)

check here for a full list of sql server connection strings using various providers?

http://www.connectionstrings.com/?carrier=sqlserver2005

|||

Here is what I have. OPEN_Conn ="Provider=SQLODBC; Server=HES-DSSK071\SQLEXPRESS;Database=master;Trusted_Connection=True;" Then when I save the site to the
Remote server I get this error. It can also be seen at the bottom of openassessment.org. I have SQL Native Client installed.

ADODB.Connectionerror '800a0e7a'

Provider cannot be found. It may not be properly installed.

|||Hi,

Please try to register sqloledb.dll, because you are using sqloledb provider.

1.At a command prompt, change to the C:\Program Files\Common Files\System\Ole DB folder.2.At a command prompt, type the following command:

regsvr32 sqloledb.dll

3.You should receive confirmation that the DLL is registered successfully.

More information, see:http://support.microsoft.com/kb/278604

Hope that helps. Thanks.

|||

When I try

Nai-Dong Jin - MSFT:

C:\Program Files\Common Files\System\Ole DB

I get an error telling me it is not recognized as an internal or external command, operable program or batch file. When I explore to the same address, sqloledb.dll is in the Ole DB folder.

|||

Hi,

Well, it sounds like a path problem. You can use fixpath(see the link) tool to repair the issue with path. And then, try to register sqloledb.dll again.

http://internet.cybermesa.com/~bstewart/misctools.html

Hope that helps. Thanks

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

I'm still pushing forward. I finally got the sqloledb.dll registered. But I still get the same error. Any other ideas.

|||

Hi,

The following KB article may be helpful to you.

Database connectivity fails with local ASP.NET and ASP servers

ASP: When using a local ASP test server running on XP SP2 with Dreamweaver (i.e. the Testing Server URL prefix is set to "http://localhost"), and you specify "Using driver on testing server" or "Using DSN on testing server," database connectivity fails. If you click the Test button in the Custom Connection String or Data Source Name (DSN) dialog box, it says the connection was made successfully. However, if you then try to browse the tables in the Databases panel or create a recordset, the database tables do not display or you get the following error message: "Unable to retrieve tables from this connection, click on the 'Define...' button to test this connection."

From:http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19515&sliceId=1

Thanks.

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

What I have is a very large site that was given to our company. I was given the job of modifying it to fit our needs. All of the files have the .asp extention, but there is not a single asp tag in any of the 200 pages. So the KB article didn't help much. Maybe this question doesn't belong here since its not really asp.net? Any ideas?