ASP Connection Conflict
I have created a Membership Directory that is sorted alphabetically using ASP/VBS/Access (although the access was converted to mysql before loading to remote server). It runs perfectly on my local server, but I cannot run when loaded to remote server.
Tech support for webhost sent me a "test.asp" w/working connection string, but putting it into the connection include file causes an "empty connection string" error in my asp doc. I don't know how to clear up the conflict. Code:
View Replies
ADVERTISEMENT
for some reason, when i run my website through my browser as a local host (IIS) to test the asp, the asp works but the javascript doesnt, when i run the website through the browser normally, obviously the asp doesnt work but the javascript does!!!!
is there a reason for this?? is it a problem if i when live with it??
or is this just what happens???
View Replies
View Related
I have an ASP 2.0 Web site I'm building and I'm adding Atlas to one of the pages. I've created a simple Web Service as a separate project and compiled it. The Web Service has a class to connect to our SQL Server to get data. The service takes two strings and an array of SQL Parameters. I have added the Web Service reference to my Web site app in the App_WebReferences folder.
when I create an instance of the Web Service it attaches the local namespace of the Web Service to the SQLParameter type and gives me an error like: "Value of type '1-dimensional array of System.Data.SQLClient.SqlLParameter' can not be converted to '1-dimensional array oflocalhost.SqlParameter'.because 'System.Data.SqlClient.SqlParameter' is not derived from 'localhost.SqlParameter'.Why is it doing that?
View Replies
View Related
I have coded an application on an XP Platform with a Microsoft Access backend.
1. On my development system I have successfully ran the application using Internet Explorer where I type: http://localhost/sad.
2. The customer wants this application to be self contained and working off a CD. So, I burned the application on a CD, created a virtual directory and in IE typed: http://dhurtu/testapp/sad and again no problem worked beautifully.
3. I took the CD, went to my IBM laptop it is configured the same way as my development machine. Again it worked flawlessly.
4. I went on machine similar to the customer's configured with Windows 2000 Professional and IIS 5.0. We created a virtual directory, put in the CD and the application worked beautifully.
5. At the customer site I wasn't so lucky! I put the CD in, created the virtual directory. Fired up Internet Explorer got the greeting screen, made a search and from the search made a selection to get further details ... AND CRASH ... ADODB.Recordset ......
My question is simple. Why would this application work on three different machine and then fail on another.
Customer machine runs Microsoft Windows 2000 (5.00.2195) Service Pack 4. IIS was not installed when I first got there and therefore I installed it. The install CD was not of SP4 vintage but of year 2000 vintage. It seems to me that the IIS version on the client machine is 5.0. Code:
View Replies
View Related
i got this error message
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/searchresults.asp, line 21
from the code in my site
Code:
View Replies
View Related
I am having problem regarding utf8 (used by MySQL) and utf16 (used by WinXP)
I want to store the CJK string into both MySQL and use the string to create a new file name. The problem here is，if the string is in utf8, MySQL can accept it, but the filename will have strange character.
If the string is in utf16 format, MySQL will store as '???', and the filename will be created correctly in WinXP.
I have attached my code. Notice that, If I set @CodePage=65001 'UTF-8'
WinXP/IIS will convert all the UTF8 string in the asp file to UTF16 for internal processing. MySQL can only accept utf8 for client connection, so aftｅｒ UTF16 converted to UTF8, ??? will appear. Code:
View Replies
View Related
I am having problem regarding utf8 (used by MySQL) and utf16 (used by WinXP)
I want to store the CJK string into both MySQL and use the string to create a new file name. The problem here is,if the string is in utf8, MySQL can accept it, but the filename will have strange character.
If the string is in utf16 format, MySQL will store as '???', and the filename will be created correctly in WinXP. Code:
View Replies
View Related
I have an simple ASP form and I am using the following statement to get the
values:
emailFrom = Request.Form.Item("ctrl:EmailFrom")
emailTo = Request.Form.Item("ctrl:EmailTo")
However, after I added attribute ENCTYPE="multipart/form-data" to the HTML
tag <Form> for uploading files (not implemented yet). The above code doesn't
work and the value of Request.Form.Item("...") become "Undefined".
How to solve the problem?
View Replies
View Related
I have created a login page for my website but I am trying to add some code to the page so that once a user has voted they can't keep on voting. Code: ...........
View Replies
View Related
Iam using a filter in asp and it doesn't work with the wildcard '_' or even using IN it only works with LIKE '% (anydata) %'. In my table i have a column, which stores values as 1,23,40 etc. How do i get it to bring back all rows where X='1' and not X LIke '%1%'
I get the following error message:
'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'
View Replies
View Related
I'm trying to connect a dbase but an error appear. This is the error type:
"ADODB.Recordset(0x800A0BB9) arguments are of the wrong type are out of acceptable range or are in conflict"
I used the code for example:
rs.Open "SELECT * FROM table1", db, adOpenStatic, adLockPessimistic
The microsoft ASP documentation says that adOpenStatic, adLockPessimistic, equals to 3,3 notation. I used first the code above then the error appears. But when I change it to 3,3 it runs ok.
View Replies
View Related
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
View Replies
View Related
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
View Replies
View Related
I am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
View Replies
View Related
this is my error:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
here is my db connection string:
<%@Language=VBScript%>
<!--#include file="adovbs.inc"-->
<%
dim rs, cn
Set cn = Server.CreateObject("ADODB.Connection")
'with cn
' .Provider="Microsoft.jet.oledb.4.0"
' .ConnectionString=Server.MapPath("home/nfiweb.mdb")
' .Open
'end with
cn.open "nfijobs"
set rs = Server.CreateObject("ADODB.Recordset")
%>
View Replies
View Related
When I click submit after updating the information all of my info gets deleted from the db so I'm guessing that the values that are being submitted are not getting picked up in the sql. I've tried changing the form names, etc, but still have the same prob. My code is below: Code:
View Replies
View Related
I am having trouble connecting to an Access db fro mmy asp page. I get the following error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Code:
View Replies
View Related
I'm using an SQL2K backend and attempting to connect to it with the following code.
' -- Connection String Value
response.write "Setting strConnection"
strConnection = "DSN=tracktimedb"
' -- Our SQL Statement
response.write "Declaring SQL Statement"
strSQL = "SELECT * FROM TIMES"
' -- Populate our Recordset with data
Set objRS = GetRecordset(strConnection, strSQL)
I have done many searches but all the connection strings I've found seem to be using a DSN to an access DB. Currently I get this error when trying to connect.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can't seem to find the proper syntax to specify a db login (sa) and password in the connection string.
View Replies
View Related
on 1 page i open
a connection to a database and build a recordset to check
username and password. there are other fields in the db
that i need to access on the next page. how do i reference that
connection and run a new sql query without having to reopen the connection?
i thought it would be as simple as NOT closing it, but thats not working.
View Replies
View Related
I am having problem in my connection to database when running ASP.
It works fine for the first time but if I run it again without a gap of atleast a minute,
it gives me the following error message:
Error Type:
Provider (0x80004005)
Unspecified error
And the line it is showing error is where I am opening my database connection using conn.open.If I wait for couple of minutes and run again,it works fine.
View Replies
View Related
I'm trying to maintain a permanent tcp/ip connection between two
computers using ASP. I need users accessing the ASP pages to be able
to send and receive messages using this connection. I know that I
can't use a Winsock control with ASP so I guess I'm looking at a third
party control. Even if I can get this working I'm not sure that I can
have different users accessing this one permanently open connection.
I've looked all over the Net for ideas on how to do this but I've had
no luck. Has anyone had to do anything like this?
View Replies
View Related
I am trying to establish an ODBC conection to ORACLE 10g and have tried all the following. Please advise:
We are trying to connect to a 10 g server and nearly gone crazy after doing so. tried everythign, DSN, DSN less .... The bottom line the connection is successful when we try it form the control panel-> data source thing but not from ASP. We tried the following things: Code:
View Replies
View Related
I created a master detail page using the wizard in Dreamweaver, however I need to create a DSN-less connection. How do I do that? I am assuming I need to edit this part of my code:
View Replies
View Related
Can anyone help me create a dsn less connection to the sql server 2005 db
from the connection.asp file below please,
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_TobiasNET_STRING
MM_TobiasNET_STRING = "dsn=TobiasNET;uid=sa;pwd=*******;"
%>
Need detailed explanation if poss or even better an example.
View Replies
View Related
Need to implement an online payment facility, which requires SSL
encryption. I have bought the keys and they are installed on the server
(IIS5)
Can anyone point me in the right direction for help in activating the SSL
encryption using asp - tutorials or sample scripts etc?
View Replies
View Related
I am getting 500 Internal Server Error. I have tried disabling the show
friendly error in IE and I have tried it on Firefox. It will not give me the
reason why it will not work, I only get 500 Internal Server Error.
I have tested the code up to the point of Set objConn and it works but when it gets
to the objConn.open dsn that's when I get the error. I wish to find out why
it is not allowing it to get pass this point. I have control of the server
where this is hosted and if there is anything I need to do, I can do it.
View Replies
View Related
I am trying to create a web page on our company intranet.I am using Frontpage 2000.I need to be able to read from and write to databases in this project.I am starting slow since I am just learning, so for now I am trying to read from an existing SQL database on a network server. The server is running SQL Server 2000 and IIS.
I could create a database connection using the Database Results Wizard in FP. The connection would verify OK and I could select the columns from the table I wanted to display. When I published the page to the server, all I got was column headings, no data.
when I try to create a new db connection, it will verify, but it will not show up as an existing db connection.
View Replies
View Related
need to connect DB2 tables on mainframe, using a ASP front end...But I do not know how to... what all things I should enquire & need in the system before doing the same. connection format to connect a databse on mainframe.
View Replies
View Related
My client have a allready built database. and now need to access that database with asp.
How do i connct to a sql database through asp? Would like to use mapPath() in stead of a DSN. Could only find DNS examples on the net.
View Replies
View Related
I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files.
MyODBC = "SQLODBC
MyUsername = "sa
MyPassword = "password
Set objADODBConn = CreateObject("ADODB.Connection"
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";
objADODBConn.Open(strConn
Any suggestion? Is there anything we miss? Can anyone give us an example to make a ODBC connection in an asb file.
View Replies
View Related
I have no idea of how to connect to my database (access) to my asp pages using DSN (ODBC). I've already upload my database file in the folder called db and I've already added DSN. Can you guys provide me some sample code?
View Replies
View Related
Iam trying to connect to my database using dreamweaver but I am told that I do not need it ! I can't understand how am I supose to use my Database? I refere to DSN, user name and passoword, but I was told no need for it as I can just do some coding, so is there anyway I can code it ?
my host company cannot understand that I need a DSN connection and when I asked about the password they tell me...no need for it.
View Replies
View Related
I have a client Gallery i am setting up for clients to view and approve their work online in their private area, the database is set up the way i want it, and the site has been set up as an individual site (Gallery only) which i will then transfer onto the backend of my site.... (client entry)
But i want to be able to just copy the whole folder Client Gallery mentioned above) into a new subfolder for a new client and continue to do so for each client, so they will be able to view their work without me having to change anything in my ASP pages every time i get a new client, the database uses a link to the images & their not stored directly in Access.
if i use the same database and DNS but its in a different folder along with its gallery script and script pages it uses, will it only refer to that new folder its in and folders following or will it search the whole directoy within the site and get confused due to the same database connection with different images or different linked folders.
View Replies
View Related
