MapForums
Community of MapPoint and Virtual Earth Users and Developers
Using VB6 to Link to SQL View
This is a discussion on Using VB6 to Link to SQL View within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; What is the best way to do this? In the Help file examples, I do not see a syntax defined ...
| |||||||
| Today's Posts | Twitter Feed | Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
12-08-2004
| |||
| |||
| Using VB6 to Link to SQL View         |
|
12-08-2004
| |||
| |||
| Answer
Ok. I figured out my own problem. Of course I will share... For those of you trying to Import/Link directly to a SQL Table or View instead of using MS-Access as the "middleman". First create a UDL file that points to your SQL database (I use the ODBC DSN method). Here is the syntax for the code to link: LinkData("C:\My_Data.UDL!My_Table", "ID_Field") The part I was having a hard time with was the after the "!". You must specify the name of your SQL table or view here. Hope this helps. |
|
12-08-2004
| ||||
| ||||
|
Thanks for the follow up. Eric
__________________ |
 |
| Tags |
| link, sql, vb6, view |
| ||||
| Posted By | For | Type | Date | |
| Sql view example - Using ADABAS Data in SAS Programs : Selecting and Combining Data | This thread | Refback | 04-11-2007 08:02 AM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| View by zip code | John Swanick | MapPoint 2006/2009 Discussion | 8 | 07-12-2005 08:05 AM |
| Choosing what to view | Anonymous | MapPoint 2006/2009 Discussion | 1 | 12-04-2003 03:46 AM |
| 3D View | Anonymous | Wish List | 0 | 06-06-2003 05:19 PM |
| One country view only? | Anonymous | MapPoint 2006/2009 Discussion | 1 | 04-18-2003 10:45 AM |
| Print View | healthsouthgirl | MapPoint 2006/2009 Discussion | 1 | 08-14-2002 09:03 PM |
All times are GMT -5. The time now is 01:54 AM.
