473,834 Members | 1,912 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

connection string causes blank page

I am developing a website in ASP that connects to a Sybase database.
However, when I try to open a connection to the database the page will not
load. The script does not timeout, nor the connection. Further, the Sybase
server shows no connection. Because the page is hanging I am unable, with my
limited knowledge, to query the error collection.
After many tries I will get an error page ...HTTP 403.9 Access forbidden:
Too many users are connected
I have created a connection string using the native sybase ole db provider
'Provider=Sybas e.ASEOLEDBProvi der.2' in Visual InterDev which can view the
database with all its tables, data etc with no problem whatsoever.
I am using Sybase ASE 12.5 developer edition (the server that is available
free from the Sybase site), on a laptop running XP Professional.
I have also tried using a Data Source .ids file within the connection string
as well as without.
Can anyone give me a clue as to how I might progress in tracking the
error(s)?
Jul 19 '05 #1
6 7278
www.connectionstrings.com

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Paul Robinson" <al******@NOSPA MHEREbtinternet .com> wrote in message
news:#q******** ******@tk2msftn gp13.phx.gbl...
I am developing a website in ASP that connects to a Sybase database.
However, when I try to open a connection to the database the page will not
load. The script does not timeout, nor the connection. Further, the Sybase
server shows no connection. Because the page is hanging I am unable, with my limited knowledge, to query the error collection.
After many tries I will get an error page ...HTTP 403.9 Access forbidden:
Too many users are connected
I have created a connection string using the native sybase ole db provider
'Provider=Sybas e.ASEOLEDBProvi der.2' in Visual InterDev which can view the
database with all its tables, data etc with no problem whatsoever.
I am using Sybase ASE 12.5 developer edition (the server that is available
free from the Sybase site), on a laptop running XP Professional.
I have also tried using a Data Source .ids file within the connection string as well as without.
Can anyone give me a clue as to how I might progress in tracking the
error(s)?

Jul 19 '05 #2
> Can anyone give me a clue as to how I might progress in tracking the
error(s)?


First off, you could try showing us the actual code that InterDev produced.
If you are using any of its wizards, you might try opening notepad and
creating a file that does simply this:

<%
set conn = CreateObject("A DODB.Connection ")
conn.open "<sybase connection string here>"
conn.close()
set conn = nothing
%>

If this hangs, try a page without an ADODB.Connectio n at all. Maybe you
have a much more generic problem. If the above just spins, try to set low
timeout values (see http://www.aspfaq.com/2066) and introduce some basic
error handling so you can catch the error message yourself instead of
relying on IIS to report it to you correctly (and your browser to not muck
it up).

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Jul 19 '05 #3
Yes, Steve, I have tried these connection strings, also those detailed at
www.able-consulting.com ...all to no avail.
I have replicated the database in Access XP and using another connection
string, the .asp page can connect and show the data. Hence I believe the
problem is with the connection string. What confuses me are the following 2
points :
1) Visual InterDev can see the database no problem and swiftly shows any
data requested, yet the same connection string on the asp page produces
nothing
2) The asp page just hangs, with no error message at all. But something
must be happening because after so many attempts I generate the HTTP 403.9
error message, so there must be some kind of connection made, though not to
the Sybase server...
"Steven Burn" <pv*@noyb.com > wrote in message
news:%2******** *******@TK2MSFT NGP11.phx.gbl.. .
www.connectionstrings.com

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Paul Robinson" <al******@NOSPA MHEREbtinternet .com> wrote in message
news:#q******** ******@tk2msftn gp13.phx.gbl...
I am developing a website in ASP that connects to a Sybase database.
However, when I try to open a connection to the database the page will not load. The script does not timeout, nor the connection. Further, the Sybase server shows no connection. Because the page is hanging I am unable, with
my
limited knowledge, to query the error collection.
After many tries I will get an error page ...HTTP 403.9 Access

forbidden: Too many users are connected
I have created a connection string using the native sybase ole db provider 'Provider=Sybas e.ASEOLEDBProvi der.2' in Visual InterDev which can view the database with all its tables, data etc with no problem whatsoever.
I am using Sybase ASE 12.5 developer edition (the server that is available free from the Sybase site), on a laptop running XP Professional.
I have also tried using a Data Source .ids file within the connection

string
as well as without.
Can anyone give me a clue as to how I might progress in tracking the
error(s)?


Jul 19 '05 #4
Aaron, thanks for your reply.
Looking at your advice in reverse order:

The trial connection hangs just like all my other attempts.

The code produced by InterDev for the connection string is detailed
below. As I have noted in my reply to advice from Steven Burn, with this
connection string InterDev rapidly accesses the database and shows the data
in the design ide. My asp page code is OK because I can open the page
without any delay or problem if I change the database to Access, where I
have replicated the tables. Further, if I comment out or remove any code
relevant to the Sybase connection, then the page loads OK. It is only when I
attempt to open the connection that the page hangs.I receive no error
message, just a blank page still trying to load, until I have tried to
connect enough times to generate the HTTP 403.9 error message. Sybase does
not show any connection coming through, so what is happening?

This is the connection string generated by InterDev
Provider=Sybase .ASEOLEDBProvid er.2;Initial Catalog=EMD;Use r ID=sa;Data
Source=EMDhome; Extended Properties="";S erver Name=SDT02;Netw ork
Protocol=Winsoc k;Server Port Address=5001;HA Server Name="";HA Server Port
Address="";Char acter Set="";Language ="";Applicat ion Name="";Optimiz e
Prepare=Partial ;Select Method=Direct;R aise Error Behavior=MS
Compatible;Prin t Statement Behavior=MS Compatible;Exte nded
ErrorInfo=TRUE; Stored Proc Row Count=Last Statement Only;WorkStatio n
ID="";Row Cache Size=50;Enable Quoted Identifiers=0;P acket Size=1;Default
Length For Long
Data=1024;UseSy baseLDAP=False; SybaseLDAPURL=" ";SybaseServerN ame=389;UseLDAP H
AServer=0;Use SSL=0;Trusted Root File Name="";Interfa ces File="";Interfa ces
File Server Name="";EnableS PColumnTypes=Tr ue;TruncateTime TypeFractions=1

These are the code extracts on my asp pages:

Dim objConn, strConnect, objRS, strSQLproc
Set objConn = server.CreateOb ject("ADODB.Con nection")
' strConnect = Application("co nnEMD_Connectio nString")
' strConnect = "Provider=Sybas e.ASEOLEDBProvi der.2;Data Source=EMD;Serv er
Name=SDT02;Netw ork Protocol=Winsoc k;Server Port Address=5001;Us er
Id=sa;Password= "
Dim arrOperators, iCount strSQLproc = "SELECT * FROM tblOperator"
' strSQLproc = "EXECUTE procOperators1"
objConn.Open strConnect
Set objRS = objConn.Execute (strSQLproc)
arrOperators = objRS.GetRows
objConn.Close
Set objConn=Nothing
...
"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..
Can anyone give me a clue as to how I might progress in tracking the
error(s)?
First off, you could try showing us the actual code that InterDev

produced. If you are using any of its wizards, you might try opening notepad and
creating a file that does simply this:

<%
set conn = CreateObject("A DODB.Connection ")
conn.open "<sybase connection string here>"
conn.close()
set conn = nothing
%>

If this hangs, try a page without an ADODB.Connectio n at all. Maybe you
have a much more generic problem. If the above just spins, try to set low
timeout values (see http://www.aspfaq.com/2066) and introduce some basic
error handling so you can catch the error message yourself instead of
relying on IIS to report it to you correctly (and your browser to not muck
it up).

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Jul 19 '05 #5
Paul Robinson wrote:
Aaron, thanks for your reply.
Looking at your advice in reverse order:

The trial connection hangs just like all my other attempts.

The code produced by InterDev for the connection string is
detailed below. As I have noted in my reply to advice from Steven
Burn, with this connection string InterDev rapidly accesses the
database and shows the data in the design ide.
Different machine, different user account than the one that asp uses.
My asp page code is OK
because I can open the page without any delay or problem if I change
the database to Access, where I have replicated the tables. Further,
if I comment out or remove any code relevant to the Sybase
connection, then the page loads OK. It is only when I attempt to open
the connection that the page hangs.I receive no error message, just a
blank page still trying to load, until I have tried to connect enough
times to generate the HTTP 403.9 error message. Sybase does not show
any connection coming through, so what is happening?
It sounds as if your network is not finding the Sybase server (and is
failing to time out ... very unusual)

Have you tried searching the Sybase KB?
http://my.sybase.com/search_advanced

More below:

This is the connection string generated by InterDev
Provider=Sybase .ASEOLEDBProvid er.2;Initial Catalog=EMD;Use r ID=sa;
Mistake #1 - never use the sa account for your applications! Create an
account with limited permissions to be used by your apps. Protect the sa
account as if your server/network/job depends on it - it does.
Data
Source=EMDhome;
Have you tried specifying the port number as described at able-consulting?
Is this quote from able-consulting relevant?
*************** *************** *************** *************
Note: The Open Client 12 Sybase OLE DB Provider fails to work without
creating a Data Source .IDS file using the Sybase Data Administrator.
These .IDS files resemble ODBC DSNs.

Note: With Open Client 12.5, the server port number feature finally works,
allowing fully qualified network connection strings to be used without
defining any .IDS Data Source files.

*************** *************** *************** **************

Extended Properties="";S erver Name=SDT02;Netw ork
Protocol=Winsoc k;Server Port Address=5001;HA Server Name="";HA Server
Port Address="";Char acter Set="";Language ="";Applicat ion
Name="";Optimiz e Prepare=Partial ;Select Method=Direct;R aise Error
Behavior=MS Compatible;Prin t Statement Behavior=MS Compatible;Exte nded
ErrorInfo=TRUE; Stored Proc Row Count=Last Statement Only;WorkStatio n
ID="";Row Cache Size=50;Enable Quoted Identifiers=0;P acket
Size=1;Default Length For Long
Data=1024;UseSy baseLDAP=False; SybaseLDAPURL=" ";SybaseServerN ame=389;UseLDAP H AServer=0;Use SSL=0;Trusted Root File Name="";Interfa ces
File="";Interfa ces File Server
Name="";EnableS PColumnTypes=Tr ue;TruncateTime TypeFractions=1
A lot of these extended properties look like the defaults, and they can
probably be eliminated from the connection string used by your application.

These are the code extracts on my asp pages:

Dim objConn, strConnect, objRS, strSQLproc
Set objConn = server.CreateOb ject("ADODB.Con nection")
' strConnect = Application("co nnEMD_Connectio nString")
' strConnect = "Provider=Sybas e.ASEOLEDBProvi der.2;Data
Source=EMD;Serv er Name=SDT02;Netw ork Protocol=Winsoc k;Server Port
Address=5001;Us er Id=sa;Password= "
I hope this does not mean your sa password is an empty string - have you
never heard of the Slammer internet worm? It propogates by attack sql
servers where the sa password is blank. Hopefully, you've just censored it
for this newsgroup message.

Dim arrOperators, iCount strSQLproc = "SELECT * FROM tblOperator"
' strSQLproc = "EXECUTE procOperators1"
objConn.Open strConnect
Set objRS = objConn.Execute (strSQLproc)
arrOperators = objRS.GetRows
objConn.Close
Set objConn=Nothing
...


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #6
I have made an 'interesting' development...
I have downloaded an evaluation copy of DataDirect's latest ODBC drivers. I
created a DSN connection and then allowed InterDev to access that connection
and create a connection string. I can now load my asp page with the new
connection string, which is...

"Provider=MSDAS QL.1;Persist Security Info=False;User ID=sa;Data
Source=EMDDDodb c;Extended
Properties=""DS N=EMDDDodbc;UID =sa;NA=SDT02,50 01;DB=EMD;"";Us er Id=sa;"

Your comments, Bob, about using the sa login are noted, and I particularly
appreciate the info about the slammer virus. Now that I am aware, I will
amend the login. When I have finished the website it will be moved to a
production server from my laptop and a new default login with password will
be assigned.

I am still left wondering why the Sybase OLE DB Provider does not work for
the asp page. Could it be a problem with my IIS settings?

Thanks for all the help and advice
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:OW******** ******@TK2MSFTN GP11.phx.gbl...
Paul Robinson wrote:
Aaron, thanks for your reply.
Looking at your advice in reverse order:

The trial connection hangs just like all my other attempts.

The code produced by InterDev for the connection string is
detailed below. As I have noted in my reply to advice from Steven
Burn, with this connection string InterDev rapidly accesses the
database and shows the data in the design ide.
Different machine, different user account than the one that asp uses.
My asp page code is OK
because I can open the page without any delay or problem if I change
the database to Access, where I have replicated the tables. Further,
if I comment out or remove any code relevant to the Sybase
connection, then the page loads OK. It is only when I attempt to open
the connection that the page hangs.I receive no error message, just a
blank page still trying to load, until I have tried to connect enough
times to generate the HTTP 403.9 error message. Sybase does not show
any connection coming through, so what is happening?


It sounds as if your network is not finding the Sybase server (and is
failing to time out ... very unusual)

Have you tried searching the Sybase KB?
http://my.sybase.com/search_advanced

More below:

This is the connection string generated by InterDev
Provider=Sybase .ASEOLEDBProvid er.2;Initial Catalog=EMD;Use r ID=sa;


Mistake #1 - never use the sa account for your applications! Create an
account with limited permissions to be used by your apps. Protect the sa
account as if your server/network/job depends on it - it does.
Data
Source=EMDhome;


Have you tried specifying the port number as described at able-consulting?
Is this quote from able-consulting relevant?
*************** *************** *************** *************
Note: The Open Client 12 Sybase OLE DB Provider fails to work without
creating a Data Source .IDS file using the Sybase Data Administrator.
These .IDS files resemble ODBC DSNs.

Note: With Open Client 12.5, the server port number feature finally works,
allowing fully qualified network connection strings to be used without
defining any .IDS Data Source files.

*************** *************** *************** **************

Extended Properties="";S erver Name=SDT02;Netw ork
Protocol=Winsoc k;Server Port Address=5001;HA Server Name="";HA Server
Port Address="";Char acter Set="";Language ="";Applicat ion
Name="";Optimiz e Prepare=Partial ;Select Method=Direct;R aise Error
Behavior=MS Compatible;Prin t Statement Behavior=MS Compatible;Exte nded
ErrorInfo=TRUE; Stored Proc Row Count=Last Statement Only;WorkStatio n
ID="";Row Cache Size=50;Enable Quoted Identifiers=0;P acket
Size=1;Default Length For Long

Data=1024;UseSy baseLDAP=False; SybaseLDAPURL=" ";SybaseServerN ame=389;UseLDAP H
AServer=0;Use SSL=0;Trusted Root File Name="";Interfa ces
File="";Interfa ces File Server
Name="";EnableS PColumnTypes=Tr ue;TruncateTime TypeFractions=1


A lot of these extended properties look like the defaults, and they can
probably be eliminated from the connection string used by your

application.

These are the code extracts on my asp pages:

Dim objConn, strConnect, objRS, strSQLproc
Set objConn = server.CreateOb ject("ADODB.Con nection")
' strConnect = Application("co nnEMD_Connectio nString")
' strConnect = "Provider=Sybas e.ASEOLEDBProvi der.2;Data
Source=EMD;Serv er Name=SDT02;Netw ork Protocol=Winsoc k;Server Port
Address=5001;Us er Id=sa;Password= "


I hope this does not mean your sa password is an empty string - have you
never heard of the Slammer internet worm? It propogates by attack sql
servers where the sa password is blank. Hopefully, you've just censored it
for this newsgroup message.

Dim arrOperators, iCount strSQLproc = "SELECT * FROM tblOperator"
' strSQLproc = "EXECUTE procOperators1"
objConn.Open strConnect
Set objRS = objConn.Execute (strSQLproc)
arrOperators = objRS.GetRows
objConn.Close
Set objConn=Nothing
...


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2465
by: Dennis Hueckelheim | last post by:
Hallo everybody, I have a problem with a little socket script. ----- snipp ----- $out_clients = socket_accept($socket_out); $http_welcome = "HTTP/1.0 200 OK\r\nContent-type: text/html\r\n\r\n"; $http_welcome .= "<html><head><title>test</title></head><body><h1>Test</h1>"; socket_write($out_clients, $http_welcome);
13
1904
by: Larry | last post by:
Hi I have asp.net programs. I used a very simple data transfer method by using URLs ¡°First.aspx¡± contents a line to send data to the ¡°second.aspx¡± page, for
1
1292
by: Eric | last post by:
How come a user control on an ASPX page that has visible set to false causes blank lines? We have an ASPX page with many hidden user controls on it, where we make the one we need visible. If the visible control is positioned last on the ASPX page it will be set lower on the page then when the top one is made visible. Seems like there is a bug in hidden user controls where they cause a blank line. Any suggestions? Thanks.
18
3253
by: Rob Nicholson | last post by:
We're getting an occasional occurrence of the following error when two users try and open the same record in our ASP.NET app: "There is already an open DataReader associated with this Connection which must be closed first." As suggested, I was closing the connection in the Finally part of the outer Try but I wasn't closing the data reader as well so I assume that if the following happens, the above error could occur
1
2087
by: Jennifer | last post by:
Hi. I don't know a whole bunch about html and asp pages, but I thought I'd give it a try to see if I could get it to work. I found an example for a calendar event page from Microsoft at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnas...
0
789
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted by the software in your host machine. Stack Trace at System.Net.Sockets.NetworkStream.Write(Byte buffer, Int32 offset, Int32
3
14065
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted by the software in your host machine. Stack Trace at System.Net.Sockets.NetworkStream.Write(Byte buffer, Int32 offset, Int32
1
2204
by: s_valmont | last post by:
Just wondering if anyone's heard of this issue. It relates to accessing an Oracle 9i database from ASP.NET 1.1. The first time you do this (e.g., run a sproc) it works fine. However doing this multiple times causes ASP.NET to freeze permanently. Its memory consumption increases and its CPU usage hangs at around 50%. The only way to proceed afterward is to use the Windows Task Manager to close the ASP process. In code, the reason...
10
2322
by: jimjim | last post by:
HI, We have shifted our database from sqlserver2003 to sqlserver2005. 1. connection strings stored in web.config <!-- Machine name to connection string keys --> <add key="*777*" value="**ConnString_DEV" /> <add key="server2" value="**ConnString_TST" /> <add key="server1" value="**ConnString_PRD" /> <!-- Literal Connection String Keys -->
0
9800
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10802
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10516
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10557
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10225
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9340
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7763
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6961
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4429
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.