Hi everbody,
Getting this strange error all of a sudden.
Microsoft OLE DB Provider for ODBC Drivers. error 80040e21
ODBC driver doesn't support the requested properties.
and the line is:
tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" & vValue
& "'", oConn, adOpenKeyset, adLockReadOnly
I'm using vbscript and this was working before I changed some tables and
relationships, which should not affect the above line though.
Any ideas?
Ivan 4 1887
As always. put your SELECT statement into a variable first, then
response.write the variable to veryify syntax
Or just hardcode a simpler SELECT statment, and verify that it's working.
Jeff
"Ivan Debono" <iv******@hotma il.com> wrote in message
news:Oa******** ******@TK2MSFTN GP11.phx.gbl... Hi everbody,
Getting this strange error all of a sudden.
Microsoft OLE DB Provider for ODBC Drivers. error 80040e21 ODBC driver doesn't support the requested properties.
and the line is:
tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" &
vValue & "'", oConn, adOpenKeyset, adLockReadOnly
I'm using vbscript and this was working before I changed some tables and relationships, which should not affect the above line though.
Any ideas?
Ivan
The SQL statement is correct.
When I remark from adOpenKeySet onwards I get an error that I don't have
read permissions on the table. Locally I'm using a different MDW than the
standard one, but I gave read permissions to the users group on all tables.
Ivan
"Jeff Dillon" <je**@removeeme rgencyreporting .com> schrieb im Newsbeitrag
news:uQ******** ******@TK2MSFTN GP10.phx.gbl... As always. put your SELECT statement into a variable first, then response.write the variable to veryify syntax
Or just hardcode a simpler SELECT statment, and verify that it's working.
Jeff "Ivan Debono" <iv******@hotma il.com> wrote in message news:Oa******** ******@TK2MSFTN GP11.phx.gbl... Hi everbody,
Getting this strange error all of a sudden.
Microsoft OLE DB Provider for ODBC Drivers. error 80040e21 ODBC driver doesn't support the requested properties.
and the line is:
tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" & vValue & "'", oConn, adOpenKeyset, adLockReadOnly
I'm using vbscript and this was working before I changed some tables and relationships, which should not affect the above line though.
Any ideas?
Ivan
What database are you using? If file based, set Everyone Full Control on the
directory where it resides, as a test, as well as your TEMP/TMP directories
Jeff
"Ivan Debono" <iv******@hotma il.com> wrote in message
news:ug******** ******@TK2MSFTN GP10.phx.gbl... The SQL statement is correct.
When I remark from adOpenKeySet onwards I get an error that I don't have read permissions on the table. Locally I'm using a different MDW than the standard one, but I gave read permissions to the users group on all
tables. Ivan
"Jeff Dillon" <je**@removeeme rgencyreporting .com> schrieb im Newsbeitrag news:uQ******** ******@TK2MSFTN GP10.phx.gbl... As always. put your SELECT statement into a variable first, then response.write the variable to veryify syntax
Or just hardcode a simpler SELECT statment, and verify that it's
working. Jeff "Ivan Debono" <iv******@hotma il.com> wrote in message news:Oa******** ******@TK2MSFTN GP11.phx.gbl... Hi everbody,
Getting this strange error all of a sudden.
Microsoft OLE DB Provider for ODBC Drivers. error 80040e21 ODBC driver doesn't support the requested properties.
and the line is:
tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" & vValue & "'", oConn, adOpenKeyset, adLockReadOnly
I'm using vbscript and this was working before I changed some tables
and relationships, which should not affect the above line though.
Any ideas?
Ivan
It's working again :)
"Jeff Dillon" <je**@removeeme rgencyreporting .com> schrieb im Newsbeitrag
news:Os******** ******@TK2MSFTN GP14.phx.gbl... What database are you using? If file based, set Everyone Full Control on the directory where it resides, as a test, as well as your TEMP/TMP directories
Jeff "Ivan Debono" <iv******@hotma il.com> wrote in message news:ug******** ******@TK2MSFTN GP10.phx.gbl... The SQL statement is correct.
When I remark from adOpenKeySet onwards I get an error that I don't have read permissions on the table. Locally I'm using a different MDW than the standard one, but I gave read permissions to the users group on all tables. Ivan
"Jeff Dillon" <je**@removeeme rgencyreporting .com> schrieb im Newsbeitrag news:uQ******** ******@TK2MSFTN GP10.phx.gbl... > As always. put your SELECT statement into a variable first, then > response.write the variable to veryify syntax > > Or just hardcode a simpler SELECT statment, and verify that it's working. > > Jeff > "Ivan Debono" <iv******@hotma il.com> wrote in message > news:Oa******** ******@TK2MSFTN GP11.phx.gbl... >> Hi everbody, >> >> Getting this strange error all of a sudden. >> >> Microsoft OLE DB Provider for ODBC Drivers. error 80040e21 >> ODBC driver doesn't support the requested properties. >> >> and the line is: >> >> tRST.Open "SELECT id FROM " & sTable & " WHERE " & sField & " = '" & > vValue >> & "'", oConn, adOpenKeyset, adLockReadOnly >> >> I'm using vbscript and this was working before I changed some tables and >> relationships, which should not affect the above line though. >> >> Any ideas? >> >> Ivan >> >> > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: avihay |
last post by:
Hello,
Using .NET 1.1 and MS visual studio 2003 we are failing to
close an ODBC Connection to an ODBC driver using
system.data.odbc.
We are getting the following Error from the Microsoft odbc
driver manager :
"DIAG Invalid
transaction state (0).
We understood that this Error message has to do with
|
by: simianphile |
last post by:
OK, I had a problem that I've now fixed but I can't really understand
what was causing it in the first place. I have an intranet site that
uses basic authentication to allow users to view and update information
from an Oracle DB (ver 8.1.6 -- ancient, I know). Anyway, the site
worked fine as long as the machine accessing the ASP page was...
|
by: uli2003wien |
last post by:
Dear group,
we are dealing with some very specific problems with ODBC, where a
connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00
and does NOT work with ODBC-driver 3.51.11.00. Maybe someone
experiences similar problems or even has a solution ? Some feedback (to
the group) would be highly appreciated.
We use a...
|
by: Andrew McGregor |
last post by:
Hi,
I am trying to get a VB.NET application to connect to a local Oracle 9i Lite
database.
What is the correct form for a connect string?
cn = New
Microsoft.Data.Odbc.OdbcConnection("dsn=POLite;Trusted_Connection=yes;User
Id=SYSTEM;Password=MANAGER")
|
by: bazzer |
last post by:
hey,
i am using visual basic.net 2003 and have an ASP.NET webform
application thats accessing a microsoft access 2003 database. i kept
getting the following error when i tried to run it:
ERROR General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR Driver's...
| |
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in '/CinemaBookingSystem' Application.
--------------------------------------------------------------------------------
ERROR General error
Unable to open registry...
|
by: Greg Strong |
last post by:
Hello All,
Is there any way to close an ODBC connection via DSN without completely
closing the Access front-end?
I'm doing some testing with using Access as a front-end to Oracle 10g
Express edition. When the user ID and password is entered on a form and
after a successful connection it seems Access doesn't change the
connection. Even if...
|
by: Greg Strong |
last post by:
Hello All,
The short questions are
1 Do you know how to make DSN connection close in Access to Oracle 10g
Express Edition?
&/or
2 Do you know how to make a DSN-less pass-through query work from
|
by: zombiechewtoy |
last post by:
I'm having trouble making an ODBC connection using VB.NET 2005. I have tried nearly every connection string found on connectionstrings.com, in almost every format I can think of.
I have tried both of the following drivers, as well.
Oracle ODBC Driver (version 8.01.05.00)
Microsoft ODBC for Oracle
Basically, I end up with the same generic...
|
by: sudhaoncyberworld |
last post by:
Dear Techies,
I do have small issue on connecting oracle server
from .net
This is the code snippet
public string strConString = "Driver={Microsoft ODBC for
Oracle};Server=myserver;Uid=system;Pwd=mypwd;";
|
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...
| |
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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.
| |