Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASAProv from ASP

2 posts in General Discussion Last posting was on 2003-07-17 14:31:34.0Z
keith.hilton Posted on 2003-07-16 17:04:44.0Z
From: "keith.hilton" <keith.hilton@cox.net>
Subject: ASAProv from ASP
Date: Wed, 16 Jul 2003 12:04:44 -0500
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <OXu5T07SDHA.342@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: te-64-146-28-114.transedge.com 64.146.28.114
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1363
Article PK: 3597

I'm trying to connect to a version 7.0.0.313 database from ASP using the
ASAProv OLEDB provider.
The attempt keeps timing out or locks up IIS.
I can connect fine from a VB 6.0 app using the exact same code:
Dim myConn As New ADODB.Connection
myConn.Provider = "ASAProv"
myConn.ConnectionString = "Data Source=fics"
myConn.Open

Any help would be greatly appreciated.

Keith


Nick Elson Posted on 2003-07-17 14:31:34.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <OXu5T07SDHA.342@forums-2-dub>
Subject: Re: ASAProv from ASP
Date: Thu, 17 Jul 2003 10:31:34 -0400
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <uv5zPFHTDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-dub-080.sybase.com 10.22.120.80
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1375
Article PK: 3609

Two things

I would never use 7.0.0 GA for anything today. Get to 7.0.4 and
apply a couple of EBFs while you are at it. [too many bug fixes
to enumerate here, especially since the read me docs do a job
of that already] I especially would never use a point-Oh-Oh
product with a system service.

As far as your Data Source goes, is "fics" a system data source?
If not, IIS won't find it.


EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

Good luck.

"keith.hilton" <keith.hilton@cox.net> wrote in message
news:OXu5T07SDHA.342@forums-2-dub...
> I'm trying to connect to a version 7.0.0.313 database from ASP using the
> ASAProv OLEDB provider.
> The attempt keeps timing out or locks up IIS.
> I can connect fine from a VB 6.0 app using the exact same code:
> Dim myConn As New ADODB.Connection
> myConn.Provider = "ASAProv"
> myConn.ConnectionString = "Data Source=fics"
> myConn.Open
>
> Any help would be greatly appreciated.
>
> Keith
>
>
>