ASP SQL Error

[D Castaldi]

I get this error after publishing local, using W2K Pro with IIS
personal server:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/Property/assets/lib/MSDBConnection.inc, line 133

This ASP tool would be good if it worked....any updates coming soon?

[Ed Mini]

D Castaldi wrote:

You got caught by the "publish local" trap! Here's the problem. When
you "publish local", NOF opens the page using a "file" protocol. This
won't work with an ASP page. After you "publish local" (and get the
error) look up in the location bar of your browser. You'll see

//file://myasppage.asp

Change this to:

http://localhost.myasppage.asp

Also, don't forget to change the page extension to .asp in site view.

This is documented in the "Business Solutions" ASP tutorial but it's buried.

As to your remark about the ASP Connector. Amen! This was a great idea
but very badly implemented. I was one of the early users of this and if
you go back to the spring 99 newsgroup archives you'll see many, many
messages from me and others trying to get this going. Of course that
was when NOF tech support at least looked at the newsgroups once in a
while!

HTH

--
Ed Mini
edm...@inftek.com

[Blake Kadatz]

Ed Mini wrote:
>
> You got caught by the "publish local" trap! Here's the problem.
> When you "publish local", NOF opens the page using a "file"
> protocol. This won't work with an ASP page. After you "publish
> local" (and get the error) look up in the location bar of your
> browser. You'll see
>
> //file://myasppage.asp

Though if it's being viewed this way, the ASP code wouldn't get
processed so an error message wouldn't appear. I'm thinking it's
something to do with how the database connection is specified.

Blake Kadatz
BitMotion Software Inc.
------------------------------------------
BitMotion: http://www.bitmotion.com
Fusion FAQ: http://fusionfaq.bitmotion.com