Search results for query: *

When I setup an ODBC connection on a client machine and I get to the question "Which SQL server do you want to connect to?" I have two servers with the same name to choose from but neither of them work right now. I know that we used to have SQL 7.0 but I was not involve with the upgrade so I was...

I'm hoping someone can throw some suggestions my way. Here's my problem: I have an access subform with text boxes bound to fields returned in a query based on an order detail table. The Subform is being populated based on choices the user selects from 3 separate list boxes (as each list box...

I'm hoping that someone has some ideas as to what is going on with my text box. I have an app that has several screens with text boxes that display date data. The value in the Default Value Property is: =DateAdd("d", 1, Date()) This has been fine for the longest time and is currently...

I'm hoping that someone can help me out. I have a DTS package that runs fine as a package but fails once scheduled. The package uses a Transform Data Task to move data from a table into a text file on a mapped drive. The drive is mapped as the U: Drive. When I manually run the package, it...

I'm hoping someone can point me in the correct direction. I need to move the primary transaction log file for each of several databases from one drive to another (basically from the E: drive to the D: drive). What are each of the steps that I need to go through to do this successfully without...

I have a DTS package that I am creating that will be running every 10 minutes to dump data into a file that will then be picked up by another application. This other application needs to look for the exact same file name each time it does its import. Once the other application accesses this...

I am hoping someone can possibly help me out. I have a linked server created that uses a Transoft ODBC Driver. I am able to run a select query against this linked server via Query Analyzer. However, when I attempt to run the following update query: Update OPENQUERY(Unibol, 'Select * From...

I have a text box that is bound to a date value in a table. The field within the table is set to not except null values. The field is used to record the start time of a process. The default value in this field is 1/1/1900 12:00 PM. This indicates that the process has not yet begun. When...

I am trying to update a grid control (refresh with a new data source) on one form after saving some values to the database via another form. The main form that contains the grid control remains open while the second form is opened, data is entered and saved to the database. Once the data is...