odbc-sql-server-driver


ODBC data transfer to SQL server


How does the ODBC driver transfer data between an application to MSSQL Server 2005?
Is it serialized?
I'm trying to send data between SQL Server 2005 & MS Dynamics 4.0 but I suspect my data is altered by the ODBC driver in between.
Its sent as a wide-character string to SQL server -- i.e., a SQL query batch. No transformation needs to take place. The return data is structured in a protocol called TDS.
I believe if you are using the ASCII functions of the ODBC native client it gets upscalled to wide-character.
Look at the date formats on the 2 servers, you may have issues with localisation/regional settings

Related Links

ODBC data transfer to SQL server

Categories

HOME
dotnetrdf
cil
tomcat7
codeeffects
checksum
data-science-experience
shader
structuremap
uiactivityviewcontroller
netezza
alfresco-share
quartus
movies
internet-explorer-8
kadanes-algorithm
jquery-form-validator
os161
avplayeritem
fabric
scalajs-react
python-textprocessing
maximo
image-quality
unpack
metadata-extractor
dss
cgal
bitcoin-testnet
xor
crt
phpspreadsheet
superpowered
passenger
css-counter
poco-libraries
visualstudio.testtools
brute-force
nsexception
constants
dojox.mobile
tuleap
gd
amazon-machine-learning
ti-basic
persistent
crash-reports
photography
sql-server-administration
android-navigationview
backstop.js
pydio
visible
zurb-foundation-apps
linkageerror
asteriskami
codesign
django-south
qt-linguist
git-rebase
schtasks.exe
rad
programming-paradigms
stream-framework
playscape
graphical-logo
custom-url
line-numbers
surrogate-key
cppdepend
wss
joox
help-viewer
logentries
nservicebus4
vmware-server
ienumerator
dynamics-ax-2009
vertical-scrolling
ubuntu-11.10
web-safe-fonts
continuous-testing
selectmanycheckbox
serp
authenticode
dcpu-16
ets
dashcode
chatroom
revert
google-instant
microsoft.ink
usergroups
divx

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App