Hi

I was wondering if someone can assist me in connecting to a sql data base. I getting this error when I try to connect.

Microsoft OLE DB Provider for SQL Server error '80004005'

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

/forms/Test.asp, line 25


Here is the code:

Dim con, rs, str

set con=server.CreateObject("ADODB.CONNECTION")

con.Open "Provider=sqloledb;Data Source=Source_Forms;Initial Catalog=Source_Forms;User Id=Source_Web_User;Password=password;"

set rs=server.CreateObject("ADODB.RECORDSET")

rs.ActiveConnection=con

str="SELECT * Tickect_Number FROM Escalation_Form"

rs.open


objRS.Close

objConn.Close

Set objRs = Nothing

Set objConn =Nothing
%>

Data Source=Source_Forms;Initial Catalog=Source_Forms

Looks like you are using same values for both. Can you check your SQL SERVER name and apply that in "Data source" parameter?

Cheers!

_________________________
-Vijay G
Strive for Perfection

I did Check and made the following changes:

con.Open "Provider=sqloledb;Data Source=MQIS;Initial Catalog=Source_Forms;User Id=Source_Web_User;Password=password;"

Then I got this Message:

Microsoft OLE DB Provider for SQL Server error '80004005'

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

/forms/Test.asp, line 27

Which is pointing back to
where it says con.open

I was able to resolve that problem by using to correct field in the appropriate area:

con.Open "Provider=sqloledb;Data Source=Flmirsql02;Initial Catalog=Source_Forms;User Id=Source_Forms_User;Password=password;"

I have another question!

Does any one knows of a code that can generate a ticket number from the sql database into
the confirmation page? Using asp or generate a ticket number then have send to the database?

Thank you

It seems, you had used a wrong value in the previous occassion. Well, that is solved now.

Can you explain a bit more on what you refer as ticket number? Not sure what you are looking for.

Cheers!

_________________________
-Vijay G
Strive for Perfection

hi there:

If I try that, I get the following runtime error when trying to start the app:

System.ArgumentException: Key word don't admitted: 'provider'.
   at System.Data.Common.DBConnectionString.ParseInterna l(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
   at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
   at System.Data.SqlClient.SqlConnectionString..ctor(St ring connectionString)
   at System.Data.SqlClient.SqlConnectionString.ParseStr ing(String connectionString)
   at System.Data.SqlClient.SqlConnection.set_Connection String(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at Wrox.WebModules.Data.DbObject..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Core\DBObject.vb:line 32
   at Wrox.WebModules.Polls.Data.Questions..ctor(String newConnectionString) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Data\Questions.vb:line 33
   at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Polls.Business\Question.vb:li ne 227
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 260
   at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\plataforma\wrox\website\ThePhil eVB\WebModules\Polls\Poll.ascx.vb:line 62
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()

why is this?
thx

Looks like you have posted that in the wrong forum. I would suggest you to post that on a dotnet forum, for early replies.

Cheers!

_________________________
- Vijay G
Strive for Perfection

saeta57,

I've had problems with the Provider keyword in connection strings. In .NET, it doesn't seem to take them. To create a connection for your app, drag/drop a connection object onto a web or windows form, setup the connection, then highlight the connection and the connection string property will have the connection. You can then keep or delete the connection object; but that is a GUI trick to get the connection string.

Brian