MapForums

webjagger · #1 (**permalink**) 06-24-2004

I'm using MapPoint 2004, VB.Net and SQLServer and I wonder if and how it is possible to use a stored procedure inside the DataSourceMoniker of the ImportData method.
What I've allready done is

Code:

ImportData("db.udl!q_MyQuery", ...)

Another way might be to add the where clause to the DataSourceMoniker. Is that possible?

My problem is that I can't use different queries.
So anybody has an idea?

Thanks in advance.

Alex

Anonymous · #2 (**permalink**) 06-24-2004

....afaik, you can't import from SQL server, just from MS Access. Hope I’m wrong!

You are on the right track with the moniker other than that. In Access you can definitely import from a query. Just use geoImportAccessQuery in the import flags. Note, I have found that is fails with very long path names...or of course if you have a ! in the path somewhere.

I assume you know where the docs are, but just in case:

http://msdn.microsoft.com/library/en...asp?frame=true

Hope this helps.

webjagger · #3 (**permalink**) 06-25-2004

Yes, ChrisA, you are wrong.
Inside that udl-file you can also specify a connection to a SQLServer.
I tried it and it works fine.

So I'm still hoping, that I get the problem solved to use a sp or get the where clause integrated somehow?!

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
I have tried for some time to link to data stored ....	Anonymous	MapPoint 2006/2009 Discussion	3	06-24-2006 09:00 AM
Remote procedure call failed: Location. StreetAddress	Vinay	MapPoint 2006/2009 Discussion	3	02-16-2006 01:34 PM
ImportData method ?	mgorgone	MapPoint 2006/2009 Discussion	2	06-02-2005 01:31 PM
ImportData	Anonymous	MapPoint 2006/2009 Discussion	0	11-04-2004 03:05 AM
Implementing ImportData in C/C++	moojit	MapPoint 2006/2009 Discussion	0	09-01-2002 10:58 PM

MapForums

Stored Procedure in DataSourceMoniker of ImportData medthod

Stored Procedure in DataSourceMoniker of ImportData medthod

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

Similar Threads