Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: vijayan
  Where is vijayan?
 chennai
 India
 vijayan
 To: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 Tags
Subject: RE: vfp with db2
Thread ID: 21714 Message ID: 22137 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Thursday, April 10, 2003 9:56:49 AM         
   


The problem here is not about syntax. I know to use SQL PASS THROUGH and connect and create databases in SQL SERVER from VFP. But for DB2, once you are connected to a database it does not allow to access other database or create a new database. So when i use SQLEXEC to issue a command to the backend(DB2), I am supposed to issue commands which apply to the database name given in the DSN. If I issue a command say "CREATE DATABASE TEST..." using SQLEXEC() function, it returns an error saying that "there is already a connection to existing database". So is there any way out to handle such a situation. Hope I am clear.

COMPLETE THREAD

vfp with db2 Posted by vijayan @ 3/31/2003 9:38:19 AM
RE: vfp with db2 Posted by Boudewijn Lutgerink @ 3/31/2003 10:08:19 AM
RE: vfp with db2 Posted by vijayan @ 4/4/2003 9:49:23 AM
RE: vfp with db2 Posted by Boudewijn Lutgerink @ 4/6/2003 5:32:58 PM
RE: vfp with db2 Posted by vijayan @ 4/9/2003 10:10:04 AM
RE: vfp with db2 Posted by Boudewijn Lutgerink @ 4/9/2003 3:17:59 PM
RE: vfp with db2 Posted by vijayan @ 4/10/2003 9:56:49 AM
RE: vfp with db2 Posted by Boudewijn Lutgerink @ 4/10/2003 2:19:33 PM
RE: vfp with db2 Posted by vijayan @ 4/12/2003 10:19:59 AM