How can I connect to an ASA6 ODBC using ADO and vbscript?
Athough I have the ODBC connection working in PB or Visual Interdev environment, I can't connect through code
|
0 |
|
Savvoulidis
8/10/2002 6:50:34 PM
sybase.powerbuilder.connection
3893 articles. 
0 followers.
2 Replies
505 Views
When I mean 'through code' I mean ASP and vbscript.
|
|
0 |
|
Savvoulidis
8/10/2002 6:53:29 PM
Post this question to the ASA newsgroup sybase.public.sqlanywhere.general and please provide your connection code. /ck "Savvoulidis Iordanis" <iordanis@hotmail.com> wrote in message news:Kbu7WHKQCHA.259@forums.sybase.com... > When I mean 'through code' I mean ASP and vbscript. > > >
|
|
0 |
|
Chris
8/12/2002 3:42:10 AM
Similar Artilces:
How can I connect to an ASA6 DSN using ADO?
As sbj ...
How can I connect to an ASA6 DSN using ADO?
As sbj Here is a sample: <HTML> <HEAD> <TITLE>ADO Example</TITLE> </HEAD> <BODY> <% Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open "DSN=asademo" Set RS=MyConn.Execute("SELECT * FROM Department") %> <table border=1> <tr> <% for i=0 to RS.Fields.Count -1 %> <TH> <%= RS(i).Name %> </TH> <% Next %> </TR> <% WHILE NOT RS.EOF %> <TR> <% for i=0 to RS.Fields.Count -1 %> <TD> <%= RS(i) %> </TD> <%...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. ...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. Please see you original post. Tony wrote: > We have powerbuilder 10.2, it use i-connect 2.8.1 to connec...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. Sorry, is the the correct place to post my question? any TeamSybase member can help? Thanks Tony I thin...
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application. ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048) I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver. Can any body point out the core reasons of the above error message? Thanks. Nouman Khawaja. I do have the same problem, help me out. Thanks If the going seems easy, You are going DownHill... When I was writing ...
If I use javascript in my pages, can I still use ADO to connect to SQL server?
I'm not exactly sure what I'm doing here. (I'm sure it shows) I want to start using javascript and ajax in my ASP.net pages, but am currently using ADO (I think) to communicate with my SQL server. Here's a sample script.. Dim objConn As New SqlConnection(ConfigurationSettings.AppSettings("DSN")) Dim objCmd As SqlCommand Dim objRdr As SqlDataReader Sub LoadMenubar() Try objConn.Open() objCmd = New SqlCommand("SELECT * FROM Menubar ORDER BY Priority", objConn) &...
Powerbuilder components use only 1 connection from connection cache
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
Why we use Web.Config File for connection string wether we can use class Library for get connection for whole web Application
Why we use Web.Config File for connection string wether we can use class Library for get connection for whole web Application please help me? Friend, Web.config has its own advantages. 1) Web.Config is used to store the important information like connections strings etc...so that it can be modified even after the code has been deployed to the server without compiling the entire application again. 2) Since it is a XML file, there is no need of building the project of you are going to change the connection strings. If you go for the class files,...
When using MS-ADO to connect to ASE using ASE OLEDB/ODBC driver the record count is -1
Hi VB 6 application connecting to ASE 12.5 (NT) using OLEDB/ODBC drivers. Gets a problem. He retrieve rows from the database - WORKS Fine!!! But as soon as he wants to see how many rows was returned the recordcount returns -1. He gets this problem connecting using ODBC and OLEDB. He gets the recordcount from the recordset object's recordcount property. This is what I found on the MSDN online manuals: RecordCount Property - ADO Indicates the current number of records in a Recordset object. Applies To Recordset Remarks Use the RecordCount property to find out how many r...
Powerbuilder components use only 1 connection from connection cache #2
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
not connected when I am connected
What do I need to change on my 'puter when the icon in the toolbar shows and tells me I am connected and the error message tells me I am not and I can not go to web pages, get or send emails. I have to close down and restart to get connected again. This only happens if I am on line and leave the 'puter for an hour or so. As long as I am using it I don't have a problem. This just started about a month ago. I am on very slow dialup, DSL and Cable not in my area, thanks you SBC/ATT tks Elaine wrote: > What do I need to change on my 'puter when the icon in ...
Powerbuilder components use only one connection of 50 conn connection cache
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
Can't connect to Access Data Base with ODBC connection
I am using Visual Web Developer and trying to connect to an Access data base in the code behind page Default.aspx.vb. I can't connect to my data base with the following code: Dim connectionstring As String connectionstring = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\asp\test02\App_Data\company.mdb;User Id=admin;Password=;" Dim myConn As OdbcConnection = New OdbcConnection(connectionstring) myConn.Open() I alwasy get : "Data Source not found and no default driver found:. Does anyone know what I am doing wrong ?? Check ou...
As sbj ...
How can I connect to an ASA6 DSN using ADO?
As sbj Here is a sample: <HTML> <HEAD> <TITLE>ADO Example</TITLE> </HEAD> <BODY> <% Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open "DSN=asademo" Set RS=MyConn.Execute("SELECT * FROM Department") %> <table border=1> <tr> <% for i=0 to RS.Fields.Count -1 %> <TH> <%= RS(i).Name %> </TH> <% Next %> </TR> <% WHILE NOT RS.EOF %> <TR> <% for i=0 to RS.Fields.Count -1 %> <TD> <%= RS(i) %> </TD> <%...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. ...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. Please see you original post. Tony wrote: > We have powerbuilder 10.2, it use i-connect 2.8.1 to connec...
What i-connect driver can be used for Powerbuilder 10.2.1 connect to Informix 11.50?
We have powerbuilder 10.2, it use i-connect 2.8.1 to connect to informix v7.3 database, we are planning to upgrade informix to version 11.5, can someone tell me what version of i-connect (or informix client sdk) can work with powerbuilder 10.2 and informix 11.50? what powerbuilder native driver need to be installed? can we use the most recent i-connect version v3.5 and "IN9 informix v9.x" native drive? anybody have any issue with this setup? Thank you in advance. Sorry, is the the correct place to post my question? any TeamSybase member can help? Thanks Tony I thin...
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application. ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048) I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver. Can any body point out the core reasons of the above error message? Thanks. Nouman Khawaja. I do have the same problem, help me out. Thanks If the going seems easy, You are going DownHill... When I was writing ...
If I use javascript in my pages, can I still use ADO to connect to SQL server?
I'm not exactly sure what I'm doing here. (I'm sure it shows) I want to start using javascript and ajax in my ASP.net pages, but am currently using ADO (I think) to communicate with my SQL server. Here's a sample script.. Dim objConn As New SqlConnection(ConfigurationSettings.AppSettings("DSN")) Dim objCmd As SqlCommand Dim objRdr As SqlDataReader Sub LoadMenubar() Try objConn.Open() objCmd = New SqlCommand("SELECT * FROM Menubar ORDER BY Priority", objConn) &...
Powerbuilder components use only 1 connection from connection cache
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
Why we use Web.Config File for connection string wether we can use class Library for get connection for whole web Application
Why we use Web.Config File for connection string wether we can use class Library for get connection for whole web Application please help me? Friend, Web.config has its own advantages. 1) Web.Config is used to store the important information like connections strings etc...so that it can be modified even after the code has been deployed to the server without compiling the entire application again. 2) Since it is a XML file, there is no need of building the project of you are going to change the connection strings. If you go for the class files,...
When using MS-ADO to connect to ASE using ASE OLEDB/ODBC driver the record count is -1
Hi VB 6 application connecting to ASE 12.5 (NT) using OLEDB/ODBC drivers. Gets a problem. He retrieve rows from the database - WORKS Fine!!! But as soon as he wants to see how many rows was returned the recordcount returns -1. He gets this problem connecting using ODBC and OLEDB. He gets the recordcount from the recordset object's recordcount property. This is what I found on the MSDN online manuals: RecordCount Property - ADO Indicates the current number of records in a Recordset object. Applies To Recordset Remarks Use the RecordCount property to find out how many r...
Powerbuilder components use only 1 connection from connection cache #2
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
not connected when I am connected
What do I need to change on my 'puter when the icon in the toolbar shows and tells me I am connected and the error message tells me I am not and I can not go to web pages, get or send emails. I have to close down and restart to get connected again. This only happens if I am on line and leave the 'puter for an hour or so. As long as I am using it I don't have a problem. This just started about a month ago. I am on very slow dialup, DSL and Cable not in my area, thanks you SBC/ATT tks Elaine wrote: > What do I need to change on my 'puter when the icon in ...
Powerbuilder components use only one connection of 50 conn connection cache
Hi all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i tested this f...
Can't connect to Access Data Base with ODBC connection
I am using Visual Web Developer and trying to connect to an Access data base in the code behind page Default.aspx.vb. I can't connect to my data base with the following code: Dim connectionstring As String connectionstring = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\asp\test02\App_Data\company.mdb;User Id=admin;Password=;" Dim myConn As OdbcConnection = New OdbcConnection(connectionstring) myConn.Open() I alwasy get : "Data Source not found and no default driver found:. Does anyone know what I am doing wrong ?? Check ou...
Web resources about - How can I connect to an ASA6 ODBC using ADO and vbscript? - sybase.powerbuilder.connection VBScript - Wikipedia, the free encyclopedia
.vbs, .vbe, .wsf, .wsc (.hta, .htm, .html, .asp) VBScript ( V isual B asic Script ing Edition) is an Active Scripting language developed by Microsoft ...
.vbs, .vbe, .wsf, .wsc (.hta, .htm, .html, .asp) VBScript ( V isual B asic Script ing Edition) is an Active Scripting language developed by Microsoft ...
EMET security tool updated to prevent VBScript God Mode attacks
... Toolkit (EMET), a free exploit prevention tool, to protect against attacks that attempt to bypass Internet Explorer's sandbox using VBScript. ...
... Toolkit (EMET), a free exploit prevention tool, to protect against attacks that attempt to bypass Internet Explorer's sandbox using VBScript. ...
Microsoft EMET blocks 'VBScript God Mode'... stop processes running malicious scripts via IE’s script engine. That’s good news as it’s a particularly powerful hack, and the basic " VBScript ...
Send HTML email from VBScript using CDO
Summary : VBScript to send HTML (and plain text) email. It's 2013 and apparently there are no tools that would allow you to easily test sending ...
Summary : VBScript to send HTML (and plain text) email. It's 2013 and apparently there are no tools that would allow you to easily test sending ...
Microsoft Security Advisory (981169): Vulnerability in VBScript Could Allow Remote Code Execution
... about this issue, including download links for an available security update, please review MS10-022 . The vulnerability addressed is the VBScript ...
... about this issue, including download links for an available security update, please review MS10-022 . The vulnerability addressed is the VBScript ...
Rumours of VBScript's Death Have Been Greatly Exaggerated
li.tag-item').show(); $('#TagLessLink').show(); $('#TagMoreLink').hide(); return false;" /> More ▼ li.tag-item').hide(); $('#TagMoreLink').show(); ...
li.tag-item').show(); $('#TagLessLink').show(); $('#TagMoreLink').hide(); return false;" /> More ▼ li.tag-item').hide(); $('#TagMoreLink').show(); ...
Researchers find new PoS malware written in VBScript
In the wake of a large-scale attack on point-of-sale (PoS) systems at retailer Target, new malware designed to steal payment card data from the ...
In the wake of a large-scale attack on point-of-sale (PoS) systems at retailer Target, new malware designed to steal payment card data from the ...
Researchers find new PoS malware written in VBScript... on Jan. 3. The release shows that cybercriminals are increasingly interested in launching this type of attack. The malware is written in VBScript ...
Office MACROS PERIL! Age-old VBScript tactic is BACK in biz attack
'Office macro exploits only cool thing Visual Basic used for,' quips securobod The dangers of allowing Office macros have been underlined by ...
'Office macro exploits only cool thing Visual Basic used for,' quips securobod The dangers of allowing Office macros have been underlined by ...
A break from the past, part 2: Saying goodbye to ActiveX, VBScript, attachEvent…We recently posted “A break from the past: the birth of Microsoft’s new web rendering engine”, an in-depth look at the background and motivation ...
Resources last updated: 1/5/2016 7:59:13 AM