
Code:
FUNCTION PBMAIN () AS LONG DIM oCon AS ADODBConnection DIM vSQL AS VARIANT SET oCon = NEW ADODBConnection IN "ADOX.Catalog" IF OBJRESULT OR ERR THEN MSGBOX "Error in ADODB.Connection" & $CRLF & _ "Object Result = " & STR$(OBJRESULT) & ";" & $CRLF & _ "ERR = " & STR$(ERR) & "." EXIT FUNCTION END IF ' Engine Type=5 for Access 2000 Database LET vSQL = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=C:\PBWin80\MyWork\SQL\my_new_wg.mdw;Jet OLEDB:Create System Database=-1" OBJECT CALL oCon.Execute(vSQL) IF OBJRESULT OR ERR THEN MSGBOX "Error by create workgroup" & $CRLF & _ "Object Result = " & STR$(OBJRESULT) & ";" & $CRLF & _ "ERR = " & STR$(ERR) & "." EXIT FUNCTION END IF MSGBOX "OK!" END FUNCTION
Leave a comment: