Alright ya'll,
lets see if we can solve this stupid error.
I have a "server" I am writing (a gateway program that monitors programs in
a legacy system that writes out 'text' files to a shared drive).
So, in the first development environment, it worked fine, Windows XP pro,
fine. Now I'm in my test environment, (VMWare 4.0 on my machien, VS.NET
2003) i keep getting an ODBCException on the Fill (using an ODBC Driver,
ASCII, Tab deliniated, etc.)
The message is
Message "ERROR [42S02] [Microsoft][ODBC Text Driver] The Microsoft Jet
database engine could not find the object 'RTDXWRK.TXT'. Make sure the
object exists and that you spell its name and the path name correctly."
String
Yet it finds it in a few lines of code above. I have a directory window
open, works fine. I have my connection string set in the web.config for the
ODBC Ascii driver, thats fine. worked fine in the development environemtn,
but now.. not dice.
clues?
Thanks,
CJ 11 5529
> So, in the first development environment, it worked fine, Windows XP pro, fine. Now I'm in my test environment, (VMWare 4.0 on my machien, VS.NET 2003) i keep getting an ODBCException on the Fill (using an ODBC Driver, ASCII, Tab deliniated, etc.) The message is
Message "ERROR [42S02] [Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'RTDXWRK.TXT'. Make sure the object exists and that you spell its name and the path name correctly." String
Yet it finds it in a few lines of code above. I have a directory window open, works fine. I have my connection string set in the web.config for
the ODBC Ascii driver, thats fine. worked fine in the development
environemtn, but now.. not dice.
Are you sure the source directory is right in the Connection String? The
other thing is that sometimes in the ODBC Text Driver you are forced to
specify what file extentions it should recognize (ie. TXT, ASC, etc...), do
you have that option (Click options, then is should show an extention list)?
~
Jeremy
Hey Jeremy,
Yeah I got all that set right..
Like I said, when it was local, worked fine... now its not, doesn't work
fine...
=)
"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message
news:j5*******************@twister.tampabay.rr.com ... So, in the first development environment, it worked fine, Windows XP
pro, fine. Now I'm in my test environment, (VMWare 4.0 on my machien, VS.NET 2003) i keep getting an ODBCException on the Fill (using an ODBC Driver, ASCII, Tab deliniated, etc.) The message is
Message "ERROR [42S02] [Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'RTDXWRK.TXT'. Make sure the object exists and that you spell its name and the path name correctly." String
Yet it finds it in a few lines of code above. I have a directory window open, works fine. I have my connection string set in the web.config for the ODBC Ascii driver, thats fine. worked fine in the development environemtn, but now.. not dice.
Are you sure the source directory is right in the Connection String? The other thing is that sometimes in the ODBC Text Driver you are forced to specify what file extentions it should recognize (ie. TXT, ASC, etc...),
do you have that option (Click options, then is should show an extention
list)? ~ Jeremy
What OS are you running in VMW?
"CJ Taylor" <ct*****@mortonwelding.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... Hey Jeremy,
Yeah I got all that set right..
Like I said, when it was local, worked fine... now its not, doesn't work fine...
=)
"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message news:j5*******************@twister.tampabay.rr.com ... So, in the first development environment, it worked fine, Windows XP pro, fine. Now I'm in my test environment, (VMWare 4.0 on my machien,
VS.NET 2003) i keep getting an ODBCException on the Fill (using an ODBC
Driver, ASCII, Tab deliniated, etc.) The message is
Message "ERROR [42S02] [Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'RTDXWRK.TXT'. Make sure
the object exists and that you spell its name and the path name
correctly." String
Yet it finds it in a few lines of code above. I have a directory
window open, works fine. I have my connection string set in the web.config
for the ODBC Ascii driver, thats fine. worked fine in the development environemtn, but now.. not dice.
Are you sure the source directory is right in the Connection String?
The other thing is that sometimes in the ODBC Text Driver you are forced to specify what file extentions it should recognize (ie. TXT, ASC, etc...),
do you have that option (Click options, then is should show an extention list)? ~ Jeremy
Windows XP Pro...
"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message
news:zf*******************@twister.tampabay.rr.com ... What OS are you running in VMW? "CJ Taylor" <ct*****@mortonwelding.com> wrote in message news:%2****************@tk2msftngp13.phx.gbl... Hey Jeremy,
Yeah I got all that set right..
Like I said, when it was local, worked fine... now its not, doesn't work fine...
=)
"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message news:j5*******************@twister.tampabay.rr.com ... > So, in the first development environment, it worked fine, Windows XP pro, > fine. Now I'm in my test environment, (VMWare 4.0 on my machien, VS.NET > 2003) i keep getting an ODBCException on the Fill (using an ODBC Driver, > ASCII, Tab deliniated, etc.) > The message is > > Message "ERROR [42S02] [Microsoft][ODBC Text Driver] The Microsoft
Jet > database engine could not find the object 'RTDXWRK.TXT'. Make sure the > object exists and that you spell its name and the path name correctly." > String > > > Yet it finds it in a few lines of code above. I have a directory window > open, works fine. I have my connection string set in the web.config for the > ODBC Ascii driver, thats fine. worked fine in the development environemtn, > but now.. not dice.
Are you sure the source directory is right in the Connection String? The other thing is that sometimes in the ODBC Text Driver you are forced
to specify what file extentions it should recognize (ie. TXT, ASC,
etc...), do you have that option (Click options, then is should show an extention list)? ~ Jeremy
> When I do the SQL Query, from the SQL Designer window, and choose "run" I get data from my file. No problems right?
<Long-shot>
Could it be that the Query designer is locking the file? I guess you prolly
don't have that running in the VM though, do you? Could anything else be
locking the file?
~
Jeremy
Yeah, but its read only... I thought about it being the lcoking file from
the legacy system, but it doesn't lock that way, it uses a proprietary
function to lock the file (it creates antoher text file with a specific name
to check... but i am using the file system watcher class to tell me when the
file is written and closed...
like I said, works locally...
So, the drive is mapped, do you think that could be a problem? I'm trying
to implement it as a datareader right now..
-CJ
"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message
news:YN*******************@twister.tampabay.rr.com ... When I do the SQL Query, from the SQL Designer window, and choose "run"
I get data from my file. No problems right? <Long-shot> Could it be that the Query designer is locking the file? I guess you
prolly don't have that running in the VM though, do you? Could anything else be locking the file?
~ Jeremy
CJ
I know to less about ODBC and ASCI file to help you, but I have once
searched very long and after just a restart of the system it did work.
Maybe silly to say, but those things happens with me.
Cor
Alright,
Well here is the results of a few tests...
I did it on both my local machine and virtual machine... the problem is
definatly the shared drive from the fill command.
I also did it with a ODBCDataReader and achieved the same results. So...
now the question is, how to solve this problem.
My one thought is to basically copy the file to a local directory
(ExecutionPath?), and then execute the dataadapter.fill method. I think
that will cover it, I was just hoping that the driver didn't suck so bad.
I don't know.. anyoen else have some ideas/
-CJ
"Cor" <no*@non.com> wrote in message
news:3f***********************@reader20.wxs.nl... CJ I know to less about ODBC and ASCI file to help you, but I have once searched very long and after just a restart of the system it did work. Maybe silly to say, but those things happens with me. Cor
> So, the drive is mapped, do you think that could be a problem? I'm trying to implement it as a datareader right now..
Can you open the file with a TextStream? Maybe its a security issue...
~
Jeremy
OK...
Solution is to use DSNless connections. For some reason when Microsoft
creates a Server connection in the server manager to the form (component in
my case) it adds a buncha uneeded BS.
So I took it out, works great.
Peace,
CJ
"Cor" <no*@non.com> wrote in message
news:3f***********************@reader20.wxs.nl... CJ I know to less about ODBC and ASCI file to help you, but I have once searched very long and after just a restart of the system it did work. Maybe silly to say, but those things happens with me. Cor
Can you open the file with a text stream, or does this only happen when
using the Data objects?
"CJ Taylor" <no****@blowgoats.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl... Alright,
Well here is the results of a few tests...
I did it on both my local machine and virtual machine... the problem is definatly the shared drive from the fill command.
I also did it with a ODBCDataReader and achieved the same results. So... now the question is, how to solve this problem.
My one thought is to basically copy the file to a local directory (ExecutionPath?), and then execute the dataadapter.fill method. I think that will cover it, I was just hoping that the driver didn't suck so bad.
I don't know.. anyoen else have some ideas/
-CJ
"Cor" <no*@non.com> wrote in message news:3f***********************@reader20.wxs.nl... CJ I know to less about ODBC and ASCI file to help you, but I have once searched very long and after just a restart of the system it did work. Maybe silly to say, but those things happens with me. Cor
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Linda Lee |
last post by:
I purchased Visual Basic .NET version 2003 Standard
I first try to connect Visual Basic .NET 2003 Standard to SQL Server
2000 Personal edition. When I go into Visual Basic .NET under Server...
|
by: Ken Dopierala Jr. |
last post by:
Hi,
If I create a VB.Net solution in VS.Net can that solution be opened
using VB.Net 2003 IDE and visa-versa? Thanks! Ken.
|
by: spebola |
last post by:
I am using vb.net 2003 professional and I get the following results
when using the round method:
dim Amount as decimal = 180.255
Amount = Amount.Round(Amount, 2)
Amount now contains 180.25. ...
|
by: Howard Kaikow |
last post by:
Some time ago, there was a posting that described how to modify VB .NET 2003
project files so the source could be used in VB.NET 2002.
Involved changing version numbers for the framework in a few...
|
by: dlangell |
last post by:
I have NOT yet made the transition from VB 6 to VB.NET 2003. I know some of the general differences, but I'm not yet to the point where I would feel comfortable starting a new project in .NET. At...
|
by: George McCullen |
last post by:
I have an Outlook 2003 using Exchange Server 2003 Public Contacts Folder containing 20,000 Contacts. I am writing a VB .Net 2003 program that loops through all the contacts in a "for each oCt in...
|
by: Kelvin Tran |
last post by:
To whom it may concerns:
I have some questions about VB.net 2003 as listed below.
1.. How to print out VB.net design form?
2.. How to create a line graph (Strip chart) in VB.net 2003?
3.. Is...
|
by: amber |
last post by:
Hello,
I use Visual Studio .NET 2003 Professional version at work.
I'd like to buy .NET for my home PC.
All I use is VB.NET and I'd like to use ASP.NET eventually.
What kind of functionality etc...
|
by: remya1000 |
last post by:
i'm using VB.NET 2003.
Last time while i did a program in Vb.Net 2005, i use "Configuration". and i could read and write to that XML configuration file like the example below.
CODES:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |