Microsoft DataShape Provider

5. Oktober 2015 von Centron GmbH

Microsoft DataShape mit einem SQL Server OLE DB Provider:

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

oConn.Open "Provider=MSDataShape;" & _

"Data Provider=SQLOLEDB;" & _

"Data Source=mySQLServerName;" & _

"Initial Catalog=myDatabase;" & _

"User ID=myUsername;" & _

"Password=myPassword"

Microsoft DataShape mit einem JET OLE DB Provider:

oConn.Open "Provider=MSDataShape;" & _
           "Data Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "User ID=myUsername;" & _
           "Password=myPassword"

oConn.Open "Provider=MSDataShape;" & _

"Data Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Dbq=c:\somepath\mydb.mdb;" & _

"User ID=myUsername;" & _

"Password=myPassword"

Danach benutzen Sie bitte einen Shape-Befehl mit SQL-Strings:

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

sSQL = "SHAPE {select * from authors} " & _

"APPEND ({select * from titleauthor} AS chapter " & _

"RELATE au_id TO au_id)"

Alternativ können Sie auch einen Prozeduren speichernden Shape-Befehl verwenden:

sSQL = "SHAPE {exec spAuthors_LoadAll} " & _
     "APPEND ({exec spTitleAuthor_LoadAll} AS chapter " & _
"RELATE au_id TO au_id)"

sSQL = "SHAPE {exec spAuthors_LoadAll} " & _

"APPEND ({exec spTitleAuthor_LoadAll} AS chapter " & _

"RELATE au_id TO au_id)"