Connecting using IPv6

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
NickXCT
Posts: 3
Joined: Tue 03 Feb 2015 19:39

Connecting using IPv6

Post by NickXCT » Tue 03 Feb 2015 19:44

I'm trying to connect to a MySQL server using IPv6. I can connect to the server using the IPv4 address with dbExpress driver and I can connect to the server using the IPv6 address using the MySQL Workbench (so I know the IPv6 address works over the network). But I cannot get the dbExpress driver to work with the IPv6 address. I have the following parameters:

DriverUnit=DbxDevartMySql
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver200.bpl
MetaDataPackageLoader=TDBXDevartMySqlMetaDataCommandFactory,DbxDevartMySqlDriver200.bpl
ProductName=DevartMySQL
GetDriverFunc=getSQLDriverMySQLDirect
LibraryName=dbexpmda40.dll
VendorLib=not used
MaxBlobSize=-1
FetchAll=True
EnableBoolean=False
UseUnicode=True
HostName=xxxx:xxxx:xxxx:x:xxxx:xxxx:xxxx:xxxx
DataBase=databasename
User_Name=loginid
Password=loginpw
IPVersion=IPv6

Where xxxx:xxxx:xxxx:x:xxxx:xxxx:xxxx:xxxx is the IPv6 address.

Can you tell me what I'm doing wrong?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Connecting using IPv6

Post by ViktorV » Wed 04 Feb 2015 09:56

Thank you for the information. We have reproduced and fixed the issue. The fix will be included in the next dbExpress Driver for MySQL build.

NickXCT
Posts: 3
Joined: Tue 03 Feb 2015 19:39

Re: Connecting using IPv6

Post by NickXCT » Wed 04 Feb 2015 11:34

That's great.

Can you tell me where the problem lies? E.g. can I work round this by not using the BuiltIn module?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Connecting using IPv6

Post by ViktorV » Wed 04 Feb 2015 13:05

To solve the problem, you can delete the "coIPVersion = 109" constant declaration in the dbxmda.pas module.

NickXCT
Posts: 3
Joined: Tue 03 Feb 2015 19:39

Re: Connecting using IPv6

Post by NickXCT » Wed 11 Feb 2015 14:39

Thanks for that. That fixed the problem. :D

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Connecting using IPv6

Post by ViktorV » Thu 12 Feb 2015 09:04

Glad to see that the issue was resolved. Feel free to contact us if you have any further questions about dbExpress driver for MySQL.

Post Reply