Re: Help needed to connect to remote Access database using C++ (not MFC)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

marek-knows.com wrote:
I'm working on a project which requires me to connect to a remote
Access database on a server, using C++ (not MFC). I've written some
code to connect to a LOCAL access database file on my own machine and
everything works fine. I can't seem to figure out how to get ODBC to
talk to a remote Access database though. Can anyone suggest what I
might try to get this to work?

To make the local access database connection I used function
SQLDriverConnect.

I tried modifying the connection string to include the keyword
SERVER=www.myurl.com but for some reason I just get this error
message:
IM006:1:0:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed
01S00:3:8:[Microsoft][ODBC Microsoft Access Driver]Invalid connection
string attribute SERVER

It looks to me like I can't use SERVER with the SQLDriverConnect
function?

Any help would be greatly appreciated,
thanks,
Marek

MS-Access is not a database server. You need file access to the MDB file in order to connect to it remotely. This is very different from true client/server database servers which communicate through network ports with the client. That's why with Access, you always end up doing all the processing on the client and pulling in much more data over the network than you would normally need.

HTH
.

Relevant Pages

  • Re: VB slow Access database
    ... When the executable is on the server, ... > a Visual Basic 6 .EXE and an Access database. ... > client PC by loading the .EXE from the server. ...
    (microsoft.public.vb.database)
  • Re: How to do this?
    ... move the backend tables to the SQL Server and link the sql server tables in ... > typically one things of an Access database as either a relational database ... when you speak of splitting a frontend to an IIS ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Access database stability issues
    ... We have a front-end Access database file and the back-end Access database file with all the content. ... The back-end file is located on the server while the front-end is installed on 3 different computers in our office. ... Once we upgraded to SBS 2008, each client computer began experiencing occassional crashes due to the front-end losing its connection to the back-end file. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connection Speed Issue. Im stumped!
    ... An access db is simply a file sitting on a server. ... There is no RDBMS ... First client logs on and the system runs correctly. ... Several clients log on to an Access database on a server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to do this?
    ... would return to questioning if a basic IIS server facing the public really ... to backaway from the technology a little bit to look at the business plan ... conditions on trying to front a website on an Access database that you have ... You would have IIS load of the SBS, ...
    (microsoft.public.dotnet.framework.aspnet.security)