Search
Tuesday, July 22, 2014 ..:: Technology » Connection Strings » DataShape Provider ::.. Register  Login
Site Navigation

 DataShape Provider Minimize


oConn.Open "Provider=MSDataShape;" & _
           "Data Provider=SQLOLEDB;" & _
           "Data Source=mySQLServerName;" & _
           "Initial Catalog=myDatabase;" & _
           "User ID=myUsername;" & _
           "Password=myPassword"

Then use a shape command with SQL strings:

sSQL = "SHAPE {select * from authors} " & _
     "APPEND ({select * from titleauthor} AS chapter " & _
     "RELATE au_id TO au_id)"

Or use a shape command that calls Stored Procedures:

sSQL = "SHAPE {exec spAuthors_LoadAll} " & _
     "APPEND ({exec spTitleAuthor_LoadAll} AS chapter " & _
     "RELATE au_id TO au_id)"
 
oConn.Open "Provider=MSDataShape;" & _
           "Data Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "User ID=myUsername;" & _
           "Password=myPassword"
 

For more information, see:  Microsoft Data Shaping Service for OLE DB  and  Q288409

To view Microsoft KB articles related to MS DataShape, click here 


  

Copyright 2005 CarlProthman.NET   Terms Of Use  Privacy Statement