Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Reinstalled SQL-server

Reply
Thread Tools

Reinstalled SQL-server

 
 
Kent Johnson
Guest
Posts: n/a
 
      10-15-2005
Hi all,

After I reinstalled my SQL-server I cannot use my ASP page with:
====================================
Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
"Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
rs=Server.CreateObject("ADODB.Recordset")
====================================
I have the user on the server.
What can be wrong?

/Kent J.


 
Reply With Quote
 
 
 
 
Islamegy®
Guest
Posts: n/a
 
      10-15-2005
You mean just install SQLServer only.
if you get login failed error you may need to Configure your sqlserver to
use MixedMode Authontication or u have to use trusted connection.

or you hv problem in IIS? try to run
"C:\WIN\Microsoft.NET\Framework\v1.1.4322\aspnet_r egiis -i" may help

"Kent Johnson" <(E-Mail Removed)> wrote in message
news654f.148372$(E-Mail Removed)...
> Hi all,
>
> After I reinstalled my SQL-server I cannot use my ASP page with:
> ====================================
> Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
> "Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
> Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
> rs=Server.CreateObject("ADODB.Recordset")
> ====================================
> I have the user on the server.
> What can be wrong?
>
> /Kent J.
>
>



 
Reply With Quote
 
 
 
 
kunal
Guest
Posts: n/a
 
      10-15-2005
Did you check the Provider , is the provider installed perfectly.
Is the object being created perfectly

 
Reply With Quote
 
Kent Johnson
Guest
Posts: n/a
 
      10-15-2005
Hi,
Maybe your right!
Where can I check the Provider?

/Kent J-




"kunal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) oups.com...
> Did you check the Provider , is the provider installed perfectly.
> Is the object being created perfectly
>



 
Reply With Quote
 
Kent Johnson
Guest
Posts: n/a
 
      10-15-2005
Yes, I just reinstalled SQL-server so I figured that the problem was there.


"Islamegy®" <Islamegy@Private.4me> wrote in message
news:#(E-Mail Removed)...
> You mean just install SQLServer only.
> if you get login failed error you may need to Configure your sqlserver to
> use MixedMode Authontication or u have to use trusted connection.
>
> or you hv problem in IIS? try to run
> "C:\WIN\Microsoft.NET\Framework\v1.1.4322\aspnet_r egiis -i" may help
>
> "Kent Johnson" <(E-Mail Removed)> wrote in message
> news654f.148372$(E-Mail Removed)...
> > Hi all,
> >
> > After I reinstalled my SQL-server I cannot use my ASP page with:
> > ====================================
> > Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
> > "Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
> > Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
> > rs=Server.CreateObject("ADODB.Recordset")
> > ====================================
> > I have the user on the server.
> > What can be wrong?
> >
> > /Kent J.
> >
> >

>
>



 
Reply With Quote
 
kunal
Guest
Posts: n/a
 
      10-15-2005
So is the problem solved....

Kunal Ramesh Lalwani
Software Developer (ASP.NET 1.1)
Fahm Softwares
India

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
reinstalled vs 2003 error bruce lawson ASP .Net 0 12-25-2005 02:56 AM
reinstalled vs 2003 error bruce lawson ASP .Net 0 12-25-2005 02:53 AM
Reinstalled WIN 98 noreply@invalid Computer Support 13 12-30-2004 07:53 PM
reinstalled xp mozilla won't run dabigguy Firefox 2 12-09-2004 02:00 PM
reinstalled windows, now there's no monitor display Kohlrabi Computer Information 1 11-03-2003 06:45 PM



Advertisments