General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Connection String TO VFP using VBA
Hi All,
I’m trying to get connected to VFP6 backend database using VBA. I used a Udl file to build the connection string and tested it over and over. Everything worked OK there. When I pasted the same connection string in my VBA code I get an error message saying
“Object Variable Or with Block Not Set..”
What does this mean ?? How do I correct it ?
My VBA Code..
*---------------------------------------------
Dim M2MConnect As ADODB.Connection
M2MConnect.Open "Driver={Microsoft Visual FoxPro Driver};" _
& "UID=;PWD=;SourceDB=R:\M2Mdata\DATA10\M2MDATA.DBC;" _
& "SourceType=DBC;Exclusive=No;"
*------------------------------------
Please HELP !!!
TIA
- Jeana -
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only