Deploying ODBC connection
Deploying ODBC connection
(OP)
Hi all,
I have a VFP client database that's full of remote views to an SQL Server database.
For simplicity there's a connection (user & password) to a named instance of SQL.
I know to make sure whatever ODBC driver is installed on clients.
But how does one actually deploy 'the existing' connection on clients, please?
Any advice, best practice much appreciated.
Thank you
Mathias
I have a VFP client database that's full of remote views to an SQL Server database.
For simplicity there's a connection (user & password) to a named instance of SQL.
I know to make sure whatever ODBC driver is installed on clients.
But how does one actually deploy 'the existing' connection on clients, please?
Any advice, best practice much appreciated.
Thank you
Mathias
RE: Deploying ODBC connection
First option, create a File DSN:
1. Open the ODBC applet as usual.
2. Go to the File DSN tab.
3. Click Add and go through the steps.
4. You will be prompted for a file name. Choose a file and location for saving the DSN file.
5. On completion, you will have all the DSN settings saved in that file (it will have the extension DSN). You can distribute the file to your users.
Second option: Within VFP, use SQLSTRINGCONNECT() to connect to the driver. You pass it a string containing the relevant ODBC parameters. In this case, you don't need to distribute anything to the users (assuming they have the correct driver installed, of course).
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
RE: Deploying ODBC connection
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
RE: Deploying ODBC connection
I'll have a play with that cheers
KR
Mathias