Wrox Programmer Forums
|
BOOK: Excel 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Excel 2003 VBA Programmer's Reference by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson; ISBN: 9780764556609
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 3rd, 2010, 01:13 AM
Registered User
 
Join Date: Feb 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a DB Connection (Once) and Call Connection When Needed slbibs ADO.NET 1 April 1st, 2010 02:04 PM
connection ScottSheck BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 June 14th, 2006 05:54 PM
open connection in another connection adityamadisetty SQL Server 2000 1 May 4th, 2006 04:56 AM
Connection Help morpheus Classic ASP Basics 2 February 3rd, 2005 09:09 AM
connection alihussein3 Javascript How-To 1 September 8th, 2003 08:56 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.