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  5547 
> 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.cowle s[nosp@m]asifl.com> wrote in message
news:j5******** ***********@twi ster.tampabay.r r.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*****@morton welding.com> wrote in message
news:%2******** ********@tk2msf tngp13.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.cowle s[nosp@m]asifl.com> wrote in message
news:j5******** ***********@twi ster.tampabay.r r.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.cowle s[nosp@m]asifl.com> wrote in message
news:zf******** ***********@twi ster.tampabay.r r.com... What OS are you running in VMW?
"CJ Taylor" <ct*****@morton welding.com> wrote in message
news:%2******** ********@tk2msf tngp13.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.cowle s[nosp@m]asifl.com> wrote in message
news:j5******** ***********@twi ster.tampabay.r r.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.cowle s[nosp@m]asifl.com> wrote in message
news:YN******** ***********@twi ster.tampabay.r r.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.fil l 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.n l... 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 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
Explorer and try to add the connection, I received the following
message "Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine databases and Microsoft Access
Databases with this version of Visual Studio."
Then...
|
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. I need it to contain 180.26.
Any ideas?
|
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 files.
Any pointers to documentation on how to do this?
--
http://www.standards.com/; See Howard Kaikow's web site.
|
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 any rate, I was going to get some books and begin learning more about it and try to make the jump, but then I see that Whidbey or VS.NET 2005 will be coming out in the next year or so.
How different is this new release going to be from VB.NET 2003?...
| | |
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 oItems" loop. After about 250 contacts, the program gives an InvalidCastException Error on the for each loop. I notice that Outlook's memory keeps increasing (using the task manager) until it reaches around 20,000K. When I run the program a second...
|
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 there any line graph component in VB.net?
4.. If so, how do I add to the VB.Net toolbox?
Thank you very much for all your help. I look forward to hearing you soon.
|
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 will I lose if I simply buy VB.NET 2003
Standard edition?
What are some of the differences between the full VS version and the VB
standard edition?
Thanks,
Amber
|
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:
Imports System.Configuration
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
