Ok, on the PC that does not have any Access DSN info in the ODBC manager I receive this error message when I try to connect to the Access database:
"Data source name not found and no default driver specified."
Here is my DSN-less code (names changed to protect the innocent):
create database 'INFO' && Create the database
* The install program will create this DSN.
lcDNS = 'DSN=MS Access Database;' + ;
'DBQ=' + allTrim(m.accessdir) + ';' + ;
'DefaultDir=' + justPath(m.accessdir) + ';' + ;
'DriverId=25;' + ;
'FIL=MS Access;' + ;
'MaxBufferSize=2048;' + ;
'PageTimeout=5;' + ;
'UID=admin;'
Create Connection xyz ConnString (lcDNS)
lcssn = ''
***************** View setup for FINDSSN ***************
create sql view "FINDSSN" ;
remote connection "XYZ" shared ;
as select ssn, lastname, firstname, midname, suffix, gender ;
from info ;
where info.SSN = ?lcssn
Any ideas on what I am doing wrong???
Thanks!
>>How can I have a DNS-less connection without a local and file DSN? I can create the local DSNs through the registry. How do I create a file DSN? With just a file in the directory as you described? Damn MSFT has to make this so difficult....
>>
>
>A DSN-less connection means you don't have a DSN. You don't have a local, system or file DSN.
>
>A DSN holds the necessary inforamtion to connect to a particular data source. It has the driver name, server, path (if needed), user name (if needed) and password (if needed) as well as other attributes that are driver specific. The SQLConnect function or the remote view's connection uses this information to connect to the data source via the driver. If you use a DSN-less connection, all the information needed to connect to the data source is passed in the string itself. You don't need anything else.
>
>The only thing you need with a DSN-less connection is the driver installed properly on the machine.