Open topic with navigation
If you are writing an application in a language that can use Microsoft ActiveX Data Objects (ADO)—such as Visual Basic, ASP scripting languages, and so forth—you can access a Synergy database via ADO. Note the following:
For information on using ADO.NET, see Accessing Synergy data in a .NET environment.
To access Synergy data using ADO, you need a connection string that includes all the information needed to make the connection. The following is the syntax for a connection string that uses a DSN:
where dsn is a DSN, user is a username, pwd is the password for the user, and connect is the name of a connect file for the Synergy database.
Note the following:
The following ADO example uses Visual Basic. In this example, a DSN (MyDSN) is used to make a connection to the sample Synergy database.
<% DIM sConnStr sConnStr = "DSN=MyDSN;UID=DBADMIN;PWD=MANAGER;" DIM SQLQuery SQLQuery = "SELECT * FROM Customers" Set OBJdbConn = Server.CreateObject("ADODB.Connection") OBJdbConn.Open sConnStr Set RsCustomerList = OBJdbConn.Execute(SQLQuery) %>
You can connect to a local Synergy database without using a DSN. DSN-less connection strings are not supported for remote connections.
Use the following syntax for the connection string:
where user is the username, pwd is the password for the user, and connect is the name of the connect file for the database. If you don’t supply a username, password, or connect file name, and one is needed for the connection, the user will be prompted to supply the missing information.
With DSN-less connections, you cannot override the defaults for settings listed in step 5 of Adding a user or system DSN (settings such as the maximum number of columns that can be returned for a query).
The following example is a line of Visual Basic code that connects to the sample Synergy database without using a DSN: