mORMot Open Source

hkcity1111

Member

Registered: 2014-08-18

Posts: 14

Question using TOleDBMSSQLConnectionProperties in Window 2008 Server

Hi all

I am using Delphi XE and compile into exe or service and install into window 2008 64 bit server
I got the following some error about "Class not registered" in log using TOleDBMSSQLConnectionProperties
I try to create udl with "Microsoft OLE DB Provider for SQL Server" to test connection without problem
I use window 7 32 bit without any problem.
Is it related to 32 bit driver?

Do anyone encounter this problem and any suggested solution/further checking?
Thanks a lot!

TOleDBConnection(0208A140).00639B42 
	EOleSysError 80040154 ("Class not registered") at 00592DE9  stack trace 0063EABC 0040495A 00407820 00407A83 00586D7F 0058A068 770A33B5 770A3322 770A3337 766674A8 778F3CD3 778F2CAF 778F3CD3 00406398 00406398 00587D10 0056520E 00565360 00568467 00404976 
	"EOleSysError(020F9278)":"Class not registered" stack trace API 00511FEC 00639CC1 0063EABC 00586D7F 
	EOleSysError 80040154 ("Class not registered") at 00592DE9  stack trace 0040495A 00407820 00407A83 00586D7F 0058A068 770A33B5 770A3322 770A3337 766674A8 778F3CD3 778F2CAF 778F3CD3 00406398 00406398 00587D10 0056520E 00565360 00568467 00404976 004078BD 

Regards,
  Kenneth

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Question using TOleDBMSSQLConnectionProperties in Window 2008 Server

Are you able to connect with SynDbExplorer?

Where is the exception raised?

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,571

Website

Re: Question using TOleDBMSSQLConnectionProperties in Window 2008 Server

For MS SQL use is better to install SQLNCLI11. In case odbcad32.exe (on the Drivers tab) do not show SQLNCLI11 exist - install Native Client Microsoft® SQL Server® 2012

hkcity1111

Member

Registered: 2014-08-18

Posts: 14

Re: Question using TOleDBMSSQLConnectionProperties in Window 2008 Server

thanks, this come from driver issue and no problem after installation

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Question using TOleDBMSSQLConnectionProperties in Window 2008 Server

I've updated the documentation to be more clear about this point.
See http://synopse.info/fossil/info/0973e6a83c

Thanks for the feedback!