Opening Linked Tables
I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however,
I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB.
The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.
View Replies
ADVERTISEMENT
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
View Replies
View Related
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
View Replies
View Related
im trying to link to a Access db which uses linked tables via a odbc connection... is there anything different about the connection string / driver?
adoConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Resources/peterjohntest.mdb")
but this error comes up Code:
View Replies
View Related
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables. I just wanted to know how feasible a LINKED TABLE scenario would be.
If this was possible it would solve so many administration problems and save development time when it comes to building asp-admin pages to manage the backend.
View Replies
View Related
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies
View Related
I am using one combo box and populating it with the values . i have another combo box on the page. I want to display the related values in this second combo box based on the selection in the first combo box.
I am trying to reload this page on the change event of the combo box but the values are not coming in the 2nd combo box . Please send me a solution to this or if possible a sample code for the same.
View Replies
View Related
I have a "booking" section on my intranet.
2 questions.
1. Can I, say by session, determine if a user logged in can amend/delete data they have entered? But no one else.
Say they book a conference room, but only they can delete it
2. I want to prevent cross bookings (in terms) of time.
View Replies
View Related
I've been tasked with the challenge of re-sizing images linked via BBcode on the fly. I have compiled a list of functions that do individual components of this task, but stringing them together has proved, well, a challenge.
I discovered this code that will re-size the images, however this will need to be added on an ad-hoc basis, and the fact that the image name appears twice complicates the usual system I used to add the code.
Usual way of replacing the code (inside a function):
Code:
vText = Replace(vText,"[ img ]","<div align='center'><img align='middle' src='")
vText = Replace(vText,"[/ img ]","'></div>")
Image resize code:
View Replies
View Related
if you have seen an example floating around on the internet of three linked list boxs using asp code and a database connection. I have managed to get it to work for the first 2 list boxs, but I am unable to get it to populate the third list box, this is how it is:-
Tables:-
Main_cat
Sub_cat
Subsub_cat.
Not all Sub_cats will have subsub_cats, hope this makes sense. I have attached the code.
View Replies
View Related
how can i change the options of a combo box when selecting an option of another combo box?
View Replies
View Related
I currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two
------------------ -----------------
Ford Focus
Fiesta
Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
View Replies
View Related
Code:
' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here
could someone give an example so I could follow it?
View Replies
View Related
I want to link 2 list boxes on the same page without reloading it. The list boxes are dynamic and when one selects an item in the first one, the second one get's populated accordingly. So far I've been stuck with Javascript Object Expected Error and I cant find a way to make it work. Code:
View Replies
View Related
I am unable to show and image or flash i have in an access database that is linked to an images subfolder, below is what i am using to show text on my ASP page but i want to ad a couple of images to the database to show in different locations on the page or pages, so i guess i needed a call function but ive used the one i have on my database image rotator scipt and a few others i have dowloaded and still the call scripts wont work, i'm sure im doing alot wrong can someone please edit this code and show me what to do... if its no bother
This works fine for showing the text on a page:
<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open "introtext", "DSN=introTXT.mdb"
While Not rs.EOF
Response.Write "<br>" & rs("Content") & "<br>"
Response.Write "" & rs("URL") & ""
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
%>
View Replies
View Related
I want to create an asp page from these forms in my database:
Database:
Table 1 =>
1.1) ID:
1.2) Product Name
1.3) Description
Table 2 => For the ASP Form
2.1) ID:
2.2) Text field 1 (Normal input field)
2.3) Product (Dropdown Menu, Data Source Table 1, Field 1.2)
2.4) Description (Text Field, Data Source Table 1, Field 1.3)
The Description value should be in correlation with the Dropdown Menu value in Table 1
View Replies
View Related
I want to make a form where m using two drop down menus.
Where in based on selection in first drop down the second drop down should populate itself with relevant data based on first drop down. Like first can be COUNTRY name and second can be STATE name where based oon country selected the STATES are displayed in second drop down for selection.
View Replies
View Related
I have an ASP-page where I want to be able to select a fabric and color of that fabric. Since different fabrics comes with different colors I want to have a form with two drop-down lists where selection of fabric in the first list populates the second list with the right set of colors. I need to have the lists in the same form so it only require one submit.
View Replies
View Related
I'm creating a forum based site with basic BBCode features, but am concerned that misuse of the [ img ] tag will mess up my layout. I do not want to go down to road of users uploading images, but want to allow them to embed images from flickr, photobucket etc.
So, is it possible to restrict all linked images that are say, over 400 pixels wide? I've been racking my brains and have had trouble coming up with any solutions. Is it possible?
View Replies
View Related
I have an application in ASP that exports to Word using the Response.ContentType method.
The application references another ASP page through the img tag that uses a Response.BinaryWrite (of an img content type) for its output.
In other words:
App A.ASP contains the code: [...] <%Response.ContentType =
"application/vnd-msword"%> [...] <img src="B.ASP">
Then B.ASP contains the code: [...] <%Response.ContentType = "image/png"%>
[...] <%Response.BinaryWrite BinaryObject%> [...]
When Word opens and the document is saved, it references the images as links. I need to have these images be embedded as the file will need to be emailed outside of the network.
I can go in and manually break the links and save them as embedded files, but this process needs to be automated as users will not know how to do this.
Is there a way to force these images to be embedded instead of referenced as links when the Word doc is intially created?
View Replies
View Related
I've got a stored procedure which returns a select query on a linked server. This works fine if i call within SQL and Query Analyser but if i try and execue to return data to a ASP recordset i get the ridiculous
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Am i missing something really basic like a simple setting or is it just not possible.
Heres my ASP code: ...
View Replies
View Related
Trying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?
View Replies
View Related
How can I do this in a single query (or query-subquery)?
Return the Rows of all books in the CATALOG that...
- are tagged with one category
- are also tagged with a second category
CONTEXT:
This is a 3-table db
Many-to-many (each book may have many categories & v.v.)
- bookCatalog is the main table (with fields for each book's unique data, primary key is Ref_no)
- bookCategoriesLinkTbl is the linking table (it has two fields: category_ID and Ref_no)
- categoriesTbl has only 2 fields: category_ID and categoryName
It's an Access 97 db Code:
View Replies
View Related
I have an application that returns a PDF document to the browser (not as a
download). The document is returned in a new window. This works fine in
most installations, but I have one installation where it doesn't work in IE,
but does work in Netscape. At the installation where it doesn't work IE
returns the file download dialog box instead of just opening the file. When
I click open or save it complains that it can't find the file. I suspect
the problem is with the file name.
IE is generating a very long file and
I'm guessing it is getting confused. My code did not originally set the
file name, so I'm trying to solve the problem by setting the file name.
Here's the code that I'm using, but it doesn't seem to have any affect.
Does anyone see why this doesn't work? objHttpConn is an HTTP control that
is used to retrieve the PDF document.
PS We are hosting the web sites where it does work and were it doesn't work
and I'm testing using my PC. The only difference is the version of the
application that returns the PDF document. All the machines are 2000
servers with IE 6.0 SP1. Code:
View Replies
View Related
I have a slight problem, I'm trying to open a textfile that has been saved
as UTF-8. But when I run it it displays strange chars eventhough i've
specified that it should read the file as UTF-8 using the OpenTextFile
method of the filesystemobject. I need to open the file, then insert data to
a database, nothing will get printed out on screen so its not a html-charset
View Replies
View Related
Our ASP's stopped opening, and we gewt the error, page not found.
View Replies
View Related
I have a table called "Document" which has 3 columns
Doc_ID
Doc_Name
Doc (this is a word doc stored as an OLE object in ms access)
Now in my asp if the user selects a document it should open the word file.
I have my case statement that looks like as follows which I think might need some
modifications to open a word file: Code:
View Replies
View Related
I have a drop down on a page where user selects a value and then a excel file opens up
it works good in mozilla but in IE it doesnt open up the excel file i see a new page been open but then suddenly it closes the file
i have checked the popus in IE and i dont know what the problem is
Here is the code Code:
<%
Response.ContentType ="application/vnd.ms-excel"
getid=Trim(Request.querystring("id"))
Response.write getid
%>
I see the output written when i use mozilla but it just doesnt work in IE.
View Replies
View Related
I'd like to redirect from a certain page, to an external page(an external site), with certain parameters. of that window.
There is nothing to do if using response.redirct,
but is there another option?
For example, I would like to open a new window, that will have a cerain dimensions, and that the url of that window is... In javascript it is not a problem of course. What shall I do in asp???
View Replies
View Related
how to open port 80 so that I can access my website from other computers?I am using Xp professional.
View Replies
View Related
I have my code like this one.asp
<td><a href="callexp.asp?id=<%=rs("ID")%>" target="blank">View</a></td>
so now i call a diff page called callexp.asp ok
so it opens up a new page i want to set properties of the page like we do for pop up window.like i want the new page to be of a specific size with no scroll bars and stuff i have the code for opening a pop up window in javascript
View Replies
View Related
From a LINK or BUTTON on a webpage can we invoke the usual OPEN FILE dialog box that come with all the windows application .
In my Application I want to ASK the user the Name of a FILE on the disk ... currently i am asking the user to input the COMPLETE PATH in a TEXTBOX ....
View Replies
View Related
I need to incorporate some emails that are in a csv file, all sorted in one column, into a mySQL database.I dont find the way to open the CSV file in ADO
View Replies
View Related