Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-04 : 09:25:18
|
| Col writes "I have created a COM DLL in VB6 that opens an instance of the MapPoint.Application object to work out the Longitude and Latitude for a give Post Code. The object works fine on the server when I use it through a Test.exe I have written.When I try to use the object in a stored procedure (SQL Server 2K), it creates the object fine, but when I call the StartMapPoint method (shown below) I get an errorPublic Sub StartMapPoint() Set MapPt = CreateObject("MapPoint.Application") MapPt.Units = geoMilesEnd SubI changed the above code to late binding because the early binding was returning the same error and I was clutching at straws!It sits there for ages and finally returns a "can't create active X component" error.If I try to access the MapPoint object directly through SQL Server (EXEC @Hr = sp_OACreate 'MapPoint.Application',@Object OUT) I get a "Server execution failed" error.Am I doing something wrong or is MapPoint simply not accessible in this way?Any help would be much appreciated.ThanksCol." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-11-04 : 18:46:47
|
I haven't used mappoint but this sounds nasty.It could be a permissions issue, perhaps the component is trying to do something that the SQL Server user is unable to do ? (Guessing here  )Also, what sort of load is this thing going to run ? I don't like the thought of running something like this in a stored proc. Is there any other way you can do it ?Damian |
 |
|
|
|
|
|
Problems Using sp_OACreate with MapPoint