Hi Mark
Sorry, I should have been more specific in order to make clear that I’m using the MSDE and started to try some code samples to create SQL databases, and always used the same DSN.
Then I added some tables and in some cases I explicitly tell to which of the databases the tables being created belonged to, by first using the SQL server statement USE
When creating some remote views into a VFP database, I realized that by choosing the DSN name I could only see those tables created when no database was specified. Thus these tables where into the Default database (dbo in my case).
I then created a connection without the use of a connection string and specifying the name of one of the database created for that DSN.
I was until then that I was able to see the tables (for that specific database) available when creating a remote views through such connection.
By reviewing the MSDN documentation, I found that there exists a “Database collection” with a Count property. This makes me understand that there should be a way to enumerate or reference every item of such collection and this is what I can’t do right now.
I’ll appreciate any hints.
Oscar Corte
BTW: There’s only one item missing on your list of links of your signature. What about adding a link to the FoxPro 10th anniversary list?
>I do not know of any way a DSN can connect to more than 1 database. If you mean all the tables in a database, see SQLTABLES() function in VFP help.
>
>>Is there a say to list or display all databases which can be accessed through a specific DSN?
>>
>>Thanks in advance for any hints
>>
>>
>>Oscar Corte
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement