Pb, I built a database profile, name is bookinfo
With the data source bookinfo is driven by SQL server odbc data source
Now write a login window, with the following statement:
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ConnectString='DSN=bookinfo"
The connect.
But not even bookinfo database... Don't know what to do...

CodePudding user response:

First test DSN Settings are correct...

CodePudding user response:

How to test? .

CodePudding user response:

Database connection configuration, inside the panel TEST the CONNECT;

CodePudding user response:

First test DSN Settings are correct...

reference SKY_4K_PPM reply: 3/f

database connection configuration, inside the panel TEST the CONNECT;

CodePudding user response:

DSN data source connection way, there is no user name in your connection string password?
If is empty, you can then test the data source is able to connect to success

CodePudding user response:

The odbc data source configuration is correct,

CodePudding user response:

reference 5 floor givemekey reply:

DSN data source connection way, there is no user name in your connection string password?
If is empty, you can then test the data source is able to connect success