Search results for query: *

I've written an ASP.net 2.0 app that allows users to run crystal reports. The site works flawlessly on my dev server but when I publish it on the prod server, the crystal report viewer bar does not load. Instead I get "Submit query" label for all the crystal buttons (print, export, last page...

I get an error when I attempt to connect to SQL Express using VB.net. I am attempting to use a System DSN previously created using the ODBC Data Source Administrator. The DSN was tested using MS Access by linking the tables. (Inserts... Updates and etc. all working) The code that fails is when I...

I have a small .Net 2.0 app. that allows users to upload images and input text to an HTML editor. This site works perfectly when I run it from VS.Net. However when I publish it to IIS, the images appear as white boxes with a red square. I have tried messing with the security settings of the...

Hi everyone, I'm new to DTS. I've gone through a lot of posts in this forum but so far I have not found any post that informs about importing any excel file (any random name) to a SQL table. In my case, the column names in the excel file are consistent, but the actual file name could be...

Hello everyone, I have a particular table that is the heart of our applications. As a result most of the select statements, stored procedures and views involve this table. We have indexed it adequately. All the procs on this table seem to be running fine except for a Delete procedure that...

Hi friends, I am having some MAJOR issues accessing an MSDE server from a client machine. When I try to setup an ODBC pointing to the MSDE, I get the following error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied The client machine has firewall...

Hi everyone, I have a form that has an ActiveX control on it that allows users to format text and stored the text in a memo field in html format. So when you look at this control, it has the HTML rendered. However when I print this form, all the controls print with values in them but the activex...

Hi everyone, I have a wierd report to build and very little time to do it. Here's the situation: The data for the report is drawn from two tables: Checks and CheckLines. Checks table has Checknumber, CheckDate and CheckAmount. Check lines has Checknumber, Linenumber, OrderNumber, OrderDate and...

Hello everyone, I am trying to deploy an access app. on a Win 2K3 server. The plan is to deposit the mdb and mdw files in a folder on the server. I have created a batch file for each user that starts up the application using the following command: Start "D:\Program Files\Office11\MSAccess.exe"...

Hi everyone, Our machine with MSDE on it crashed today. We urgently need to restore one database from that machine. We have been able to extract .MDF and .LDF files for that database from the machine but there are no backup files (most probably, no backups were taken in near past). I tried to...

Hi everyone, I am outputting the contents of a recordset to a text file. This file is later used by another program to import this text. However, everytime I output the text, each recordset field that I output has double quotes("") around them. This messes up the tags that I am outputting...

Hi folks, I need to have users enter credit card numbers in a text field but only the last four digits should show.... the rest should be masked by "*". Can this be done easily? Also, can we also apply this mask to the table column where this info is stored? Thanks in advance for all the help.