Getting Data from a Second Server
Graham Copeland
site. We use standard VBScript for scripting. We want to access a
database on a second server on an intranet (same configuration) and
think RDS is the way to do it.
In a typical ASP we use the following db connection string to get the
DBName database on the Ariel server:
cnnDBName.Open "Provider=MS Remote; Remote Server=http://Ariel; Remote
provider=MSDASQL;
FILEDSN=c:\InetPub\wwwroot\Toolkit\db\DBName.dsn","admin",""
This appears to be OK, but we get an error when we try to open the
remote database to a recordset:
Set rstI = Server.CreateObject ("ADODB.Recordset")
strSQL = "SELECT * FROM Types ORDER BY Type ASC"
Set rstI = cnnDBName.Execute (strSQL)
We get the 800a20ff error which maps to Error Message 8447: Internet
Server Error
We have configured the MSADC virtual directory in the Default Server
correctly and run handunsf.dll to remove the need for RDS DataFactory
handlers. All files have appropriate permissions and securities.
Q1: Is this the best way to connect to a database on a second server?
Q2: If so, what other problems might exist?
Thanks ...
Graham Copeland
Inetix Inc.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Aaron Bertrand [MVP]
"Graham Copeland" <gra...@inetix.com> wrote in message
news:#571D#3#BHA.372@tkmsftngp04...
Tom Kaminski [MVP]
> site. We use standard VBScript for scripting. We want to access a
> database on a second server on an intranet (same configuration) and
> think RDS is the way to do it.
>
> In a typical ASP we use the following db connection string to get the
> DBName database on the Ariel server:
>
> cnnDBName.Open "Provider=MS Remote; Remote Server=http://Ariel; Remote
> provider=MSDASQL;
> FILEDSN=c:\InetPub\wwwroot\Toolkit\db\DBName.dsn","admin",""
>
> This appears to be OK, but we get an error when we try to open the
> remote database to a recordset:
>
> Set rstI = Server.CreateObject ("ADODB.Recordset")
> strSQL = "SELECT * FROM Types ORDER BY Type ASC"
> Set rstI = cnnDBName.Execute (strSQL)
>
> We get the 800a20ff error which maps to Error Message 8447: Internet
> Server Error
>
> We have configured the MSADC virtual directory in the Default Server
> correctly and run handunsf.dll to remove the need for RDS DataFactory
> handlers. All files have appropriate permissions and securities.
>
> Q1: Is this the best way to connect to a database on a second server?
NO! RDS would be used by a client like IE. To do db access from an
ASP, just use ADO.
Some basics:
http://www.4guysfromrolla.com/webtech/faq/faqtoc.shtml#Databases
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169377
Here's lot's of tips:
http://www.15seconds.com/focus/Data%20Access.htm
http://www.aspfaq.com/database.asp