Unable to Link PTW Database with Crystal Report 2016 (Database Vendor Code -1203)

Creation date: 4/2/2020 9:17 AM    Updated: 4/2/2020 10:48 AM

When trying to link Crystal Report 2016 to PTW Database, there will be a logon error (Database Vendor Code -1203) like the window below.



Previous versions of Crystal Report (Crystal Report XI), the database will look in the following path:

C:\Users\localadmin\AppData\Local\VirtualStore\Windows\odbc.ini


Crystal Report 2016 looks in the following path:

C:\Windows\odbc.ini



The odbc.ini file in C:\Windows does not have all of the information like the file located in C:\Users\localadmin\AppData\Local\VirtualStore\Windows.


To resolve this issue, you can copy the data from C:\Users\localadmin\AppData\Local\VirtualStore\Windows\odbc.ini to C:\Windows\odbc.ini. Make sure that you do not remove other information as other programs use Crystal Report and may be affected.


This is the text that has to be copied to the C:\Windows\odbc.ini 
[
PTW_PRJ=POET 6.0 Driver (32 bit)
PTW_LIB=POET 6.0 Driver (32 bit)
[Xtreme Sample Database 11]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[PTW_PRJ]
Driver32=C:\PTW32\bin\pt6sim32.dll
Description=ODBC POET driver
DataDirectory=C:\PTW32\LIB\ptw32.cfg
BaseName=ptwprj
Location=l
ServerName=LOCAL
OpenMode=SharedRead
[PTW_LIB]
Driver32=C:\PTW32\bin\pt6sim32.dll
Description=ODBC POET driver
DataDirectory=C:\PTW32\LIB\ptw32.cfg
BaseName=ptwlib
Location=l
ServerName=LOCAL
OpenMode=SharedRead


You can refer to the odbc.ini in this FAQ for the minimum information needed for the this to work.




Files
ODBC.INI
605 b