I have the following lines in my asp, but somehow
it isn't working, can someone help me resolve it?
---Comm = "DSN=HRPROD "
Server="MYSERVE R"
Response.Write ("Server Name ") & Server
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Response.Write ("After Conn ")
Conn.Open Comm
when I execute this, I do get valid response
Server Name MYSERVER
But I don't see the 2nd response "After Conn "
as a result I am unable to see any output after that.
Thanks for your help!
-Me
3  1445 
Me wrote:
I have the following lines in my asp, but somehow
it isn't working, can someone help me resolve it?
---Comm = "DSN=HRPROD "
Server="MYSERVE R"
Response.Write ("Server Name ") & Server
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Response.Write ("After Conn ")
Conn.Open Comm
when I execute this, I do get valid response
Server Name MYSERVER
But I don't see the 2nd response "After Conn "
as a result I am unable to see any output after that.
not even an error message?? Do you have "On error Resume Next" before
this code snip? if so, comment it out and try running the page so you
can see the error.
Beyond that, we cannot help because you have failed to provide the
database type (and version) to which you are attempting to connect.
For self-help see: http://www.aspfaq.com/show.asp?id=2126
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Hi Bob,
Thanks for quick response. It doesn't display any error message.
No, I don't have on error clause before this.
I am using similar code in another page and its working fine. I just copied it
from the other page into this one and it doesn't work.
The other code is also on the same server. That's why I don't think
there is anything wrong with the way I have specified the connection.
But can't think why it shouldn't work.
Here is the complete string for your info ...
Comm = "DSN=MYDSN"
Server="MYSERVE R"
Response.Write ("Server Name ") & Server
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Response.Write ("Connection ")
Conn.Open Comm
Please let me know if you have ideas.
"Bob Barrows [MVP]" wrote:
Me wrote:
I have the following lines in my asp, but somehow
it isn't working, can someone help me resolve it?
---Comm = "DSN=HRPROD "
Server="MYSERVE R"
Response.Write ("Server Name ") & Server
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Response.Write ("After Conn ")
Conn.Open Comm
when I execute this, I do get valid response
Server Name MYSERVER
But I don't see the 2nd response "After Conn "
as a result I am unable to see any output after that.
not even an error message?? Do you have "On error Resume Next" before
this code snip? if so, comment it out and try running the page so you
can see the error.
Beyond that, we cannot help because you have failed to provide the
database type (and version) to which you are attempting to connect.
For self-help see: http://www.aspfaq.com/show.asp?id=2126
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Me wrote:
Hi Bob,
Thanks for quick response. It doesn't display any error message.
No, I don't have on error clause before this.
I am using similar code in another page and its working fine. I just
copied it from the other page into this one and it doesn't work.
The other code is also on the same server. That's why I don't think
there is anything wrong with the way I have specified the connection.
But can't think why it shouldn't work.
Here is the complete string for your info ...
Comm = "DSN=MYDSN"
Server="MYSERVE R"
Response.Write ("Server Name ") & Server
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Response.Write ("Connection ")
Conn.Open Comm
Please let me know if you have ideas.
Based on this, I have nothing to add.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: BP |
last post by:
I get the following error: Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/myweb4/authorised_user_page.asp, line 70
and line 70 of my code is: <% rsCheckUser1.Open strSQL1,
strcon1 %>
Here is the full code:
|
by: gonzal |
last post by:
Hi
Dose any body know why a temporary table gets deleted after querying it the
first time (using SELECT INTO)?
When I run the code bellow I'm getting an error message when open the temp
table for the second time.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E37)
Invalid object name '#testtable'.
|
by: Pragati |
last post by:
Hi !
I have an SQL query which im developing on the click of a command
button on a form.
but am stuck up in creating a recordset of that query.
how should one connect to database? use adodb or dao connection? are
there any particular setting reqd in vb editor?
what will be the syntax for connecting to a databse?
what shud be the syntax for opening my query in a recordset?
|
by: billmiami2 |
last post by:
Perhaps many of you MS Access fanatics already know this, but it seems
that stored procedures and views are possible in Jet. I thought I
would leave this message just in case it would help anyone.
I discovered this the other day while doing some experiments with ADO
and ADO.NET. Basically, I wanted to run a stored MS Access query with
parameters using the syntax
Execute MyProcedure @Param1, @Param2...
|
by: Jozef |
last post by:
Hello,
I'm trying to create a central function that runs a connection to an SQL
Server database. The connection etc works, but when I try to call it, I get
an error saying "Runtime-Error 91: Object variable or with block variable
not set". I have pasted the code below. The first section is the function
that I'm using, the second function is only the test that calls teh
genErrorColl function
'***************** Start Code...
| | |
by: Ken Kazinski |
last post by:
Does anyone know of a good example for creating a access database and then
tables within that database.
All the examples I have found so far use a SQL database.
Thanks,
Ken
|
by: MG |
last post by:
Hello all,
Perhaps you can help me. I have a com object which I converted from VB6
to VB.NET. I am using this com object with other .Net applications
without any problem. However, I am now trying to use this com object in
some old ASP code which I have not yet converted. I want to use the com
object because it contains some additional functionallity that the
original com object did not possess. The ASP code works fine when
calling the old...
|
by: Bhavsan |
last post by:
Here is what I am trying to do. Kindly, help me.
1. I'm creating a query dynamically based on User input using VBA
(strSQL and DotSQL in the code below)
2. Executing the created query with in VBA
3. Writing to a table (tblRandom) the values from the recordset.
--------------------------------
Private Sub append_record_Click()
Dim strSQL As String
Dim dotsql As String
|
by: mramsay |
last post by:
Hi,
I'm having a real problem creating a dynamic hyperlink for my website.
I want to pull the field name from mysql table. Field name is description.
I would like this to be a hyperlink on my homepage. Also, when the user clicks on the description hyperlink they should see a dropdown with other hyperlinks such as hockey, baseball, etc.
Here is what I have so far. I am new to asp and mysql, I would really appreciate the help.
% ...
|
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...
|
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...
| | |
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...
|
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...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
