P
pauldownie
Guest
Hi, I am not having any luck making a remote connection to an Access database located on my server and I'm not sure what the issue is. I can connect to the schema holder but get an error when running a procedure: "IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". I have looked at KB 2747 but I'm not sure there is anything relevant there. I can connect to the ODBC data source through the schema holder database from the server. I have followed KB 19927 in setting it up but that KB notes that since 10.x onward Microsoft Access is no longer supported. It also states that no DataServer broker is required. I haven't found it necessary to identify any connect parameters in the schema holder when connecting from the server. When trying to connect from the client, I have tried port numbers for the NameServer and for the DataServer for the -S parameter but I'm not really sure what should go there. Is this not possible or am I missing something? Thanks, Paul OE 10.2B Windows 7 client; Windows Server 2003
Continue reading...
Continue reading...