I have a DTS running on a local server. It converts an mdb to SQL by droppping all tables, recreating them and loading the data. I load these tables onto a SQL2000 hosting server for a website.
I have about 250MB of data in the mdb and it peaks the transaction file on my hosting server at...
I have created a DTS package. It uses a local db to execute from and a remote SQL web server configured in enterprise to write to. If I am logged in to both servers (Local & web SQL) then it completes without a hitch.
It seems like it is not logging in to the web SQL properly before attempting...
I have a question about updating from a lookup in a DTS Package.
I have a DTS that populates a table by moving about 12k records from the exact table structure in another database. Between DTS updates, some of the records in the table may be updated by users. I have a lookup where I have...
I already posted in the General PC Hardware forum and was told that I may want to post in another forum . This forum seems more appropriate.
I am a programmer without a ton of Server config experience.
I have a customer with a website that is online with a public IP address *.*.*.147
I am...
I have a customer with a website that is online with a public IP address *.*.*.147
I am using a Dynamic DNS service that resolves the Domain name to the Public IP address (*.*.*.147).
The public IP address (*.*.*.147)is a router that forwards the visitor to a web server within the network to...
We had a laptop come in for repair (HP ze5170) and the HD was failing (a few bad sectors). We ghosted the drive and it won't boot from the ghost.
We checked the ghost and it was good but we re-ghosted anyway ( we do 10-20 ghosts a day in-house). We thought for some reason the replacement HD...
Hello, I have a question. I have a form that needs to insert several records. Many of the values repeat but only a couple change.
ex:
dataA | dataB | dataC | dataD1
dataA | dataB | dataC1 | dataD1
dataA | dataB | dataC2 | dataD2
dataA | dataB | dataC3 | dataD2
How do I go about repeating...
I keep getting errors and I know it's probably something basic that I am overlooking.
I am passing a variable from a form. I have tested the variable and it works.
This code is intended to check for a code in the database that matches the request form variable.
If not...
I have a customer who has a small LAN network of all Dell/Dimension desktop computers running Windows XP Pro. They all have Intel video chipsets. The computers all seem to sporadically change bit depth and resolution to (4 bit).
There are no programs running that require 4 bit and no events...
I am running enterprise manager and connecting to a remote server. I need to set up an automated import of a local Access db into the remotely connected SQL database.
I would prefer to append the tables vs. overwrite for at least one of the tables.
What is the best method? I need to run the...
I am hoping that one (or more) of you can help me with my approach to the following task:
*Allow users to order product samples online*
1)I have about 150 product records that are returned in a paged recordset. Each record is unique.
2)Have a checkbox available for each product record so that...
I am trying to add a computer running Windows XP Media 2002 to an existing domain. The option for domain info is grayed out. I checked to see if it was able to be added to a domain and not just workgroups. I know it has the option available in this version (not 2005 version)but i can't figure...
It's been a while since I have done this so I am a little rusty. Please forgive me.
I have a recordset that returns recordsets properly. One of the fields is a (money) field in the SQL db.
My task:
example: If the money field returns 10 records I need to display all records and then SUM all...
The purpose of my code is to allow a user to navigate to a (Folderview)folder, select "Upload" from a side menu and then allow them to upload a 10MB +/- to that folder. I set out to capture the path of the folder the user is in and then proceeded to send it to a second page where the user can...
I am copying a new folder from a master and I need to rename it based on a variable passed from a form. I have checked and I am passing the variable just fine. I am also able to create the folder just fine using fso.copyfolder. I can only copy it to predetermined name so......
1) Can I create a...
Hello,
I know this is not the correct forum but it's the closest I could find.
We have installed SQL 7.0 to a MS Terminal Server 2003. We can access everything from the Server and can access the Enterprise Manager from the Workstations but we cannot view the data, create tables, etc. it gives...
I wanted to know if anyone here knows a way to make the polygonal lasso tool remove an anchor point.
I clean a lot of images and sometimes it will loop back losing all of the lassoing I just did. Sometimes if I get in a hurry I will accidentaly click in te wrong spot and I just need to back...
Hi guys,
If you have addressed this topic, please forgive me. I didn't have time to read through. I have been fighting viruses on this hybrid network (28 clients 3 servers/ servers are NT 4.0 & clients are XP Pro and 2K Pro) There are problems getting mail and going to certain internet sites I...
Hi guys..I have a very perplexing situation that I just can't figure out. I am needing some fresh perspectives.
A customer's network setup is an NT Server with XP Pro workstations.
The server is a DHCP server for the network.
Their network's internet access has been ISDN and they have 3 remote...
Hi guys,
I have Office 2000 premium (All patches)on WinME and it closes when any file is opened. It happens whether you dbl click the file or open through file menu. I have repaired Office and done a virus scan. I found Badtrans(B) and I have removed it and modified the registry but as far as I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.