Hello,
I have this peculiar problem concerning MS SQL Server.
My company works with an mailing application (ASP) which uses SQL
Server as it's repository. What I want to do is send data directly
from my own application to this SQL Server in order to feed the
mailing application.
To test if this was possible I linked the tables from SQL Server in MS
Access and entered the data. This worked fine and the data was picked
up correctly by the mailing application.
The problem occurs when I send the data from my application (Java
application with JDBC connection). The data is in this case no longer
picked up by the application. The strange thing is that the data which
is entered through Access and the data from the Application look
identical in de database view. The problem also occurs when the data
is send with the tool winSQL and when I view the data in here it still
looks identical.
Even more strange is when I select the record which is not working in
Access and copy it into a new record (only changing the key) it
suddenly works!
Has anyone have an idea how this can be?
Thanks in advance,
Sander Janssen.