Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dand11
  • Content: Threads
  • Order by date
  1. dand11

    Need to create a dll for website

    I have a website which was originally developed in asp.net 1.0. It consumes webservices written in 2.0. I had to make a change to the 1.0 website and I'm using VS 2005. I understand that ASP.NET 2.0 doesn't create dlls. Is there a way to create the website dll in VS 2005?
  2. dand11

    IIS: installing client and webservice

    I have been asked to install a copy of a client web site and web service on another machine. I have copied the files over and created the virtual directories. My question is: Do I need to change the XML namespace for the webservice? Is there any other things I need to do that I haven't mentioned?
  3. dand11

    SoapException

    I have a web app that uses a webservice. It has been running fine for a month until today. I'm new to ASP.NET and webservices. I did copy the dll from another site that was working and pasted it into the bin folder of the site thats getting the error. Here is the error I'm getting. I apologize...
  4. dand11

    Delete records from datatable where column value between...

    I have a datatable where I need to delete records from it where the primary key is between say 1 and 10. How can I go about doing this efficiently?
  5. dand11

    Possible to execute several SQL Statements at one time with MYSQL?

    I need to be able to run the following SQL Statements at the same time from an ASP.NET application. The query is built on the fly and passed to the MYSQL Database. When I execute each individually in MYSQL Query Browser it runs fine but when I try the web app I get an error: The Error: Event...
  6. dand11

    Select into temp table

    Is it possible to create a temp table on the fly as with the following SQL Server TSQL Script? Select 'Some value' as Col1 into #temp from myTable where primkey > 0 ALTER TABLE #temp ADD RowNum IDENTITY(1,1)
  7. dand11

    Setting the connx string of an SQL Connection

    I am setting the connection string as follows but I'm getting an error that states "The ConnectionString property has not been initialized." I used the command window in VS2005 and found out that "ConfigurationManager.AppSettings["ConnxString"]" is returning a null value. I set it in my...
  8. dand11

    Where Clause Problem

    I have the following select query but its returning everything and not filtering on the where clause: declare @Article char(30); set @Article := 'CLOTHING/FUR'; SELECT 'OFFENSE' AS TblSource, P_date as entered_date , CONVERT(CN, CHAR(10)) AS REFNUM , '' AS...
  9. dand11

    SQL Server ISNULL() equivalent

    What is the MySQL equivalent to SQL Server's IsNull(Field,'')
  10. dand11

    Counting files in a directory

    I am altering an application to fit with a clients specs. There are jpegs being held in a directory, I'll call C:\images. The format of the names of these are F######_000.jpg (The ######) are a unique ID numbers and the _000 portion is for the first image and the second image if there is one...
  11. dand11

    Using LIKE clause inside OPENQUERY

    I'm trying to query a Linked server and need to use the LIKE clause. I'm using the following but I' getting an error that states: OLE DB provider "Advantage.OLEDB" for linked server "CODE3" returned message "Error 7200: AQE Error: State = 42000; NativeError = 2115; [Extended...
  12. dand11

    Subquery in where clause returning more than 1 row

    My subquery in the where clause is returning more than one record. I'm trying to parse out the first name out of a field that has both the first and last name in the field called "FULLNAME". Select 0, m.LINK from MNAMES m Left Join GEOBASE g on g.LINK = m.LINK Left Join PHONES p on...
  13. dand11

    DLL not saving changes

    I have a DLL from a code written in C#. I have added some comments to the error log. I noticed that when I build the dll the changes aren't reflected in the Event Viewer. I have had to end the aspnet_wp.exe process a few times. Is there a way to get everything back to normal?
  14. dand11

    Query to Advantage DB is timing out

    I have an Advantage (yeah right) db that I'm trying to connect and query to but when I run it just times out. Below is my connection string in case I'm doing it wrong: Any help would be deeply appreciated. <add name="spDB" connectionString="Data Source=C:\\temp\\CCSODATA\\; Advantage Server...
  15. dand11

    Placing an image in database

    I would like to set up an asp.net 2.0 web app to insert images into a SQL Server 2005 database. I'm hosting on godaddy shared hosting and they block the use of file streams for security purposes. Is there another way to get the images uploaded? I'd prefer to have them in the database so I could...
  16. dand11

    Need a connx String for Advantage file system database

    I have downloaded an advantage database on my c\temp\ccsodata directory. Its pretty much just the DBF,CDX,and FPT files. I used Advantage data architect to test my queries. I have the connection properties in Advantage data architect set as such: ConnectionPath: C:\temp\CCSODATA TableType: cdx...
  17. dand11

    Looking for a more concise query

    I have a form which is used for searching for records in the database. There is no gaurantee which fields will be filled in on the form when the search commences. Right now I have the query set up to join tables and return all rows to a temp table then I have a conditional for each field to test...
  18. dand11

    Newbie Q: Trying to debug a handheld app

    I'm trying to run a hanheld app in visual studio 2005. I have set the drop down to "Pocket PC 2003 SE Square Emulator" but when I click on Debug/Start Debugging I get the following error: The operation could not be completed. The device is not connected. What am I missing?
  19. dand11

    How to remove script code

    I am retrieveing data from a Pervasive database and the data is being preceded by some sort of scripting code which looks like this: rtf1\ansi\ansicpg1252\uc0\deff0{\fonttbl {\f0\froman\fcharset0\fprq2 Times New Roman;} {\f1\froman\fcharset2\fprq2 Symbol;}}...
  20. dand11

    Newbie Question

    I have a query that is returning some data with some code concatenated in front as such: rtf1\ansi\ansicpg1252\uc0\deff0{\fonttbl {\f0\froman\fcharset0\fprq2 Times New Roman;} {\f1\froman\fcharset2\fprq2 Symbol;}} {\colortbl;\red1\green0\blue0;\red255\green255\blue255;} {\*\generator TX_RTF32...

Part and Inventory Search

Back
Top