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 status is shown as follows:
Usage Data (Client=200, user=AMJAD_PBL)
Host data (Operating system= Linux, Server Name=sapdevsrv, platform ID=390)
Database Data (Database System=MaxDB, Release 7.7.06.010, Name=DEV, Host=sapdevsrv, Owner SAPDEV)
Your urgent help will be highly appreciated
Software/Hardware used:
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 status is shown as follows:
Usage Data (Client=200, user=AMJAD_PBL)
Host data (Operating system= Linux, Server Name=sapdevsrv, platform ID=390)
Database Data (Database System=MaxDB, Release 7.7.06.010, Name=DEV, Host=sapdevsrv, Owner SAPDEV)
Your urgent help will be highly appreciated
Software/Hardware used:
ASKED:
March 31, 2010 1:15 PM
UPDATED:
March 31, 2010 2:13 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
