ADO Connection to MaxDb
Using VBA (Excel 2007) I am trying to connect to MaxDb using the following connection string sapconn.Open “DRIVER={MaxDB};” _ & “SERVER=sapdevsrv_DEV_00;” _ & “DATABASE=200;” _ & “UID=AMJAD_PBL;” _ & “PWD= ;” But it’s generating an error saying [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified For your convenience the system [...]

Answer Question   |  March 31, 2010  1:15 PM
ADO Connection, VBA, VBA: ADO Connection to MaxDB

Connect to Oracle 10g with VB6 using ADO
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!

Answer Question   |  May 8, 2013  6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6

ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Answer Question   |  February 3, 2009  3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades