Search results for query: *

I created an ODBC driver using the "Microsoft Visual FoxPro Driver (*.dbf)", setting database type to "Free Table" and pointing to the directory containing the tables. I then link the tables using an ODBC connection, selecting the table and specifying the update key. Using the ODBC method, the...

Unfortunately the application they are linking to are 2.6 for windows. I do not know how to make them a DBase version IV or higher without crashing the owner application. Is there a way to install an older version of the jet engine, or a different way to access the FoxPro 2.6 tables I am not...

An application was written a few years ago to link to various FoxPro 2.6 tables. It linked to these tables and then used a query to pull the information for various reports. Corporate wants everyone on Access 2k or better for support. We have one machine which has Access 97 just so it can...

Here in the US we have a number of appliance vendors as well but based on price they seem to be looking at enterprise solutions with a need for many VPN tunnels. I was thinking that I may be able to accomplish the same thing using the relatively cheap Cisco/Linksys VPN routers since I have a...

I have a remote office wich currently has one XP Pro machine (soon to be 3). At the main office I have a server running Windows SBS 2003 with ISA. Both locations have a braodband connection to the internet. I would like to connect the remote site to the main office as though we had a long...

Using a stored procedure how do I copy stored procedures from one database to another? This would be done weekly and so an automated way is what I am looking for. I would also have to drop them from the target database if appropriate. TIA Mark

Thanx both donutman and sqlsister. Just an FYI, I abandoned the linked server idea. It had too many unpredictable problems and my procedures were breaking too often. I also had little control over many of the items that were causing performance and connection problems. The solution I tried...

Thank you sqlsister/donutman for working with me on this. I agree that the linked server solution is giving me more problems than it is worth. The text based solution worked but kept breaking due to special characters in the text files. Special characters were mainly a problem in a notes...

Off hours is when it will run on a regular basis. At night I run into other things that are out of my control like backups over the network... I am reading the FAQ about using "Batch Size" which may help to split the job up. I don't know if it will make any difference because I think it is a...

Thanx for your response. See the answers burried in your questions. >You are absolutely sure you can connect to the linked >server? Yes, if I use EM I can see the linked server, tables and browse the tables. >Have you tried sending smaller batches? Yes, a batch of 300 records goes through...

Here is the relevant code. DELETE t_remote FROM LinkedServer.Database.dbo.WEB_FROI t_remote WHERE EXISTS (SELECT fr_pk FROM web_froi t_local WHERE t_local.fr_pk = t_remote.fr_pk) INSERT INTO LinkedServer.Database.dbo.WEB_FROI ( Field1, Field2... ) SELECT Field1...

I have a web server which needs to get a snapshot of data overnight. On the local machine I have stored procedures which create tables containing changes with a flag indicating that it is an (A)dd, (C)hange, (D)elete or (L)oad. The selection and creation of the change tables takes just minutes...

Thanx DonutMan... Both solutions work actually. The problem turned out that the local web_eob table was empty. I should have checked that before issuing the delete or the subsequent insert statements.

What is wrong with the following delete statement? I am trying to delete rows from a table on a linked server that exist in a table of the same name on the local server. The following is from query analyzer. DELETE t_remote FROM SERVER.DATABASE.dbo.WEB_EOB t_remote WHERE EXISTS (SELECT...

As you can see I solved my problem by not using an intermediate calculated field which somewhat supports your reasoning. The hitch is that if I go to the define screen sorted in define sequence, the field calculation should have worked, if done in a top down sequence. I can't seem to see the...

Thanx again NCH, now on to the task of building the procedures.... ;-)

Thanx NCH, I added the owner as follows and all worked as needed. exec MXW4.CMSTEST.dbo.sp_diaryalerts If the stored procedure references a table named 'XYZ' without using the [server.database] qualifier, which is defined to the local database and the linked database, which table will be...

I am having no luck in executing a stored procedure on a linked server. Is this possible? I am trying the following in SQL Query Analyzer. exec MXW4.CMSTEST.sp_diaryalerts -------------------------------------- Server: Msg 911, Level 16, State 1, Line 1 Could not locate entry in...

This is FM 3 actually

I inherited an application which is failing to calculate correctly. I have a table defined as follows: o_labor number (manually entered at data entry) e_labor calculation (number) =sum(extra_labor) d_labor calculation (number) =sum(deduct_labor) r_labor calculation (number) =o_labor + e_labor...