Search results for query: *

Great I wanted to be sure before I made a change over to a new server. I appreciate your help guys!

I read about the SSIS project to run a DTS package and I asked the hosting company but I won't have control over the 2005 server. I am trying to execute the package to run from 2000 and insert the records into a 2005 server. Will that work?

I don't have an interface for the SQL server that will allow me to do it. I have to call them every time I want to go to simple mode and then they set it back when I am finished. The DTS is set to run every night.

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...

The database comes from a DOS based system that uses an MSAccess back end. It is export only because it draws from about 20 different databases. to create the export access db that is brought into SQL. It runs each night in the middle of the night. The reasons why we chose to rewrite vs. append...

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...

How many records are you dealing with? Have you tried to return all of the records to see if the problem lies within the querystructure or the connection/performance? For example on a test page you can write a simple query and return all results ex. rs.MaxRecords=200 sql="SELECT * FROM...

I got the server in-house (the client was 2 hours away and all configs were by phone because client could'nt get logmein to work) I started from scratch and got it to work. I don't know what caused the issue but it works now. Thanks for all of the help. I really appreciate your time in helping me.

I tried the IP address before I posted and there was no luck. I haven't put anything on the site yet but a default page to let me know I hit the site. I can get there from outside but there is no luck internally. I am inheriting this project from someone else and it looks liek I moght be better...

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 can view the website from outside the network. However, I can't see the website from within the network. Trying to use the IP address inside the network just gets a 404 error. When it resolves the IP as *.*.*.147 then while inside the network, it recognizes it as the Router and prompts for a...

When you initialize the page, does Main.asp load pickup.asp into the frame? If not when does it load? Have you tried to pass the data into the pickup page by creating session variables on the main.asp page? It will use a little more overhead but you can create variables that are equal to the...

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...

Here is the core of the code I am using. Thanks for your help. In this instance, the only input that ischanges in each record is "choicex" <form action="insert.asp" method="post" name="frmAdd" id="frmAdd"> <input name="ProdID" type="text" id="ProdID"> <input name="choice1" type="text"...

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...

It works! I decided to check my referring page and found that in the post method, I inserted the wrong encrytion type. Thanks for all of your help, you definitely steered me in the right direction with the syntax for the SQL query. Thanks

I tried it and it returns the "Sorry your code does not match a known record" message when using a known code. There are no errors. It just won't seem to recognize the data. I checked and rechecked the field names and they are correct. The data type is set to text in MS access 2003.

What field values are you trying to compare or are you trying to do a side by side comparison or......?