Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL update with different database
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
00153692
Message ID:
00153711
Vues:
23
Actually, it's "SELECT * FROM database..table". Note the double periods.

>Hi Stephane ---
>
>I don't think you can use one DSN for two SQL Server databases but I could be wrong. Are you explicitly naming the database in all SQL statements, ie, "SELECT * FROM database table" ?
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform