Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Search here or MSDN for "DSNLESS connection".
Here is an example that does not requere preliminary settings on the user pc.
create database myaccess
create connection myaccess ;
connstring;
'Driver={Microsoft Access Driver (*.mdb)};'+;
'DBQ=f:\appls\rpm_vfp\db1.MDB;'+;
'DefaultDir=f:\appls\rpm_vfp'
CREATE VIEW dbview CONNECTION myaccess AS ;
SELECT * FROM RPMEXCELInput
use dbview
>Dear All
>
>Is it possible to setup ODBC connection programatically? I am using Report Manager and on the production machine I have setup the ODBC to look in a particular directory for the DBC.
>
>Now on the clients machine I can do so manually and alls well. But I would like to automate this process, so as to remove the chances of errors. I can do this at the application startup, this can assure me that I know the path from where the application is starting and thus I know relatively where the data is lying.
>
>Could anybody share with me a way to do this programatically.
Précédent
Suivant
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