Search results for query: *

yep got primary keys set on the table i'm trying to update..

Has anybody been able to update a paradox 5 table using sql server, i know that you need to set up bde or jet4 to get it to work, but i can't get it to work at all... anybody know somewhere on the web where you can get instructions on how to achieve this? i've tried microsoft and borland and...

you can't specify a date format of dd/mm/yyyy for a firstdayofmonth, firstdayofmonth returns the day of the year i.e. 1st January 2001 = day no. 1, 1st Feburary 2001 = day no. 32 being 31 days in jan + 1st day in feb.. if you try and dateformat a number like 32 then it doesn't like it and gives...

I presume you are using <CFHTTP>, if you don't set the textqualifier to anything it defaults to &quot; this could be causing your problem, if you are using nothing to 'wrap' your text fields in the text file then set textqualifier=&quot;&quot; i.e. no character wrapping a text field. This may...

tried turning on RPC in/out, i think it only helps when connecting other SQL Servers so you can use their procedures remotely.. thanks though, Al

excellent! definetly learnt something there, i'm off to put default values on all my null values... :-)

Hi, I need to do update tables in a paradox 5.0 database using SQL Server 7.0, i have set up as follows: Set up and ODBC link to the Paradox Directory containing the DB files. Set up a linked server in SQL Server to the ODBC entry, using MSDASQL as the provider. I have installed MDAC 2.5(which...