473,320 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Missing Something Obvious Here!

I am trying to define the active connection for a command in an ASP page but
I keep getting the error:

---------------------------------------------
ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/LoginControl.asp, line 19

--------------------------------

Line 19 is the "cmdDC.ActiveConnection = myConn" line. The code is as
follows:

====================================

Dim cmdDC, RecordSet
Dim strUserName, strPassword

strUserName = Request.Form("txtName")
strPassword = Request.Form("txtPassword")

'-- Create command object
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = myConn

====================================

I use an include file at the start of the ASP page to establish my
connection - the included code is::

====================================

Dim cst, myConn
Sub CreateConnection()
cst = "Provider=SQLOLEDB; Data Source = xx.xx.xx.xx; Initial Catalog =
myDB; User ID = myID; Password=myPW"
set myConn = Server.CreateObject("ADODB.Connection")
myConn.open cst
End Sub

====================================

Any suggestions on what I did wrong here?
--
------------------------------------
Wayne Wengert
wa***@wengert.org
Jul 19 '05 #1
0 1101

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Ola Tuvesson | last post by:
I'm having a really weird problem. When running the SP below in query analyzer the calculated column "Subscribed" is returned as expected: ------------- CREATE PROCEDURE get_mailinglists( ...
1
by: Jim | last post by:
We have a series of stored procedures that utilize some of the master extended SPs such as xp_cmdshell. We migrated to SQL 2000 in April and everything has worked great for over 3 months. However,...
0
by: Andy MacKay | last post by:
I'm not sure if I have a problem or not. I was trained on .NET v1 a while back and remember having a data connector that I dropped onto a VB.NET form. I then configured the properties to connect to...
1
by: Dominick Baier | last post by:
Hi, you are right - Windows needs the password in plaintext to impersonate a user (having to call LogonUser, which requires a password). Thinking about it - it is the only way Windows can do it. ...
0
by: JohnR | last post by:
Hi all.. my application uses a custom dll which should be in the same directory as the exe file. If the dll file is missing the application immediately aborts with a "Application has generated an...
44
by: Tolga | last post by:
As far as I know, Perl is known as "there are many ways to do something" and Python is known as "there is only one way". Could you please explain this? How is this possible and is it *really* a...
2
by: Steven D'Aprano | last post by:
When using the timeit module, you pass the code you want to time as strings: import timeit t = timeit.Timer("foo(x, y)", \ """from module import foo x = 27 y = 45 """) elapsed_time =...
2
by: Chris | last post by:
Hi, I just installed Visual Studio 2005 Professional Upgrade. I did a full install and everything seemed to go fine. Now when I open Visual Studio ASP.NET is missing as a project type. I did...
1
by: BobPaul | last post by:
I'm following code out of a howto book and this is really bugging me. This header file was created by VStudio 6.0 when I did a "Right Click: Add Member Function" CLine is a class I wrote (per the...
9
by: Boltar | last post by:
On 32 bit linux with gcc 4.2 I get unexpected results with this code: main() { int bits = 32; printf("%d\n",(int)1 << (int)32); printf("%d\n",(int)1 << bits); }
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.