[fdo-users] ODBC MS SQL Server error feature on check in after editing

[Jackie Ng]

Hmmm, it could be something on the ODBC side. The SQL Server provider *does
not* use the SQL Server Native Client ODBC Driver, which may have something
to do with it.

The FDO that comes with map is not the same as the one from the open source
release. They are the same on an API level, the map one has some BulkCopy
APIs on top. I wouldn't read too much into the minor version number.

- Jackie


kalmy wrote:
> 
> No, I use Express edition of SQL Server and I think the Profiler is not
> availabel. The screenshot is from Management Studio Express  2008, I use
> 2000 MSDE  and 2008 Express database structure.
> 
> but ... I think I discover the issue, I change the type of field from
> numeric(18,3) with real for X,Y columns and works but it's strange and I
> don't  why ? Is this a limitation of ODBC provider ?
> 
> Also I noticed the FDO version of odbc is 3.4.0.5301 in map folder and
> from toolbox is 3.4.0.56 .The newer is better ?
> 
> 
> Kalmy
> 
> 
> 
> 
> Jackie Ng wrote:
>> 
>> From your screenshot, I assume you're not using the express edition of
>> SQL Server.
>> 
>> In that case, there should be a SQL Server Profiler installed. Run it and
>> configure it to watch for T-SQL statements. Run your FDO insert command
>> again and see what SQL is being fed to SQL Server.
>> 
>> - Jackie
>> 
>> 
>> kalmy wrote:
>>> 
>>> Can you tell me where/how can I turn on the tracing ?
>>> 
>>> Kalmy
>>> 
>>> 
>> 
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/ODBC-MS-SQL-Server-error-feature-on-check-in-after-editing-tp4108036p4163763.html
Sent from the FDO Users mailing list archive at Nabble.com.