Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hello I use SqlAnywhere 12 with Delphi 2010. The connection to the Database is with ODBC ADO.

I have migrated my project to Windows 10 64Bit and creating an ODBC ConnectionString with the TADOConnection Component. My problem is that I can not find "SQL Anywhere OLE DB Provider 12"

How can i solve this problem?

asked 16 Feb '17, 08:00

Ordnadito's gravatar image

Ordnadito
40113
accept rate: 0%

Silly question: Was it installed on this new machine?

However you installed it on the other system you will need to do the same on this new system. And if you have just copied the necessary files to this system you do need to register the driver. You do that by executing these cmdlines

regsvr32 dboledb12.dll
regsvr32 dboledba12.dll

The same may hold for other DLLs you may need.

(16 Feb '17, 19:11) Nick Elson S...

Hello He was on vacation and could not answer. It seems that I could not explain myself.   I have installed Sql Anywhere 12/64 Bit on a PC with Windows 10/64 bit and I have Created an odbc

In a Windows 32 bit environment you can create a connection to SQL Anywhere OLE DB Provider 12. Lately in my PC 64 Bit is not found OLE DB Provider 12.

Is that normal or maybe I need some trieber on my PC? Espero que puedan decifrar mi Google english.

Thanks for the help.

permanent link

answered 01 Apr '17, 13:34

Ordnadito's gravatar image

Ordnadito
40113
accept rate: 0%

So are these according files contained in the \bin32 and/or \bin64 subfolders of your SA 12 install?

  • dboledb12.dll
  • dboledba12.dll

I don't know whether your Delphi project requires a 32-bit or 64-bit OLE DB driver - but you should make sure the according one is installed and registered accordingly, as Nick has pointed out. If you have both 32-bit and 64-bit drivers installed, note to make sure that you register both within their subfolder.

(04 Apr '17, 05:22) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×44

question asked: 16 Feb '17, 08:00

question was seen: 3,570 times

last updated: 04 Apr '17, 05:22