Connection to Maxdb
using Excel 2003
using ADO/ODBC
I need to connect to Maxdb (our SAP uses Maxdb)
On my PC SAP Easy Access has been installed
my server is 192.168.2.5
I used control panel to creat DSN cinnection but
for database name I do not know what should I put.
Please help
Upon Seccessful creation of DSN I intend to establish the connection using the following code.
Dim rs As adodb.Recordset
Dim objConn As New adodb.Connection
objConn.ConnectionString = "DSN=MATRICE;UID=USER;PWD=PSWUSER"
Call objConn.Open
|