navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Using SQL connection string

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Using SQL connection string
Page: [1]
 
Topic Starter

 

Posts: 49
From: Canada, eh?
Status: offline

 
Using SQL connection string - 11/28/2001 20:00:00   
I am coding in ASP using a SQL database for the 1st time. I am having a problem using the FP Connection string.

This is my code:

var conDB = Application("eCast_ConnectionString");
conDB.ConnectionTimeout = 2;
conDB.CommandTimeout = 2;
conDB.CursorLocation = 3;
conDB.Open("eCast", "", "");

szSQL = "SELECT * FROM Users";
var rs = Server.CreateObject("ADODB.Recordset");
rs.open(szSQL, conDB, 3, 3);

Response.Write("<p>");
Response.Write("username="+Request("uname")+"<br>password="+Request("password")+"<p>");

rgFields = new Array("szName","szPassword","szAddress","szCreditCardNumber");
rgValues = new Array(Request.Item("uname"), Request.Item("password"),"None","1111");
rs.addNew(rgFields, rgValues);
rs.Update();

rs.Close();
conDB.Close();

And this is my error:

Microsoft JScript runtime error '800a01b6'

Object doesn't support this property or method

/ecast/PublishEservice/Publish_CommitNewAccount.asp, line 19

Whats up????

Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Using SQL connection string - 11/28/2001 22:16:00   
Jscript?

Is the server default perhaps wrong?
I dont do jscript, but it looks mostly VB to me (apart from using + instead of &)

Which is 19?


(in reply to Topic Starter)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Using SQL connection string
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts