'RE: Sql Server replication using MyODBC as a heterogenious subscriber'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: Sql Server replication using MyODBC as a heterogenious subscriber
From:       "Peter Harvey" <peterh () mysql ! com>
Date:       2004-07-30 19:25:34
Message-ID: 200407301925.i6UJPKBk004604 () mail ! mysql ! com
[Download RAW message or body]

Not until 3.53. The 3.52 release is being replaced by 3.53. Also; UNICODE
support will not be until near the release of the production version of 3.53
- so do not expect it in the early releases of 3.53. 


Peter Harvey, Software Developer MySQL AB 
Office: +1 619 251-6923 
 
Are you MySQL certified? www.mysql.com/certification 

-----Original Message-----
From: Jeffrey Horner [mailto:jeffrey_horner@yahoo.com] 
Sent: Tuesday, July 27, 2004 2:44 PM
To: myodbc@lists.mysql.com
Subject: RE: Sql Server replication using MyODBC as a heterogenious
subscriber

Turns out I was trying to replicate a table that contained an nvarchar
column (unicode). I assume this won't be supported until MyODBC v3.52.x

Jeff
--- Peter Harvey <peterh@mysql.com> wrote:
> You may want to put this into the support stream by filing as a bug 
> (bugs.mysql.com). There it can be properly vetted. But you may want to 
> try the latest myodbc and then report any problem.
> 
> 
> Peter Harvey, Software Developer MySQL AB
> Office: +1 619 251-6923
>  
> Are you MySQL certified? www.mysql.com/certification
> 
> -----Original Message-----
> From: Jeffrey Horner [mailto:jeffrey_horner@yahoo.com]
> Sent: Monday, July 19, 2004 2:07 PM
> To: Peter Harvey; myodbc@lists.mysql.com
> Subject: RE: Sql Server replication using MyODBC as a heterogenious 
> subscriber
> 
> --- Peter Harvey <peterh@mysql.com> wrote:
> > It is quite possible that features of the driver are being queried 
> > with ODBC calls such as; SQLGetInfo() and that the results from this 
> > lead the caller to think that the driver lacks the features required 
> > to do
> the task at hand.
> > This may be true - but we may be able to correct the problem - if any.
> > Please create an ODBC trace file (see ODBC Administrator) for info 
> > on the calls made to the driver manager and try to find the calls 
> > that are failing or are causing the caller to decide to fail.
> 
> As this was a "release" version of MyODBC, the "Driver Trace Options" 
> were grayed out and I was unable to get a trace.
> 
> > Also; please try using the latest stable version of MySQL v4.0.x. 
> > This is the version MyODBC development is done with.
> 
> Funny enough, switching to MySQL v4.0.18-log on the server side 
> eliminated the Subscriber creation problem (Issue #1 from my previous 
> email). This allowed Sql Server to _replicate the entire table_ 
> without error. Pretty amazing! Oh, and I switched to MyODBC-3.51.06 which
includes a debug dll.
> 
> Unfortunately, I've run into another issue. When executing the 
> following sql
> statement:
> 
>    insert into Northwind.dbo.employees (lastname,firstname) values
>    ('Horner','Jeff');
> 
> the replication fails. Here's part of the generated trace file:
> >SQLExecDirect
> | >SQLPrepare
> | | >_myfree
> | | | enter: ptr: fb1268
> | | <_myfree
> | | >_mymalloc
> | | | enter: Size: 132
> | | | exit: ptr: fb1268
> | | <_mymalloc
> | | enter: insert into `Employees` values (11, ?, ?, NULL, NULL, NULL, 
> | | NULL,
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
> | | info : Parameter count: 2
> | | exit : SQL_SUCCESS
> | <SQLPrepare
> | >SQLExecute
> | | enter: stmt: 0x178ac0
> | | >SQLFreeStmt
> | | | enter: stmt: 0x178ac0  option: MYSQL_RESET_BUFFERS
> | | | >mysql_free_result
> | | | | enter: mysql_res: 0
> | | | <mysql_free_result
> | | | exit : SQL_SUCCESS
> | | <SQLFreeStmt
> | | >insert_params
> | | | info: pos_in_query: 00FB128C  query: 00FB1268
> | | | >add_to_buffer
> | | | | enter: from: 'insert into `Employees` values ('  length: 36
> | | | | >extend_buffer
> | | | | | enter: current_length: 0  length: 36  buffer_length: 40960
> | | | | <extend_buffer
> | | | <add_to_buffer
> | | | info: param: 0xfa9f50  ctype: 1  SqlType: -9  data: 0x15a05c
> | | | length: 6
> actual_len: 6  pos_in_query: 00FB128C
> | | | >add_to_buffer
> | | | | enter: from: 'Hornern'  length: 6
> | | | | >extend_buffer
> | | | | | enter: current_length: 36  length: 6  buffer_length: 40960
> | | | | <extend_buffer
> | | | <add_to_buffer
> | | | info: pos_in_query: 00FB128F  query: 00FB128D
> | | | >add_to_buffer
> | | | | enter: from: ', ?, NULL, NULL, NULL, NULL, NUL'  length: 2
> | | | | >extend_buffer
> | | | | | enter: current_length: 42  length: 2  buffer_length: 40960
> | | | | <extend_buffer
> | | | <add_to_buffer
> | | | info: param: 0xfa9f78  ctype: 1  SqlType: -9  data: 0x15a072
> | | | length: 4
> actual_len: 4  pos_in_query: 00FB128F
> | | | >add_to_buffer
> | | | | enter: from: 'Jefff'  length: 4
> | | | | >extend_buffer
> | | | | | enter: current_length: 44  length: 4  buffer_length: 40960
> | | | | <extend_buffer
> | | | <add_to_buffer
> | | | >add_to_buffer
> | | | | enter: from: ', NULL, NULL, NULL, NULL, NULL, '  length: 92
> | | | | >extend_buffer
> | | | | | enter: current_length: 48  length: 92  buffer_length: 40960
> | | | | <extend_buffer
> | | | <add_to_buffer
> | | | >_mymalloc
> | | | | enter: Size: 140
> | | | | exit: ptr: fb2f58
> | | | <_mymalloc
> | | <insert_params
> | | >do_query
> | | | >mysql_real_query
> | | | | enter: handle: 1778b4
> | | | | query: Query = "insert into `Employees` values (11, Horner, 
> | | | | Jeff, NULL,
> 
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 
> NULL, NULL, NULL)"
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >vio_blocking
> | | | | | enter: set_blocking_mode: 0
> | | | | <vio_blocking
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >net_flush
> | | | | | >vio_is_blocking
> | | | | | | exit: 1
> | | | | | <vio_is_blocking
> | | | | | >net_real_write
> | | | | | | >vio_write
> | | | | | | | enter: sd=552  size=144
> | | | | | | | exit: 144
> | | | | | | <vio_write
> | | | | | <net_real_write
> | | | | <net_flush
> | | | <mysql_real_query
> | | | >mysql_read_query_result
> | | | | >vio_is_blocking
> | | | | | exit: 1
> | | | | <vio_is_blocking
> | | | | >vio_read
> | | | | | enter: sd=552  size=4
> | | | | | exit: 4
> | | | | <vio_read
> | | | | >vio_read
> | | | | | enter: sd=552  size=42
> | | | | | exit: 42
> | | | | <vio_read
> | | | | error: Got error: 1054 (Unknown column 'Horner' in 'field 
> | | | | list')
> | | | <mysql_read_query_result
> | | | >set_stmt_error
> | | | | error: message: Unknown column 'Horner' in 'field list'
> | | | | exit : SQL_ERROR
> | | | <set_stmt_error
> | | | >_myfree
> | | | | enter: ptr: fb2f58
> | | | <_myfree
> | | | exit : SQL_ERROR
> | | <do_query
> | | exit : SQL_ERROR
> | <SQLExecute
> | exit : SQL_ERROR
> <SQLExecDirect
> 
> It seems that expanding ? in the prepared statement is the issue. I've 
> searched extensively on the archives and cannot find any mention of an 
> option that handles this... So where do I go from here?
> 
> Jeff
> 
> 
> =====
> J. Horner Software
> www.jhorner.com
> 615-347-6899
> 
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:    http://lists.mysql.com/myodbc?unsub=peterh@mysql.com
> 
> 


=====
J. Horner Software
www.jhorner.com
615-347-6899

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=peterh@mysql.com


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic