I have tried to do this using the Link Table Wizard - Selecting :
New Source
Other/advanced
Microsoft SQL Server 2005 Mobile Edition OLE DB Provider
Setting the connection to a copy of the sqlce database (jobbookings.sdf) on
my PC
I test the connection and it succeeds
I then am presented with a list of tables to link to
I then select a table I want to link to and it fails with:
'unspecified error'
Can anyone enlighten me what the error is likely to be and can I do anything
about it?
I am able to link to the database via sqlserver 2005, but it would be very
nice to use some of the features in Access to view and export data to the
database.
Re: Access Lock Remains after Connection Closed - OLE DB / Jet ... I have used this provider for serveral years against Access ... I release the provider, the connector checks if the connection is open, ... It then disposes of the connection, ... The database is an empty template database that is ... (microsoft.public.dotnet.framework.adonet)
Re: Disabling ASP.net 2.0 Membership ... I checked out the article you referenced and implemented my own provider.... as a FoxPro database, an Oracle database, or other data sources. ...custom connection string so that I can use the Commerce Server SQL Server... (microsoft.public.dotnet.framework.aspnet)
Re: test connection failed ... .udl contains connection string and path to database (for Microsoft Jet... Check also that you have Jet provider installed or install Jet SP from ... (borland.public.delphi.database.ado)
Re: SQLMembershipProvider ... is by editing the web config file by hand. ...Provider selection page under ASP.NET configuration, ... connecting to a database other than ASPNEWSQLProvider, ... Although I have learned how to change the connection,... (microsoft.public.dotnet.framework.aspnet)
Re: Access Lock Remains after Connection Closed - OLE DB / Jet ... I have a connector class that manages this provider.... I release the provider, the connector checks if the connection is open, ... It then disposes of the connection, ... The database is an empty template database that is ... (microsoft.public.dotnet.framework.adonet)
