problem with SQLattr failed please help me!!!!!!

3 New Member

Hello everyone,

Here is my coding just check anyone and tell me where is problem please send me email also on (please send me a PM) please do any one

Expand|Select|Wrap|Line Numbers

 <%@LANGUAGE="VBSCRIPT"%> 

<!--#include file="Connections/ravi.asp" -->

<%

Dim raj

Dim raj_numRows
 
Set raj = Server.CreateObject("ADODB.Recordset")

raj.ActiveConnection = MM_ravi_STRING

raj.CursorType = 0

raj.CursorLocation = 2

raj.Source = "SELECT *  FROM employee"

raj.LockType = 1

raj.Open()

raj_numRows = 0

%>

<script language="VBScript" type="text/VBScript">

set.cnn = Server.CreateObject("ADODB.Connection")

open.connection

cnn.open("Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=D:\trupti.mdb;Uid=xxx;Pwd=xxx;" )

"Driver= {MicrosoftAccessDriver(*.mdb)};

DBQ=D:\trupti.mdb;Uid=xxx;Pwd=xxx;"

open.recordset

set raj = server.CreateObject("ADODB.Recordset")

strSQL= "select * from employee"

raj.open strSQL,cnn,3,2

insert into employee('First_name','Last_name','Telephone','Email','Comments')

values("&txtfname.txt&","&txtlname.txt&","&txtteleno.number&","&txtEmail.memo&","&txtComments.txt&")

if NOT raj.eof Then

while NOT raj.EOF

raj.movenext

wend

end if      

</script>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
<FORM METHOD="post" ACTION="test.asp">

    First_name<INPUT TYPE="text" NAME="First_name"><BR>

    Last_name<INPUT TYPE="text" NAME="Last_name"><BR>

    Telephone<INPUT TYPE="text" NAME="Telephone"><BR>

    Email<INPUT TYPE="text" NAME="Email"><BR>

    Comment<INPUT TYPE="text" NAME="Comment"><BR>

  <INPUT name="add" TYPE="submit" id="insert" VALUE="Insert">

</FORM>
 
  <%

raj.Close()

Set raj = Nothing

%>

</body>

</html>

May 25 '07 #1

Subscribe Reply

1346

jhardman

3,406

Recognized Expert Specialist

Which line gives you an error and what is the error exactly?

Jared

May 25 '07 #2

Similar topics

2075

Problem with push_back,help me ASAP

by: AnuSree | last post by:

hi am getting error when am trying to type cast.is it possible to type cast from one type of vector to another type.is there any other way other than overloading.my peice of code in which am getting error is.

C / C++

1022

Problem With Remoting Help ME

by: Gigi | last post by:

I have write a DLL server I have this problem : when I call one specific function to the inside Class i have this error : "Impossible to find the constructor demanded for deserialize a object of type DllServer.NetApi+cColl This is my Class, I have only specified the interested part Public Class NetApi

.NET Framework

1023

Reg: Help me out pls...

by: RamaKrishna | last post by:

Hi All: I created a .NET web service in .NET Beta2.0...And am calling this web service from VisualBasic 6.0...using SOAP ToolKit (Both versions 2 and 3 r working fine)...It's working fine...Now i have upgraded .Net Framework from Beta 2.0 to Version 1.1 (Latest Version).......When am calling to .Net web service which was created in the latest version .NET 1.1, it's not working? Getting error like "Object doesn't support this property/ ...

ASP.NET

1015

please help me.textbox do not work well

by: lemonvital | last post by:

i have a main form and i want to ada a childform,so i do it with the way such as me.controls.add code : Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click If IsNothing(lead) Then lead = New lead lead.TopLevel = False Me.Controls.Add(lead) lead.Top = (Me.Height - lead.Height) / 2

Visual Basic .NET

2305

Help me with Concatenating strings

by: c | last post by:

Hi everybody. I'm working on converting a program wriiten on perl to C, and facing a problem with concatenate strings. Now here is a small program that descripe the problem, if you help me to solve in this small code, I can solve it on my own program...you don't want to have head-ache :-) So, the problem excatly is, I built an array..just like this one.

C / C++

1455

Please, help me. It's destructor problem

by: kwangbok.kim | last post by:

Hi. I'm major in computer science. While studying with the what kind of document, the problem got. Please help me. The lower part is the program... Programming with visual c++ 6.0 at windows xp -------------------------------------------------------------------------------------------- #include <iostream.h> #include <string.h>

C / C++

1263

Another "while loop problem": anyone, help me please? :-)

by: aprilmae36 | last post by:

Nice day to all... Here I am again, having another problem with loops... lol... Can you please help me make a while loop program that the output will be like this: 1 121 12321 1234321 123454321 :-)

Java

1255

pls help me with this!!!!

by: angelcd | last post by:

hi guys, i have a problem on how to this kind of output, i need to write a a code regarding this output: The grade should follow the table below <50 fail 50-59 D 60-69 C 70-79 B

C / C++

1254

Problem in JavaScript Help me :(

by: missshaikh | last post by:

Hi All Friends, i have a Problem in JS. i m working on ASP2.0. I neet to use JavaScript in my page. When user enter the String in TextBox the Java Script Prompt "Enter the Number Only" Means want to validation for integers.

.NET Framework

1352

path specification problem not resolved..help me

by: uhdam | last post by:

Sir the dtd definition file path is to be mentioned in xml file na. in the top of xml file where i need to specify the dtd file path if i give the path as "C:/Documents and settings/Uhdam/Prj/src/Parser/dtdefintion.dtd" it shows me error and specifies that it should be in the format as below "/C:/Documents and settings/Uhdam/Prj/src/Parser/dtdefintion.dtd" So when i use methodname.getAbsolutePath(); it returns an error because it...

Java

8113

What is ONU?

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...

General

8203

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

8378

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

6981

AI Job Threat for Devs

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...

Career Advice

5504

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4007

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4066

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2517

transfer the data from one system to another through ip address

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

C# / C Sharp

1637

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP