|
instead of password=mypass it should be:Jet OLEDB:Database Password=mypass;
|
|
|
|
|
you will unlock this database .
if it was be created with another user,you will not use it.
|
|
|
|
|
I didn't get what you mean
do you mean the using this connection string ,only one user can open the database at the same time ?
|
|
|
|
|
Hi,
I need to extract data from a Btrieve database, only problem I get error 51 "Invalid Owner", i.e. the data-files have had the "owner name" property set, so without knowing this I am presently unable to open the data-files. Does anyone know of any utility or method which will enable me to read the "owner name" and thus allow me access?
|
|
|
|
|
During inserting records to the database, sometimes a blank record appears in the database.But none of records I insert is blank. What can I do?
stanley
|
|
|
|
|
Hi,
I am developping application in C# with MSAccess databases and whenever I create an OLE DB Connection, something fails. When I select the Jet 4.0 Provider, I get a E_FAIL on the Select command in the wizard. When I use a OBDC connector to connect to an existing DSN, I get some sort of error saying that the data isnt compatible. What method should I use to connect a c# app with a MSAccess local db using the wizard in VS.NET or maybe there is a way to do this without using ODBC. Thanks
Jean S. Paquet
// JS Paquet
cout << "Thank you all" << endl;
|
|
|
|
|
Hello.
I need a little help.
What is it about...
I have a project in Visual C++ in which im using ADO. So i import an ado dll like that :
#import "c:\Program Files\Common Files\system\ado\msado15.dll" no_namespace rename("EOF", "adoEOF")
its OK
But i need to use and AdoX
so in one help ( in MSDN ) i saw that code and i used in py project:
#import "c:\Program Files\Common Files\system\ado\msado15.dll"
#import "c:\Program Files\Common Files\system\ado\msadox.dll" no_namespace
Super, but it does not work:
--------------------Configuration: s - Win32 Debug--------------------
Compiling...
StdAfx.cpp
\my_source\s\debug\msado15.tlh(409) : warning C4146: unary minus operator applied to unsigned type, result still unsigned
\my_source\s\debug\msado15.tlh(1317) : error C2629: unexpected 'short ('
\my_source\s\debug\msado15.tlh(1317) : error C2238: unexpected token(s) preceding ';'
\my_source\s\debug\msadox.tlh(1201) : warning C4146: unary minus operator applied to unsigned type, result still unsigned
Error executing cl.exe.
s.exe - 2 error(s), 2 warning(s)
////////////////////////////////////
when i click on the error it goes to the source file on this line: VARIANT_BOOL EOF;
I tried various ways, to change places of the no_namespace rename("EOF", "adoEOF") è no_namespace
but there is no any result, just gives me other errors.
So if anyone knows how it would work ill be glad to tell me.
Thank you in advance.
|
|
|
|
|
|
hi,
I executed "EXEC sp_fulltext_database 'enable'" in the query analyser of sql 2000.I am getting the following error:
"Full-Text Search is not installed or a full-text component could not be loaded". Can anyone guide me how to fix this problem.how to install this full text component,atleast any site name or the url from where i can download.
Thanks for all in advance
|
|
|
|
|
It's on your SQL Server CD.
#include <beer.h>
|
|
|
|
|
Hi
I use asp , ado , AccessXP db to make an online registration system.
I created an Insert query in the Access database and call the query like this :
set con=Server.CreateObject("Adodb.Connection")<br />
con.ConnectionString = strCon<br />
con.CursorLocation = 2 'Server<br />
con.Open<br />
.<br />
.<br />
set cmd=Server.CreateObject("Adodb.Command")<br />
set cmd.ActiveConnection=con<br />
cmd.CommandText="InsertCustomer"<br />
cmd.CommandType=4'adCmdStoredProc <br />
cmd.Execute ,Array(n,Request("FirstName"),Request("LastName"), Request("Email")
it works fine on localhost .. but when I upload the asp , mdb and try it online i get the error :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/register/save.asp, line 62
can anyone help please ?
|
|
|
|
|
I don't know Access, but it sounds like the user account that the server ASP process runs under does not have write permissions on the .mdb file.
Change, or get the server admin to change, the permissions on the .mdb file to allow write access for the IUSER_* or IWAM_* accounts (I forget which).
Hope that helps.
Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron.
|
|
|
|
|
Okay.
I wanted to see if MSDE was cool and determined it was.
But I've got vs.net entp ed and figured i didn't need msde anymore.
I went to control panel and removed msde.
NOW, when i run the service manager, it says
"service unavailable" or something like that...
What do i do??? Are my databases toasted now?
If someone can give me a hand, I'd -reallllly- appreciate it..
Thanks.
Oops - forgot to say I'm on XP home edition with SqlServer 2000.
...Steve
|
|
|
|
|
Steve Hazel wrote:
What do i do??? Are my databases toasted now?
If you still have the .mdf (and .ldf, not sure if these are important) files, you should be able to reattach them to an existing database instance. Look up the sp_attach_db system stored proc. You could probably do this via Enterprise Manager too.
I'm not sure what the Service Control manager is complaining about. It may be looking for a particular SQL Server instance (machinename\instance).
Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron.
|
|
|
|
|
MSDE is a limited Version of SQL Server and it is actually the same service called MSSQLSERVER
Check in Services Control Panel if there is a MSSQLSERVER service running and if it shows to correct path.
It can be that you will have to reinstall SQL Server
Marek
|
|
|
|
|
Hi everyone,
I am using the "Microsoft OLEDB provider for Microsoft Jet" through ADO and everything is going fairly well, except for the processing of provider errors....
The problem is that I can detect them ok, but I need to do specific things depending on which error occurs, which is obvious, however I am having a major hard time trying to find out what errors can be thrown by the provider.
Does anyone know where I can find a list of the error codes that can be issued by the above provider, the ones I have found (through trial and error) are:
// JET Error codes returned through ADO (Provider Errors)
0xDFBAF18A
An attempt to update a field with a zero-length string when the field does NOT support it
0xDFF8F252
Systax error in INSERT INTO statement
0xE004FBFC
Unrecognized database format
0xE0BBF3E4
Syntax error (missing operator) in query expression
0xF9BBF9BB
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.
I get these error codes consistantly, but do they look wrong to anyone ? I am suspicous as when I do a search for any of them on the internet, it comes up blank everytime.
regards,
Jonathan
|
|
|
|
|
Hi there!
how I can find out why ExecuteNonQuery() return 0 and not 1 by submit?
at this moment I see no chance to know why my query isn't submited.
thx
gicio
|
|
|
|
|
gicio wrote:
how I can find out why ExecuteNonQuery() return 0 and not 1 by submit?
at this moment I see no chance to know why my query isn't submited.
Per MSDN:
For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.
SqlCommand.ExecuteNonQuery Method[^]
-Nick Parker
|
|
|
|
|
Does anyone know how to programatically change the password of a SQL database using VB.Net?
Regards
BusterG
|
|
|
|
|
Execute the sp_password system stored proc to change the password for a SQL Server login.
Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron.
|
|
|
|
|
|
Is this possible with SQL/Access? If so, how?
Thanks for your help!
---------------
Tired of Spam? Introducing InboxShield® for Microsoft® Outlook®
http://www.edovia.com
|
|
|
|
|
I don't know about Access, but SQL Server 2000 lets you specify the collation for comparisons. For example, for a general case-sensitive / accent-sensitive search, try:
SELECT *
FROM TableName
WHERE Description = 'A Description'
COLLATE SQL_Latin1_General_CP1_CS_AS To get a list of available collations, execute:
SELECT * FROM ::fn_helpcollations()
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Hello,
I have a problem that i cannot solve.
The problem shows up in XP, the code works fine in 98SE
Please if you know the answer help me
The code:
conITEMS.Open "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=" & "D:\work\old"
rsITEMS.CursorLocation = adUseClient
rsITEMS.Open "SELECT * FROM STOCK", conITEMS, adOpenStatic, adLockPessimistic
rsITEMS.MoveFirst
rsITEMS.Find ("number = '2004'")
This is where it fails with error = Run-time error '2147467259 (80004005)'
"data provider or other service returned an E_FAIL status"
Thank you in advance
Ilya 
|
|
|
|
|
Hi
It is probably because VFP Drivers are not included in MDAC 2.6 and above.
You can download this drivers from Microsoft Visual FoxPro page. Here is the link
http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp
Greeting
Marek
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
