|
 |
asp_databases thread: ActiveX error
Message #1 by arshad siddiqui <ash_arshad@y...> on Mon, 22 Oct 2001 04:56:58 -0700 (PDT)
|
|
Hi there,
I have problem connecting to the sql server database
the following error is coming:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
any help regarding the problem will be highly
appreciated.
Thanx
Arshad
Message #2 by "Sanjeev Gandhi" <sgandhi@e...> on Mon, 22 Oct 2001 09:09:05 -0700
|
|
Hi Arshad,
There can be problem in server.createobject
How you are creating connection object and which connection string u r using
?
-Sanjeev Gandhi
----- Original Message -----
From: "arshad siddiqui" <ash_arshad@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, October 22, 2001 5:41 AM
Subject: [asp_databases] ActiveX error
> Hi there,
> I have problem connecting to the sql server database
> the following error is coming:
>
> Microsoft VBScript runtime error '800a01ad'
>
> ActiveX component can't create object
>
> any help regarding the problem will be highly
> appreciated.
> Thanx
> Arshad
Message #3 by arshad siddiqui <ash_arshad@y...> on Mon, 22 Oct 2001 21:55:10 -0700 (PDT)
|
|
Hi Sanjeev
Well I am creating connection object like this.
set cn=server.createobject("ADODB.Connection")
cn.open "DSN=mydsn;UID=sa;PWD=xxx"
set rs=server.CreateObject("ADODB.Recordset")
I think that there is some problem in my IIS settings
because the same thing was working perfectly all right
when I was using Access but when I switched to sql
server this is not working after that I again switched
back to Acces and I found that its not working,plus
whenever I copy some files into my virtual directory.
Microsoft save result component is automatically comes
in between that page.
is it related to frontpage server extentions or to my
IIS settings.
Please help
Thanx
Bye
Arshad
Message #4 by "Drew, Ron" <RDrew@B...> on Tue, 23 Oct 2001 07:57:37 -0400
|
|
This is how I connect to SQL Server and it works fine...
set cn=server.createobject("adodb.connection")
cn.open "DRIVER=SQL Server;SERVER=BDFINTRA;UID=sa;APP=Microsoft Open
Database Connectivity;WSID=SNRM_48001F5M;DATABASE=yourdatabase;User
Id=sa;PASSWORD=;"
-----Original Message-----
From: arshad siddiqui [mailto:ash_arshad@y...]
Sent: Tuesday, October 23, 2001 12:55 AM
To: ASP Databases
Subject: [asp_databases] Re: ActiveX error
Hi Sanjeev
Well I am creating connection object like this.
set cn=server.createobject("ADODB.Connection")
cn.open "DSN=mydsn;UID=sa;PWD=xxx"
set rs=server.CreateObject("ADODB.Recordset")
I think that there is some problem in my IIS settings
because the same thing was working perfectly all right
when I was using Access but when I switched to sql
server this is not working after that I again switched
back to Acces and I found that its not working,plus
whenever I copy some files into my virtual directory.
Microsoft save result component is automatically comes
in between that page.
is it related to frontpage server extentions or to my
IIS settings.
Please help
Thanx
Bye
Arshad
Message #5 by "Sanjeev Gandhi" <sgandhi@e...> on Tue, 23 Oct 2001 08:18:12 -0700
|
|
Hi Arshad,
which version of ODBC u r using?
have you created 'mydsn' in odbc on iis server to connect?
To access Access, you may have used JET/OLEDB as provider
Here you are connecting through odbc as dsn
-Sanjeev
----- Original Message -----
From: "arshad siddiqui" <ash_arshad@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, October 22, 2001 9:55 PM
Subject: [asp_databases] Re: ActiveX error
> Hi Sanjeev
>
> Well I am creating connection object like this.
> set cn=server.createobject("ADODB.Connection")
> cn.open "DSN=mydsn;UID=sa;PWD=xxx"
> set rs=server.CreateObject("ADODB.Recordset")
>
> I think that there is some problem in my IIS settings
> because the same thing was working perfectly all right
> when I was using Access but when I switched to sql
> server this is not working after that I again switched
> back to Acces and I found that its not working,plus
> whenever I copy some files into my virtual directory.
> Microsoft save result component is automatically comes
> in between that page.
> is it related to frontpage server extentions or to my
> IIS settings.
> Please help
> Thanx
> Bye
> Arshad
Message #6 by arshad siddiqui <ash_arshad@y...> on Tue, 23 Oct 2001 06:46:03 -0700 (PDT)
|
|
Hi Sanjeev
Thanx for such aprompt response.I cant get you what do you mean by ODBC
version.
Well I think that its not able to create the object this means that it is
the server error.please tell me if you are connecting to the database
through dsn then is it necessary to have your database in your virtual
directory or it can be anywhere.
I checked it by making the dsn less connection but then also same error is
coming.
Thanx
Bye
Message #7 by "Sanjeev Gandhi" <sgandhi@e...> on Tue, 23 Oct 2001 15:56:53 -0700
|
|
Hi ...,
When you connect through dsn, database can be anywhere but should be able to
connect through ODBC Administartor on database server.
If it is working with MS Access and not SQL then definitely, you are not
using right connection string or DSN. So
1. first check , in odbc admin: Test to connect database is succssful or
not.
2. check the connection string.
Thanks
Sanjeev Gandhi
----- Original Message -----
From: "arshad siddiqui" <ash_arshad@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, October 23, 2001 6:46 AM
Subject: [asp_databases] Re: ActiveX error
> Hi Sanjeev
> Thanx for such aprompt response.I cant get you what do you mean by ODBC
> version.
> Well I think that its not able to create the object this means that it is
> the server error.please tell me if you are connecting to the database
> through dsn then is it necessary to have your database in your virtual
> directory or it can be anywhere.
> I checked it by making the dsn less connection but then also same error is
> coming.
> Thanx
> Bye
>
$subst('Email.Unsub')
>
>
|
|
|
View Cart
