[dba-SQLServer] ISP doesn't support SQL Server?

Marty,

Excellent!  I *thought* the guy was talking out of his hind end, but
you dasn't say that to a technical support guy!

I'm very likely doing something wrong with the connection string. 
Thanks again.  I'll keep looking.

Steve Erbach
Neenah, WI


On 3/28/06, MartyConnelly <martyconnelly at shaw.ca> wrote:
> Need to see your connection code to SQL, it could be your ADO call isn't
> "Server.CreateObject"
> Guy is talking a bit odd, you can connect to a remote SQL Server via ADO
> and ASP
> I have done it via a WAP server to an ASP site to a Remote SQL server
> each on a different continent
> He is probably confusing not having a SQL Server access on site. If he
> supports Access
> he has to use ADODB.
>
> here is some sample ASP code to check what server objects are available
> on the ISP site
> Note ADODB.Connection and Recordset available.