Still Beginner in SQL-ASP connection, PLS HELP

[amkaldas]

Hi,
I need to Access Microsoft SQL database from ASP...

I got this error:

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

What could be the Cause? ALso pls tell me if there is any tutorial available about the ASP-Microsoft SQL server Connectivity

Thanks in advance

 

[wushutwist]

You need to supply your code for a more complete answer, we don't even know what ActiveX component you are using.

Here is sample DSN-less connection:

Dim objconnection
Dim Connection_String

Connection_String = "Driver=SQL Server;Server=Svr_Name;" & _
                    "Database=db_name;UID=sa;Password=xxx"

Set objconnection = Server.CreateObject("ADODB.Connection")
objconnection.Open Connection_String

'
' Blah Blah Blah Databae Stuff
'

' Connection Cleanup
objconnection.close
Set objconnection = Nothing

Wushutwist

 

[SimonA]

OK, I'm getting this error now. Code is as follows:

----------------------------------
Dim objConn, oPackage
set objConn = Server.CreateObject("ADODB.Connection&quot

objConn.ConnectionString = "Driver=SQL Server;
Server=xxx;Database=xxx;UID=xxx;Password=xxx"
----------------------------------
At this point, I get the error:

Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object

The problem is is that it works fine on my local machine, but not on our Production Server (and of course they won't give me access to look at the server). I've ensured that the DSN is correct on the Production server, as well as the username and password.

Any ideas anyone?

Thanks,

Simon.

 

[SimonA]

Just a question here (from a newbie ASP'er) - where does ActiveX come from? Is it a component of ASP, IIS or just a seperate MS application?

And what does ActiveX have to do with opening up a Database connection through ASP?

Many thanks.

 

[balves]

It would appear that the server does not have the SQL Server driver installed.

ActiveX is a lot of things. It is controls in VB and ASP, DLLs, and EXEs. People tend to use ActiveX and COM/DCOM interchangeably.