Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: xe7 bdx failed ti initialize accessing MSSQL in IDE


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 3 - Last Post: Dec 14, 2015 8:51 AM Last Post By: dwight crevelt Threads: [ Previous | Next ]
dwight crevelt

Posts: 3
Registered: 2/26/08
xe7 bdx failed ti initialize accessing MSSQL in IDE  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 13, 2015 11:31 AM
I am migrating a xe2 MYSQL iw stand alone server app to xe7 and MSSQL

Created a new MSSQL CONNECTION IN IDE called xxxxserver
I can access MSSQL files in the IDE data explorer just fine in xxxxserver

When executing the iw server IN THE IDE - it comes up fine but when access to the MSSQL is tried I get
using xxxxserver in the sqlconnection component

'DBX Error: Driver could not be properly initialized. Client library
may be missing, not installed properly, of the wrong version, or the
driver may be missing from the system path

MSSQL 2008 R2, WIN 7 64 bit,
following are in the system directories
sqincli10.DLL 32 and 64 bit present
dbxmss.dll 32 and 64 bit present
dbxmss9.dll 32 and 64 bit present
quinn wildman

Posts: 856
Registered: 12/2/99
Re: xe7 bdx failed ti initialize accessing MSSQL in IDE  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 14, 2015 8:35 AM   in response to: dwight crevelt in response to: dwight crevelt
http://support.embarcadero.com/article/41796

dwight crevelt wrote:
Client library
may be missing, not installed properly, of the wrong version, or the
driver may be missing from the system path
dwight crevelt

Posts: 3
Registered: 2/26/08
Re: xe7 bdx failed ti initialize accessing MSSQL in IDE  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 14, 2015 8:50 AM   in response to: quinn wildman in response to: quinn wildman
quinn wildman wrote:
http://support.embarcadero.com/article/41796

dwight crevelt wrote:
Client library
may be missing, not installed properly, of the wrong version, or the
driver may be missing from the system path

That article is worthless - everything is installed correctly

As it turns out the MSSQL driver is the problem - it needs coinitialize and uncoinitiailze to be called to function properly
also MSSQL is picky about several Fieldnames that Mysql and others aren't.

just one more reason to avoid microsoft products whenever possible
dwight crevelt

Posts: 3
Registered: 2/26/08
Re: xe7 bdx failed ti initialize accessing MSSQL in IDE  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 14, 2015 8:51 AM   in response to: dwight crevelt in response to: dwight crevelt
posted solution in reply
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02