|
If you are still using the Access front-end, just pass the text as a parameter to the VBA FollowHyperlink function and it will open.
|
|
|
|
|
Hi,
When i installed Rational clearcasetool and restarted system..and when im trying to build my vc++ application in VS 2005 im able to see the below error..
error result returned from 'cl.exe'.
Please help me out..
|
|
|
|
|
This error is due to improper setup of VS or OS update problem.
It also comes when u install windows update patch KB925902. try uninstalling, if u hav one.
Ravie Busie
Coding is my birth-right and bugs are part of feature my code has!
|
|
|
|
|
plz giv me the connection string to connect ms access database in asp.net web page
|
|
|
|
|
Look here[^] for connection-strings.
plz = Please
giv = give
I are troll
|
|
|
|
|
Dim strConn as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath(".\northwind.mdb") & ";"
Ravie Busie
Coding is my birth-right and bugs are part of feature my code has!
|
|
|
|
|
Hi everybody
Actually i created a table in sql+, and inserting data using sql+ itself.But after i log out off the screen and log in again i see the data gone. How can i prevent the data from getting vanished without writing commit or set autocommit commands on everytime.
skd
|
|
|
|
|
During interactive usage with sqlplus, Oracle also supports an AUTOCOMMIT option. With this option set to ON each individual SQL statement is treated as a transaction an will be automatically commited right after it is executed. A user can change the AUTOCOMMIT option by typing
SET AUTOCOMMIT ON or
SET AUTOCOMMIT OFF
whereas by typing
SHOW ALL
a user can see the current setting for the option (including other ones).
This was taken from the website:
http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html[^]
|
|
|
|
|
neoghy wrote: How can i prevent the data from getting vanished without writing commit or set autocommit commands on everytime.
This is like asking how I can eat my cake without opening my mouth.
Cheers,
Russ
|
|
|
|
|
Dear Friends,
Client database is in the form of "database.Dat" they don't which version they are using, i want to restore it i sqlserver 2000 with service pack 4
Following error occured
Error:3169 The backed up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally.
Please give a solution
Thanks & Regards
JK
|
|
|
|
|
Hi JK,
It looks to me like you client is using SQL 2005, which isn't backwards compatible with SQL 2000.
Ryan
|
|
|
|
|
is it possible to convert sql 2005 database to sql 2000 sp4
|
|
|
|
|
Just using the file you have, not as far as I know. If you had access to the database, I'm told that you could export the data from SQL 2005 and then import it into SQL 2000, but I haven't done this before and so I can't really tell you exactly how to go about it.
|
|
|
|
|
For open database *.mdb I use ADO-construction
try
{
hr = m_pConnection->Open(_bstr_t(lpstrConnection), _bstr_t(lpstrUserID),
_bstr_t(lpstrPassword), NULL);
return hr == S_OK;
}
catch(_com_error &e)
{
}
When mdb-file has not attribute "ReadOnly", Open returns S_OK.
But when I set this attribute, exception is generated with
ErrorNumber = 0x80004005 and NativeError = 0xfffff88f ("Not a valid password").
I don't undenstand why. Pls., explain me this situation.
And other question: what are error codes concerned with error password (for ODBC and SQL-Server)? Or in other words: How may I detected that in connection string invalid password for opened database?
Thanks
|
|
|
|
|
Can someone answer why the following isnt returning anything?
string strGetPeriodeSQL = String.Format("SELECT * FROM {0} WHERE SDate BETWEEN {1} AND {2} ORDER BY SDate", strTableName, dtStart.ToShortDateString(), dtEnd.ToShortDateString());
I left out the rest of the funktion, just the SQL part is here.
Lars
Resistance is futile - Data (ST:First Contact)
|
|
|
|
|
Are you saying strGetPeriodeSQL does not get populated?
Does the SQL string not execute?
Is no data returned from SQL?
I suspect the latter so:
Take the content of strGetPeriodeSQL to Management Studio and see what the results are.
If you get results then there is a problem with your connection.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks for the answer. But I figured out what was wrong. Insted of converting to ShortDateString I needed to convert to ToOADate.
Sorry for the trouble.
Lars
Resistance is futile - Data (ST:First Contact)
|
|
|
|
|
or you can use this way:
<br />
string strGetPeriodeSQL = String.Format("SELECT * FROM {0} WHERE SDate BETWEEN {1} AND {2} ORDER BY SDate", strTableName, dtStart.ToString("yyyy.MM.dd"), dtEnd.ToString("yyyy.MM.dd"));
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I want to store string character to be stored as password in Oracle table.
|
|
|
|
|
Sounds like you want to store the password similar to "***** " into Oracle?
I are troll
|
|
|
|
|
Yes the password needs to be stored "*****" or any other format in Oracle
|
|
|
|
|
Yes the password needs to be stored "*****" or any other format in Oracle
|
|
|
|
|
|
hi guys,
i am developing an application which uses access mdb files as database.
untill now i used a connection to the files,
using the following code:
Public Class DBconnector
Private _dbConnection As OleDbConnection
Private _dbCommand As OleDbCommand
Private _dbDataReader As OleDbDataReader
Private _dbDataAdapter As OleDbDataAdapter
Private _dbTransaction As OleDbTransaction
'Private _dbADODBConnection As ADODB.
Public Sub New(ByVal cs As String)
_dbConnection = New OleDbConnection(cs)
_dbCommand = _dbConnection.CreateCommand
End Sub
where the connection string is:
"Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=" & TextEditPath.Text
texteditpath is the file path and name.
recently i have encountered an error while trying to create a relationship using "ON DELETE CASCADE" in the constraint clause.
error mentioned theres a syntax error on the constraint clause and there was no real syntax error , after troling microsoft forums , they have told me i need to use ADO connection because this bug results cause of use in DAO ,
also i may add that when i execute the query in the imidiate debug widow of access 2007 it is executed with no errors , how ever when i execute it on the SQL design window of access 2007 i get the same error as i get in the .net frame work
my question is how do i establish an ADO connection to access MDB file
or how do i over come this bug ,
please help im stuck with this for a week now ,
thanks...
Net
modified on Tuesday, March 17, 2009 4:09 AM
|
|
|
|
|
Hi, I am using SQL in my project. I want to fetch only time alone. i know to fetch Date. How to fetch time? Can any one tell?
|
|
|
|