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

1339

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

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

C / C++

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

.NET Framework

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

ASP.NET

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

Visual Basic .NET

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

C / C++

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

C / C++

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

Java

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

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

.NET Framework

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

Java

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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

C / C++

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

General

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

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

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

php

by: muto222 | last post by:

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

PHP