ODBC Excel and ASPNET user
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Can anyone tell me how to set the permissions on the ASP Net user account so that I can use the EXCEL or CSV ODBC driver to read from an excel file on a Windows 2003 server. I keep getting the error that I don't have permissions to read the file The code I use is shown below - it breaks on the ds.fill every time Dim conn As New Odbc.OdbcConnection conn.ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" & _directory & ";Extensions=csv" conn.Open() Dim da As New Odbc.OdbcDataAdapter("select ship from output.csv ", conn) Dim ds As DataSet = New DataSet da.Fill(ds) Thanks Mark