I created a stored procedure (sp) in my sql database. The sp accesses a table in another sql database. I ran the commands to add the linked server and add the linked login. The tests work fine within the database. Using Visual Web Developer, I'm trying to link my Sqldatasource control to this sp and I'm getting the error: "Could not find server 'xxx' in sysservers. Execute sp_AddlinkedServer to add the server to sysservers." Can you tell me how to fix this error?
View RepliesI am trying to enter an SQL string into a function for my ASP page which works fine(see below):
Datasource='<%# Getdataset("Select Player_id,Player_Forename + Player_Surname as Player_Name from tblplayer",DSplayer_ID) %>'
However what I want is to have a space between Player_Forename and Player_Surname, normally in SQL I'd just write + ' ' + but this doesn't work and neither does + " " +. I'm sure this is probably a really simple problem but does anyone know what the correct syntax is?
I Am new to ASP and I wish to create a dynamic datasource:
<%
Set test1 = Server.CreateObject("ADODB.connection")
Set DS_Path1 = Request.Form("Database_Path")
Set DS_Path2 = Request.Form("Database_Name")
DS_Path = DS_Path1&DS_Path2
test1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:cfusiondatabase est.mdb;User ID=; Password=;"
%>
I want Datasource to equal DS_Path and not c:cfusiondatabase est.mdb
If I put in Data Source=DS_Path; it doesnt work.
I need a way to extract data from an excel worksheet and write it to a table. is there a way i can tell it to only select certain parts of the sheet?i'm looking to copy the data and only the data, if you look at the attachment you will see i have an header and a legend. i don't want either.
i think i've tried this before, but i think i ran into permission problems? Can someone give me some guidence on this.
Can I use an Excel file as a datasource like using a .mdb in a .asp? If yes, how can I do that?
View Replies View RelatedIm working with a CF driven dinamic site called 'Reconquista', and the datasource it uses is a Coldfusion one.
I need to access a non-CF datasource, from another site called 'Peru', and recover some information to insert in the datasource of 'Reconquista'.
That module can't be programmed in CF, because CF (as I know in this moment) does not acess any other datasource format rather than CF's one, and the datasource Im searching for (in Perú) is a common, MSAcess-driven datasource.
I thought the module can be programmed in ASP, but I dont know how can I made a connection to the CF_Datasource of 'Reconquista' in that language.
¿Is there any form of doing that?
A way to do that would be entablishing a DSN-Less Connection in CF, but that seems impossible.
I would like to be able to control an asp text box control's name attribute.
I know i can manually type the whole string
<input type="text" name="username" value="" />
but then i can't use the validation control on the inputs. [free javascript ]
PHP Code:
can anyone please advise me how i can create multiple tabs under one page?
View Replies View RelatedI am using VBScript for ASP. The control value must be case sensitive? The following example should print the "fname" value, but if if I change "submit" back to "SUBMIT". Then it works fine.
<%
If (Request.QueryString("submit") = "submit") Then
Response.Write(Request.QueryString("fname"))
End if
%>
<form action="formtest.asp" method="get">
<P><input type="text" name="fname">
<P><input type="submit" name="submit" value="SUBMIT">
</form>
I have a select element in a form on a page with some options. When i submit thet form and the target asp page is executed, i want to find retrieve all the values in that select element on the page...?
thru request.form("sel") i am able to retrieve only the vaue selected by the user.
I am having a few problems with the Timer component in ASP.NET. I can get it to work in the C# windows application of visual studio but not in the ASP.NET.
The thing is a number of people will be logged into the website (its a game) so each person will need to view the same timer counting down to zero.
This is the code in ASP.NET. The timer only seems to be counting during page load.
How do i get it to count for a number of minutes while the game is in progress????
This is my sample code:
I need help. I don't know how to using asp paging control function to display result pages format as like as yahoo.com or google.com.
For example.
1,2,3,4,5,6,7,8,9,10 >>
<< 11,12,13,14,15,16,17,18,19,20 >>
I have C# windows control libarary (Dll), which I could able to load them
into browser using <objecttag with following syntax (In aspx page) and user
able to see the contolr properly.
<object name="chk" id="chk" classid="http:GSIM.dll#GSIM.gsimManager"></object>
I would like to load a client C# windows control libarary (Dll) instead from
webserver. (something like OCX)
So is there way I can load .NET control from client machine?? (Assum that,
the libarary exists in client machine GAC or in physical path)
My problem is my active control will download to IE6 sp2, but not download
to IE6 sp1. On IE6 sp1, ther is no popup to ask for download.
how to use grid control in asp 3.0
i am using visual interdev 6.0
when a error happen in my site, how to report it to my mail etc.?but for all error..
db,fso,string error...all and all
The login control fails password validation from both the Web site
administrator as well as from the control itself when the application
containing it is run.
The validation error message produced is: "Password length minimum: 7,
Non-alphanumeric characters required: 1."
This occurs when running the app both running in IIS and file based. What's
'odd" is it seem like a client side problem.
I have a menu control that has two Menu choices
One is "View History Items"
the second is "PDA"
My problem is as you roll the mouse over the menu options, the second
one works only if your mouse is actually over the text "PDA". Since it
is much narrower than the first item, the entire width lights up like
an active link, but the link won't work unless your exactly over the
area that has actual text. So it appears to the user who clicks too far
to the right that nothing is happening (which it isn't)
I need to create a treeview on a database management .aspx site that
when the parent is clicked, it expands to display the many associated
records with it. Aka, it pulls info from not one, but two sql server
tables. Further, these rows must be editable.
Does anyone know of any source control software (besides Visual studio) that allows a multi-user environment to be able to check out/in files and keep version control?
View Replies View RelatedMy website is on a server that places Cache-Control: private in the
Header of the pages that are served. I see these pages are not cached
by Google (the Google Toolbar Cached Snapshop of Page function).
Is this directive from my server preventing Google from caching the
pages that have it or do I need to look into some other problem?
Thanks in advance for your input/feedback.
This is a small Web Application, this contains basic XML functions using ASP including a XML driven user authentication, adding new records, viewing records, editing and deleting records. Code:
View Replies View Relatedrecently I am building a web application, i want to know what is the difference between web server control and web html control,what feachers do they provide?
View Replies View RelatedI want to write an activex control. This actiovex comntrol will be a simple drop down and when i select a value from this drop down the value in another drop down will be fill up based on this value with page refreshing.I have no idea how to develop such type of activex control.
View Replies View RelatedI’m building a intranet site and want to:
1)associate an desktop icon to a browser instance, i e, that icon opens the browser for, and only for the intranet site.
2) Once in there, unable the navigation activities, i e, unable the capability to get out of that intranet with that browser instance.
3)When called from the usual way guarantee the browser normal functionality.
I would like to create a listbox control in asp.net that has the capability of multiple columns like the Windows.Forms.ListBox control.
I have searched high and low and have only found advice such as concatenating the strings into one or using a ListView which do not seem ideal to me.
Would it be possible(and fairly easy) to create a Custom User Control, fill it with multiple listboxes and then programatically change the selected indexes of all of the ListBoxes when the selectedindex of one is changed?Custom Web Controls is another option but its apparently more complex to implement.
what the best way to insert a calendar control on my web page?
View Replies View RelatedI have a few fields that are dynamically created depending on how many contacts a person has. What I need to do is gather this data so I can save it. I am having trouble getting the data. Here is what I have so far. Which doesn't work.Code:
for i = 0 to count
SqlStr = SqlStr & "UPDATE WEB_CM_LOC SET "
SqlStr = SqlStr & "LocationName= '" & Trim(Request("LocationName" & i)) & "', "
next
When I do a response.write SqlStr nothing is returned. How do I get the value of the first textbox named LocationName?
Would anyone have an example of using the MS Calendar control (class MSCAL.Calendar.7) and ASP?
View Replies View RelatedI want to set the focus to an special Textbox when the website is selected.how can I do this.I am useing C# - ASP.NET
View Replies View RelatedWhich version control system would you recommend. Need to use it with ASP and .SQL files.
View Replies View RelatedI have included a file control in my webpage to upload files to a server. How do i initialize the control, so that when one clicks the "browse" button, it defaults to the "C:TempPictureID" folder.
View Replies View Relatedi am using asp .net 1.1 and ie6. i having problem with tabstrip control displaying pages.
i am trying to use a page with 4 tabs. for the first 2 tabs the corresponding pageviews gets loaded. but for the last 2 tabs the pageviews are not displayed. i have checked the HTML code and the code for the last two tab's pageviews were there.
i tried loading the same page in opera web browser and firefox. opera displays pageviews of all the tabs. but firefox didn't display the pageview for the 3rd tab. previously i have done a page with 5 tabs and everything works fine there. i have copied most of the code from tat page and tried to do a new one and i am encountering problems.