|
PowerBuilder supports a number of database interfaces other than ODBC. Those options include JDBC, OLEDB, and ADO.NET (and it may also be possible to connect via openclient although that is not supported - or known to work). You can connect using ODBC without a DSN. That technique is termed a DNSLess connection. This is an ODBC feature that requires the use of the parameter Driver that is set to the value of the ODBC Driver Name. Here is an example: sqlca.DBMS="ODBC"
sqlca.DBParm = "ConnectString='Driver={SQL Anywhere 12};ENG=SAEng,DBN=SADbName;UID=dba;Pwd=sql'"
The PowerBuilder Documentation "Connecting to your database" describes each of the interface options and is a useful reference. |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
question asked: 12 May '17, 02:17
question was seen: 1,446 times
last updated: 12 May '17, 09:28