Using DNS names & ADODB

P

phoenetia

Howdy... am hoping some peops here maybe able to shed some light on
connection string issue i have using the adodb.connection method...

Background: I have a spreadsheet that makes adodb calls to a text fil
that resides on a certain folder on my PC. What I want to do is mov
the spreadsheet, dsn name & schema.ini to a web server so that peopl
globally can access the spreadsheet over the intranet.

However, when i change the connection string settings, I get an invali
web address error message yet I have copied the address directly from
web browser.

Am I referencing it incorrectly perhaps ??

Below is the change that I have attempted to make :

Original:
Const strFolder As String = "C:\DOCUMENTS AND SETTINGS\MUNTERS\M
DOCUMENTS\WORK\COMMISSIONS TEMPLATE\HOSTINT\"

New:
Const strFolder As String = "http://wfdev:8150/Ops/Comms"


Any help muchly apprec..
 
Top