Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Date null



Permlink Replies: 4 - Last Post: Apr 28, 2015 12:26 PM Last Post By: Sebastian Kumor
Sebastian Kumor

Posts: 22
Registered: 10/19/11
Date null
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 15, 2015 11:19 PM
I have DateTime column in mssql database.
This field is most likely null. I get this
fi.DATA_EKSPORTU:=dane.SQLtmp.Fields[68].AsDateTime;


On most computers taht instrctions works fine, but I have one computer, where every instructions like that don't work

I get ''''' is nod valid DateTime.

This is strange, maybe I need somethnig to change in windows ? (Win 8)

Edited by: Sebastian Kumor on Feb 15, 2015 11:19 PM
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Date null
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 17, 2015 11:19 PM   in response to: Sebastian Kumor in response to: Sebastian Kumor
Compare FireDAC environment reports on two computers - one where app is working
and one where it is not. And see which SQL Server ODBC driver FireDAC loads on
one and another computer.
http://docwiki.embarcadero.com/RADStudio/XE7/en/DBMS_Environment_Reports_(FireDAC)

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Sebastian Kumor

Posts: 22
Registered: 10/19/11
Re: Date null
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 23, 2015 4:15 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Compare FireDAC environment reports on two computers - one where app is working
and one where it is not. And see which SQL Server ODBC driver FireDAC loads on
one and another computer.
http://docwiki.embarcadero.com/RADStudio/XE7/en/DBMS_Environment_Reports_(FireDAC)

--
With best regards,
Dmitry Arefiev / FireDAC Architect

My app works well on computers where SQL Server have been installed.
I have this bug on every computer without SQL Server.
I think I should attach some .dll files on clients computers ?
If yes, which one
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Date null
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 23, 2015 4:42 AM   in response to: Sebastian Kumor in response to: Sebastian Kumor
SQL Server Native Client:
http://docwiki.embarcadero.com/RADStudio/XE8/en/Connect_to_Microsoft_SQL_Server_(FireDAC)

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Sebastian Kumor

Posts: 22
Registered: 10/19/11
Re: Date null
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 28, 2015 12:26 PM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
SQL Server Native Client:
http://docwiki.embarcadero.com/RADStudio/XE8/en/Connect_to_Microsoft_SQL_Server_(FireDAC)

--
With best regards,
Dmitry Arefiev / FireDAC Architect

Thank you.
That's exactly what I needed
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02