AdoDB: How to issue "USE DB" Command

[Jayadev U]

Hi,

 

As per subject line, the command oConn:Execute("Use  AS4”) results in error:

 

 

The command is perfectly valid in Sql-Studio and also in SQLMIX.  This is just to ensure that ensuing operations are limited to the database used only.

 

What is the equivalent command in ADO.

 

Best,

 

Jayadev

 

 

[Francesco Perillo]

Don't you specify database in the connection string?

--
Has recibido este mensaje porque estás suscrito al grupo "ADO Harbour" de Grupos de Google.
Para cancelar la suscripción a este grupo y dejar de recibir sus mensajes, envía un correo electrónico a ado-harbour...@googlegroups.com.
Para ver este debate, visita https://groups.google.com/d/msgid/ado-harbour/000701dcdacc%24214ed3f0%2463ec7bd0%24%40gmail.com.

[Jayadev U]

Hi,

 

Sorry for the noise, please ignore.

 

I did not select the MSSQL connection prior to execution of the command, the command was trying to execute on an MSACCESS connection.

 

Best,

 

Jayadev