When I try to build a oedb data connection, I got an error message saying
"Invalid path or you have to connect to the server the database is resided".
I can see dataset through Data - Preview dataset. I don't what could be the
problem. Can soemone please help me with this ASP.net beginner's question?
Thanks in advance for any help! 11 2005
Hi,
Is the data source an Access or Excel file?
--
HTH,
Rakesh Rajan
MVP, MCSD http://www.msmvps.com/rakeshrajan/
"Frank Xia" wrote: When I try to build a oedb data connection, I got an error message saying "Invalid path or you have to connect to the server the database is resided". I can see dataset through Data - Preview dataset. I don't what could be the problem. Can soemone please help me with this ASP.net beginner's question?
Thanks in advance for any help!
Hi Rakesh,
ODBC will connect to both of those sources.
Hope that helps,
Jan
Frank,
About what you ask are thousand possibilities how you do this. By instance
the programming language, however maybe more important, how do you make the
code for the connection. Do you use a designer and than how?
As you said you are a beginner, do I suppose that you use the dataadapter,
which is a wizard. Did you do all the tests which are in that?
Cor
Dear Jan,
I wanted to find whether he was using a file or non-file based data source
or not.
If it something like Access or XLS, then security permissions come into play.
--
HTH,
Rakesh Rajan
MVP, MCSD http://www.msmvps.com/rakeshrajan/
"Jan Bannister" wrote: How are you an MVP???
Hey Rakesh,
Since both of the sources you mentioned are files then there is no way
(and should be no way) to circumvent file access issues.
Jan
Dear Jan,
You understood my post wrong. Sorry if the message wasn't clear.
Frank says, he is using OleDb and the error message also mentions about
'path'. In many cases, if it's an OleDb connection, the data source could be
an Access or Excel file.
I wanted to find out whether Frank is using either Access/Excel or a
non-file based data source.
If it's Access/Excel, then OleDb needs to create temporary files to open the
data source. Unless ASPNET or the impersonated user has modify privilages to
folders having these files, you will get an error. I have mentioned this here: http://msmvps.com/rakeshrajan/archiv.../04/56461.aspx
I just wanted to check whether Frank was facing something related to this.
--
HTH,
Rakesh Rajan
MVP, MCSD http://www.msmvps.com/rakeshrajan/
"Jan Bannister" wrote: Hey Rakesh,
Since both of the sources you mentioned are files then there is no way (and should be no way) to circumvent file access issues.
Jan
My Mistake Rakesh,
The previouse questio ndidn't appear in my view of the thread.
Jan
Sorry. Please accept my apology for late response. I was away this weekend.
The database is in Access.
Thanks!
"Jan Bannister" wrote: Hey Rakesh,
Since both of the sources you mentioned are files then there is no way (and should be no way) to circumvent file access issues.
Jan
Sorry for late response. Thanks for your help!
After I put my ACCESS database in c:\innetpub, I can access the database
successfuly. But I wonder why I can not to connect to network drive even the
test connection is successed when I tried wizard. Now I hardcoded path in
connection string.
"Cor Ligthert [MVP]" wrote: Frank,
About what you ask are thousand possibilities how you do this. By instance the programming language, however maybe more important, how do you make the code for the connection. Do you use a designer and than how?
As you said you are a beginner, do I suppose that you use the dataadapter, which is a wizard. Did you do all the tests which are in that?
Cor
Frank,
For a access database you probably want to update. Beside that you need
therefore to get on the drive, does the accessfile as well needs almost full
rights,
I hope this helps,
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Joe |
last post by:
Hi All,
I am new to using the Access DB and I need some help if someone
is able to give it to me. What I want to do is get the names of
the columns of certain tables. Not the data in the table...
|
by: aacool |
last post by:
Hi,
I've been trying to open an Excel connection through OLEDB with the code
below:
string ConnectString =@"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" + fileName.Text +...
|
by: Pam Ammond |
last post by:
I need the code to update the database when Save is clicked and a text field
has changed. This should be very easy since I used Microsoft's wizards for
the OleDBAdapter and OleDBConnection, and...
|
by: Brian Henry |
last post by:
I have an access database, and one of the fields in the table I am inserting
into has a date/time data type. What is the correct OleDb data type to
insert the date and time that it is at the moment...
|
by: Brian Foree |
last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend,
and have just started getting the following error on 2 ASP.NET pages that
had been working until late last week (and I...
|
by: Martin |
last post by:
Hi,
I currently have an application that connects to an MS ACCESS database. This
application uses an OLEDB connection string for MS ACCESS.
Now, I'd like to upsize the application so I converted...
|
by: NicK chlam via DotNetMonster.com |
last post by:
this is the error i get
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.Common.DbDataAdapter.Update(DataRow dataRows,
DataTableMapping tableMapping)
at...
|
by: petro |
last post by:
Hello all,
My asp.net web application works on my machine but I get the following error
on our test web server, There is only one oracle home on the test server.
Does anyone know how to resolve...
|
by: blue875 |
last post by:
When I run this connection, I get a security error.
String connectStr = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"User Id=USER; Password=PASS;" +
@"Data Source=\\SERVER\DIRECTORY\Data.mdb;" +...
|
by: ErikJL |
last post by:
I have a simple webservice that performs a SELECT query against a database, and then an INSERT statement on the same database/table. The problem arises at the time when we create the second OleDB...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |