August 16, 2007 at 2:28 pm
I am using OpenDataSource to open up a Microsoft access "like" data file. The only way I can access these files without the application bombing is to share the folder in which these files are saved. If I try to access a folder that is not shared OLE DB tells me that it cannot find a specific table or the user does not have permission. What user does OpenDataSource run under, and what other permission issues do I need to work out to get this to work. I would share the other folder that is in our development tree, but I cannot share them as the same name. If I unshared the folder in the live site tree and shared the folder in the development site tree it works just fine.
August 17, 2007 at 10:25 am
I am trying to open and query a Microsoft Access "like" database from SQL Server 2000 using OpenDataSource. This will work for a little while, but if I am to update my ASP.NET code base I have to completely reboot the machine for these queries to work again. I also have two reboot the machine periodically because this functionality decides to crap out. I am doing this from a stored procedure. My code looks like this:
DECLARE @SelectCode varchar(5000)
SET @SelectCode =
'SELECT CONVERT(varchar, Value) AS UnitName FROM
OPENDATASOURCE(''Microsoft.Jet.OLEDB.4.0'', ''Data Source = "' + @Path + @DataFile + '.fcd";User ID=Admin;Password=;'')...Properties WHERE Property LIKE ''UnitName'''
EXEC(@SelectCode)
Now, when I am developing on my local machine that uses Windows Authentication, I have absolutely no problems, unless the source file has a schema error.
Any ideas?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply