Re: DataView with Microsoft Access
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Tue, 29 Jun 2004 15:33:15 -0400
Try...
Create an ODBC datasource for the database and use that instead of the file
path...
"Terry Liston" <terry.liston@amec.com> wrote in message
news:3972497a.0406281237.6e5625bc@posting.google.com...
> I can insert a dataview and configure SQL Server with no problems, but
> have been unable to figure out how to connect to a table in an Access
> Database. The access Database is on the server, and the directory has
> permissions set to allow IIS to read/write/delete/edit
>
> The connection string I am using is:
>
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Test.mdb;Persist
> Security Info=False
>
> That string is just a guess I constructed. The error returned is:
>
> "An error occured while retreiving the list of databases from
> c:\temp\test.mdb....
>
> Any Hints?
Relevant Pages
- asp.net 2.0 login control
... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
(microsoft.public.dotnet.languages.vb) - Re: Newbie question on SQL connection
... database on my developer machine. ... > to develop databases away from the live SQL server - that way in the ... > domain SQL Server. ... Does your connection string contain a typo? ...
(microsoft.public.dotnet.framework.aspnet) - Re: .NET and SQL Server on Separate Machines
... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
(microsoft.public.sqlserver.connect) - Re: .NET and SQL Server on Separate Machines
... add this domain account as a valid login to your sql server. ... Everything was running correctly when the database ... > The connection string in our web.config file originally looked like this: ...
(microsoft.public.dotnet.framework.adonet) - Re: FP2003 fails to validate data connection
... The connection string is not correct or DSN are not correct. ... The machine is running XP Pro with IIS 5.1 and SQL Server 2000 both running. ... > The FP2003 Database Results Wizard and Database Interface Wizard have no problem locating the active DSNs on the machine, ... Other apps I have written have no problem using these DSNs. ...
(microsoft.public.frontpage.programming) |
|
