MSDATASHAPE

Results 1 to 2 of 2

Thread: MSDATASHAPE

  1. #1
    Join Date
    Dec 1969
    Posts
    21

    Default MSDATASHAPE

    i&#039;m not using sql statment anymore but i used this SHAPE statement :<BR><BR>"SHAPE {select pub_id, pub_name from publishers} " &_<BR>"Append ({select pub_id, title from titles} " &_<BR>"Relate pub_id to pub_id) as rsTitles , " &_<BR>"({select * from employee} " &_<BR>"Relate pub_id to pub_id) as rsEmployees"<BR><BR>The problem: This shape statement wont work with this database connection:<BR><BR>accessdb="database/baza.mdb" <BR>MyDsn="DRIVER={Microsoft Access Driver (*.mdb)};"<BR>MyDsn=mydsn & "DBQ=" & server.mappath(accessdb)<BR><BR>Which connection statement do i have to use?<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    4

    Default RE: MSDATASHAPE

    It should look something like this:<BR><BR> set objconn = server.createobject("adodb.connection")<BR> objconn.provider = "MSDataShape"<BR> objconn.open "DSN=name_of_db"<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •