Just in addition.
If you wish to ensure that your DSN connection string is with proper syntax, make a file DSN connection from ODBC Data Source Administrator.
After that locate the DSN file (the path normally is
"C:\Program Files\Common Files\ODBC\Data Sources\")
Open the DSN file as text (use notepad or whatever you want)
The connection string is bellow the [ODBC] section (replace new lines (CrLfs)with semi-columns (";"s))
>1. Define a DSN-less connection to your SQL Server database.
>Below is a sample to connecto to SQL Server's Northwind
>database.
>
>
> OPEN DATA YourDBC
> CREATE CONNECTION MyConnection ;
> CONNSTRING 'DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind'
>
>
>2. Create your remote view to use this connection.
>
>
> CREATE SQL VIEW MyView REMOTE CONNECTION MyConnection SHARE AS ;
> select EmployeeID, LastName, FirstName from employees
>
>
>3. Use your remote view as a regular VFP table.
>
>
> OPEN DATA YourDBC
> USE MyView
> BROWSE
>
>
>
>or, you could use SQL pass-through with something like:
>
>
>nConn = SQLStringConnect('DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind')
>sqlexec(nConn, 'select * from employees', 'curEmployees')
>select curEmployees
>browse
>
>
HTH
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!