Skip to Content
0
Feb 11, 2015 at 07:29 PM

ODBC Connection PB12.5

80 Views

I am using PB12.5 build 2511.

I am converting my application from PB11.5 build 3050.

I am having a problem connecting to an ODBC datasource.

This profile worked in PB11.5 development and the executable.

[Profile TrainingPortal]

DBMS=ODBC

Database=

UserId=

DatabasePassword=

LogId=

LogPassword=

ServerName=

DBParm=ConnectString='DSN=TrainingPortal;integrated security=SSPI',CallEscape='No',StripParmNames='Yes'

Lock=

Prompt=FALSE

AutoCommit=FALSE

for PB12.5 i had to add the datetimeallowed.

[Profile TrainingPortal]

DBMS=ODBC

Database=

UserId=

DatabasePassword=

LogId=

LogPassword=

ServerName=

DBParm=ConnectString='DSN=TrainingPortal;integrated security=SSPI;DateTimeAllowed='Yes'',CallEscape='No',StripParmNames='Yes'

Lock=

Prompt=FALSE

AutoCommit=FALSE

This profile works in development in the database painter and I can retrieve my datawindow in the datawindow painter. I can also run the application in the development environment and retrieve the data from this database. The datawindow datasource is a stored procedure.

However once I compile the application and run from the compiled executable i get a fatal error when the datawindow tries to retrieve.

when i export the database profile i get stuff in the databasepassword and logpassword.

[Profile TrainingPortal]

DBMS=ODBC

Database=

UserId=

DatabasePassword=19ee3e1f625f6c8055b5747396669c0c

LogId=

LogPassword=19ee3e1f625f6c8055b5747396669c0c

ServerName=

DBParm=ConnectString='DSN=TrainingPortal;integrated security=SSPI,DateTimeAllowed='Yes'',CallEscape='No',StripParmNames='Yes'

Lock=

Prompt=FALSE

AutoCommit=FALSE

NewLogic=EAS

it doesn't run with or without the password stuff.

can anyone tell me what i might be missing.

Thanks.