close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 2/08/2011 8:59 pm by suarezm129397438 | Last modified 2/14/2011 5:30 pm by Jason Byrnes | 5896 views | 7 replies |

suarezm129397438

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

I'm getting the following error when I try to test my log in page:

ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/mstest1/WA_SecurityAssist/Helper_JS.asp, line 15

I have gone through the turial, and have tried to set up the log in pages several times and still get the same error. Attched is a zip file containing the login, log out pages along with the WA_SecurityAssist folder containing the applicable *_JS.asp pages. Help!

Attached Files
mstest1.zip
Sign in to reply to this post

Jason ByrnesWebAssist

Line 15 is looking at the database connection

How is your connection defined?

Are you using MS SQL Server or an MS Access Database?

Can you send a copy of the Connections/thscData.asp file.

one thing that jumps out at me is line 9:
WA_Auth_Parameter.tableName = "null.admin";

Is "null" the name of your database?

This is a reserved word in the SQL language and should be avoided when naming database objects.

Sign in to reply to this post

suarezm129397438

I set up a OLE DB virtual connection. This is the connections string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("\mstest1\data\thscData.accdb")

I'm using an access database (MS 2007)

I've attached the connections file thscData.asp

The name of the database is:
thscData.accdb

The table with the id/pw info is called:
admin

I did notice that the database pannel in Dreamweaver (CS4) the table names and views have "null." preceding each of the names.

Thanks for your help.

Attached Files
thscData.zip
Sign in to reply to this post

Jason ByrnesWebAssist

are you testing the page locally or remotely?

If you are testing remotely, you may not be able to use the Microsoft.ACE.OLEDB.12.0 provider in the connection string. you may need to use Microsoft.Jet.OLEDB.4.0 as the provider.


also, check that the Server.MapPath function is actually locating the database. create a blank ASP JS Page, and add the following code to double check it:

DB Path: <%=Server.MapPath("\\mstest1\\data\\thscData.accdb")%>
Sign in to reply to this post

suarezm129397438

I was able to get it to work testing locally using the following OLE DB connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\mstest1\data\thscData.accdb;Persist Security Info=False;"

However it still does not work on the server.

I checked the path as you suggested and this is what came back.
When I run it locally I get:
DB Path: c:\inetpub\wwwroot\mstest1\data\thscData.accdb

When I run it on the server I get:
\\10.0.40.33\mstest1.com\public\mstest1\data\thscData.accdb

I think the correct path to the database on the server is:
\\10.0.40.33\mstest1.com\public\data\thscData.accdb

I've tried severl different things and I still cannot get the connection to work on the server.

Sign in to reply to this post

Jason ByrnesWebAssist

have tried hard coding the path:
\\10.0.40.33\mstest1.com\public\mstest1\data\thscD ata.accdb

in the connection string:


Data Source=\\10.0.40.33\mstest1.com\public\mstest1\data\thscData.accdb


or if you think \\10.0.40.33\mstest1.com\public\data\thscData.accdb is the coorect path try using that:
Data Source=\\10.0.40.33\mstest1.com\public\data\thscData.accdb


the server may not have the Microsoft.ACE.OLEDB.12.0 available, like i said before, so you may need to change the provider to use the Microsoft.Jet.OLEDB.4.0 provider instead.

Sign in to reply to this post

suarezm129397438

I finally got it to work on the server using the following connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\10.0.40.33\mstest1.com\public\data\thscData.accdb;Persist Security Info=False;"

The problem that I was having was because when I test locally I use this connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\mstest1\data\thscData.accdb;Persist Security Info=False;"

and I was not switching to the server connection string prior to testing on the server. My question is:

Is there a way to automate which connectin string is used depending on where program is being used (local vs server)? Or do I have to manually switch back and forth between these two connection strings?

Sign in to reply to this post

Jason ByrnesWebAssist

For asp, no, there is not a way to automate which is used.

For PHP we offer a Dynamic Connection extension for this.

For ASP, i recommend changing the connection to use the remote connection string, uploading it to the server, then changing the permissions on the connections file on the remote server to read only. This way, when you revert the connection to the local connection string, Dreamweaver will fail if it tries to over write the one on the server.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...