I have a legacy ms access database that I was wanting to use with dbExpress and odbc rather than dbGo (ado). Was thinking that it might also be possible to cross compile to osx with a FireMonkey app.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you saying that XE2 odbc dbexpress can talk to ms access directly without a LibraryName set, I was thinking it would need the the dbxooodbc.dll to work on XE2 ?
After looking at the dbx_access_connect.pas file that I got going in a C++ XE project I see it is using the odbcjt32.dll vendor lib, so to get this going under XE2 and osx one would also need a compatible odbc ms access dll. As far as I know MS doesn't support os x so probably a no go.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
do you have any plans to support XE2 ?
XE2 now has its own driver odbc express. I'm still lost in thought on your question. Is there a need? I think …
yes I should have explained further.
I have a legacy ms access database that I was wanting to use with dbExpress and odbc rather than dbGo (ado). Was thinking that it might also be possible to cross compile to osx with a FireMonkey app.
embarcadero odbx dbXpress driver supports osx
Are you saying that XE2 odbc dbexpress can talk to ms access directly without a LibraryName set, I was thinking it would need the the dbxooodbc.dll to work on XE2 ?
After looking at the dbx_access_connect.pas file that I got going in a C++ XE project I see it is using the odbcjt32.dll vendor lib, so to get this going under XE2 and osx one would also need a compatible odbc ms access dll. As far as I know MS doesn't support os x so probably a no go.
XE2 ODBC DBExpress driver is available in the fullness of "$ (DELPHI) \ sources". It does not use external dbxpress dll.
Mac ODBC: MS Access connectivity for Mac OS X by Actual Technologies
http://www.actualtech.com/product_access.php
Thanks for your help and info, I hadn't noticed that the sources were there.
I had just before your post come across the actualtech one and one by OpenLink, I haven't investigated that aspect any further at this stage.
In terms of using XE2 and dbExpress via TSQLConnection can you point me in the direction of how this can be setup to access a MS Access MDB ?
I haven't come across any documentation in regard to this. What would the dbxdrivers.ini look like e.g. LibraryName and GetDriverFunc ?
Thanks again for any help.
XE2
"C:\Users\Public\Documents\RAD Studio\dbExpress\9.0\dbxdrivers.ini"
Odbc=1
DriverUnit=Data.DBXOdbc
DriverPackageLoader=TDBXOdbcDriverLoader,DBXOdbcDriver160.bpl
DriverAssemblyLoader=Borland.Data.TDBXOdbcDriverLoader,Borland.Data.DbxOdbcDriver,Version=16.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
MetaDataPackageLoader=TDBXOdbcMetaDataCommandFactory,DbxOdbcDriver160.bpl
MetaDataAssemblyLoader=Borland.Data.TDBXOdbcMetaDataCommandFactory,Borland.Data.DbxOdbcDriver,Version=16.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
"C:\Users\Public\Documents\RAD Studio\dbExpress\9.0\dbxconnections.ini"
DriverName=Odbc
DataBase=Database Name
User_Name=user
Password=password
IsolationLevel=ReadCommitted
RowSetSize=20
ConnectionString=
Data.DBXOdbc.pas
…
procedure TDBXOdbcConnection.DerivedOpen;
…
if ConnectionString <> '' then
ErrorCode := FMethodTable.SQLDriverConnect(FConnectionHandle, 0, PSqlWChar(ConnectionString),
Length(ConnectionString), nil, 0, BufLen, SQL_DRIVER_NOPROMPT)
else
ErrorCode := FMethodTable.SQLConnect(FConnectionHandle, PSqlWChar(DataSourceName), Length(DataSourceName),
PSqlWChar(UserName), Length(UserName), PSqlWChar(Password), Length(Password));
…
Connect string like dbxoodbc (excluding options dbxoodbc). The connection string is constructed on the basis of the documentation for odbc driver.
Ahhh, I do appreciate the info.
It seems why I couldn't figure out the ODBC files is that I don't have the DbxOdbcDriver160.bpl files let alone the source files on my install.
By any chance is ODBC not available on XE2 Pro ?
doh!
Have dbxconnections.ini and dbxdrivers.ini
for XE(8.0) setting??
see xe2 feature matrix pdf: http://embarcadero.com/delphi-features-matrix
odbc for Architect, Ultimate, Enterprise
dbx forum: https://forums.codegear.com/forum.jspa?forumID=82
Yep found the feature matrix last night, thanks.
Shame its not part of Pro, so after all this maybe there is a need still for opendbx ? :-)
Thanks again for you time in responding.
I originally had used the dbx forum which led me to this site.
>Shame its not part of Pro, so after all this maybe there is a need still for opendbx ? :-)
it may depend on the number of willing and available time
Hi
I try the ODBC dbexpress's driver in XE2.
I think…
I still like "Open dbExpress"!!!
When will the introduction of support XE2?
I very much expect!!!
win32, win64(not tested):
http://sourceforge.net/projects/open-dbexpress/files/dbxoodbc%202012%20-%20dbx%20ODBC%20driver/dbxoodbc_3_2012_0716dev.7z/download
Oh YA!!
pult!
I love U!
Thank you for all your assistance!
MetadataReader fixes:
http://sourceforge.net/projects/open-dbexpress/files/dbxoodbc%202012%20-%20dbx%20ODBC%20driver/dbxoodbc_3_2012_0724dev.7z/download
Cool!
I add a Install technical articles for Chinese language in my blogger
Hello!
Could you follow current Delphi version to updated Open Dbexpress driver?
This dbx driver is best!!!