Re:Again: Insert, Add Record Fails via VB6
I have tried both V184.108.40.206 & V220.127.116.11; Not V1.0.8 as stated Sorry :-(. Not
sure of exact server version but ODBC driver V1.0.8 will not work with it,
which is why I had to go back to V1.0.7.
OS is Windows XP Pro. Date/Time setting is English/Australian (dd/mm/yyyy).
Using the ADODB command object appears to work and will throw an error when
attempting to insert a duplicate record. This is correct as the table has an
index preventing duplicates. But when I Select from the table the new record
fails to appear. Am thinking it might be in a buffer somewhere but I'm not
using transactions. The method I am using works with MS SQL Server.
Any suggestions appreciated,
> Gary Naughton wrote:
>> Hi Team,
>> I've tried two approaches to add records to Nexus tables with Nx ODBC
>> 1.8 via VB6. Both fail?
> Gary, as asked before: what exact build of the ODBC driver and NexusDB
> are you using. Further if the date field is a real date field I'd to know
> which OS and the date/time locale settings.
> Hannes Danzl [NexusDB Developer]
|Thread||Thread Starter||Forum||Replies||Last Post|
|Again: Insert, Add Record Fails via VB6||Gary Naughton||nexusdb.public.support.odbc||3||2nd October 2007 10:18 PM|
|V1.07 Insert & Add Record Failure||Gary Naughton||nexusdb.public.support.odbc||0||15th September 2007 09:32 PM|
|Simple Delete Record||Michael McConville||nexusdb.public.support.adoprovider||5||24th June 2004 10:56 AM|
|ODBC driver does not retrieve the first record||Jan-Erik Johansen||nexusdb.public.support.odbc||8||22nd October 2003 02:48 AM|
|ODBQ Insert SQL Error||Vojko Cendak||nexusdb.public.support.odbc||0||17th October 2003 11:28 PM|