#1  
Old 26th September 2007, 07:11 PM
Gary Naughton
 
Posts: n/a
Default Re:Again: Insert, Add Record Fails via VB6

Hi Hannes,
I have tried both V1.0.7.0 & V1.0.7.3; 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.


> Gary Naughton wrote:
>
>> Hi Team,
>>
>> I've tried two approaches to add records to Nexus tables with Nx ODBC
>> driver
>> 1.8 via VB6. Both fail?

>
> Gary, as asked before: what exact build of the ODBC driver and NexusDB
> Server
> 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 Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +11. The time now is 09:39 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.