VB & Database, Using a .UDL file as Data Provider with a MSDataShape Provider

Using a .UDL file as Data Provider with a MSDataShape Provider

Author	Message
Kostomanolakis Stavro #1 / 2	Using a .UDL file as Data Provider with a MSDataShape Provider I want to use the SHAPE command. I have a udl file, lets say ds.udl, that defines the connection to database. How can I open the SHAPE command? What is worg with the following code? <<... conn.Provider = "MSDataShape" conn.Open "Data Provider= 'File Name = C:\Program Files\Common Files\System\Ole DB\Data Links\ds.udl'" lcmd.ActiveConnection = conn lcmd.CommandText = "SHAPE {SELECT * FROM A} " & _ "APPEND ({SELECT * FROM B ... bla, bla, bla ...>> The error I got is Run-time error 80040154 class not registered in the conn.open ... line Thanks for answering, -- Stavros Kostomanolakis Software Engineer, Center for Medical Informatics and Health Telematics Applications Computer Vision and Robotics Division, Institute for Computer Science, Foundation for Research and Technology, HELLAS, P.O. Box 1385, GR 711 10, S.TE.P., Heraklion, Crete, Greece tel: +30 81 391692 (91), fax: +30 81 391601,
Fri, 12 Dec 2003 22:34:15 GMT

Chris Petche #2 / 2	Using a .UDL file as Data Provider with a MSDataShape Provider The provider should be in the datalink( uld file) Try: conn.Open "File Name = C:\Program Files\Common Files\System\Ole DB\Data Links\ds.udl" lcmd.ActiveConnection = conn lcmd.CommandText = "SHAPE {SELECT * FROM A} " & _ "APPEND ({SELECT * FROM B ... bla, bla, bla Quote: > I want to use the SHAPE command. > I have a udl file, lets say ds.udl, that defines the connection to database. > How can I open the SHAPE command? > What is worg with the following code? > <<... > conn.Provider = "MSDataShape" > conn.Open "Data Provider= 'File Name = C:\Program Files\Common > Files\System\Ole DB\Data Links\ds.udl'" > lcmd.ActiveConnection = conn > lcmd.CommandText = "SHAPE {SELECT * FROM A} " & _ > "APPEND ({SELECT * FROM B ... bla, bla, bla > ...>> > The error I got is > Run-time error 80040154 > class not registered > in the conn.open ... line > Thanks for answering, > -- > Stavros Kostomanolakis > Software Engineer, > Center for Medical Informatics and Health Telematics Applications > Computer Vision and Robotics Division, > Institute for Computer Science, > Foundation for Research and Technology, HELLAS, > P.O. Box 1385, GR 711 10, S.TE.P., Heraklion, Crete, Greece > tel: +30 81 391692 (91), fax: +30 81 391601,
Sat, 13 Dec 2003 03:05:54 GMT

Page 1 of 1

[ 2 post ]