MapForums

Anonymous · #1 (**permalink**) 04-11-2003

Hi,

I am facing an compilation problem error:"Cannot import data because a connection to the database could not be established"

This is the code snippet:

please anyone kindly help me :

1.I am trying to get the one coulmn of records from table and want to map .

plz any other suggestions would be great....
************************************************** *********
Private Sub Form_Load()

Dim MPApp As New MapPoint.Application
Dim objMap As MapPoint.Map
Dim objLoc As MapPoint.Location
Dim szconn As String
Dim oDS As MapPoint.DataSet

Set objMap = MPApp.ActiveMap
MPApp.Visible = True
MPApp.UserControl = True

With MPApp.ActiveMap.DataSets

'Access database with a query
szconn = MPApp.Path & "\Desktop\FirstMap\ED Conference March 2003 expanded.mdb!ZIP"
Set oDS = .ImportData(szconn, , geoCountryUnitedStates, , geoImportAccessQuery)

End With

End Sub

************************************************** ***********

thanks
Munna

**Eric Frost** · #2 (**permalink**) 04-11-2003

Just some ideas.. do you have access installed on the machine? it might need to be.

Also, check the path (e.g. MsgBox szConn) right before the Set oDS statement.

Eric

Anonymous · #3 (**permalink**) 06-25-2003

The way you have your code; your access database must be found in
the same location as the MPApp.Path.
Also you have subdirectories liste as well
"\Desktop\FirstMap\ED Conference March 2003 expanded.mdb

All of these folder must be under MPApp.Path ( Whatever MPApp.Path location is).

Hope this helps

Fer · #4 (**permalink**) 06-26-2003

Sounds like it could be a db location problem. I think Eric's suggestion of printing the path is a good one so that way you'll see exactly where it's looking for the db. You could also try to put your access db in for example C:\ and use the hardcoded path in your app:

szconn = "C:\ED Conference March 2003 expanded.mdb!ZIP"

that way you'll verify if the error arises from an unlocated db or if it's another issue.

Fernando

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
synchronous error	Wilfried	MapPoint 2006/2009 Discussion	4	06-09-2005 04:27 AM
Mappoint Error	Mudrover	MapPoint 2006/2009 Discussion	5	01-20-2005 02:59 PM
error 4014	SimonPearse	MapPoint 2006/2009 Discussion	3	01-17-2005 10:47 AM
About ERROR 4-40028-1. Error or Bug ?	Anonymous	MapPoint 2006/2009 Discussion	12	01-11-2005 09:32 AM
I get this following error	ananthdeena	MapPoint 2006/2009 Discussion	3	01-01-2005 02:46 AM

MapForums

giving an error while compiling....

giving an error while compiling....

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads