Database Discussion Boards

Re: Issue with VS 2005

itsravie16-Mar-09 23:38

16-Mar-09 23:38

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!

ms access connection string

vishakpb16-Mar-09 21:32

vishakpb

16-Mar-09 21:32

plz giv me the connection string to connect ms access database in asp.net web page

Re: ms access connection string

Eddy Vluggen16-Mar-09 21:55

Eddy Vluggen

16-Mar-09 21:55

Look here[^] for connection-strings.

plz = Please
giv = give

I are troll Smile | :)

Re: ms access connection string

itsravie16-Mar-09 23:41

itsravie

16-Mar-09 23:41

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!

saving data

neoghy16-Mar-09 4:08

neoghy

16-Mar-09 4:08

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

For Oracle

David Mujica16-Mar-09 4:57

David Mujica

16-Mar-09 4:57

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[^]

Re: saving data

RussellT5-Jun-09 10:07

RussellT

5-Jun-09 10:07

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

Sql Restore Error

kankeyan16-Mar-09 3:53

kankeyan

16-Mar-09 3:53

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

Re: Sql Restore Error

RyanMorris16-Mar-09 6:02

RyanMorris

16-Mar-09 6:02

Hi JK,

It looks to me like you client is using SQL 2005, which isn't backwards compatible with SQL 2000.

Ryan

Re: Sql Restore Error

kankeyan16-Mar-09 19:22

kankeyan

16-Mar-09 19:22

is it possible to convert sql 2005 database to sql 2000 sp4

Re: Sql Restore Error

RyanMorris16-Mar-09 22:57

RyanMorris

16-Mar-09 22:57

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.

When MSAccess Readonly database with password is opened error 0xfffff88f "Not a valid password". Who knows why?

Grebeshkova16-Mar-09 0:48

Grebeshkova

16-Mar-09 0:48

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

SQL Question

Lars Fisker15-Mar-09 13:51

Lars Fisker

15-Mar-09 13:51

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)

Re: SQL Question

Mycroft Holmes15-Mar-09 14:05

Mycroft Holmes

15-Mar-09 14:05

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

Re: SQL Question

Lars Fisker15-Mar-09 14:48

Lars Fisker

15-Mar-09 14:48

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)

Re: SQL Question

Blue_Boy16-Mar-09 2:01

Blue_Boy

16-Mar-09 2:01

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")/*give yout date format*/);

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.

How to Store password character in Oracle Table

Saleem Tahiri15-Mar-09 1:23

Saleem Tahiri

15-Mar-09 1:23

I want to store string character to be stored as password in Oracle table.

Re: How to Store password character in Oracle Table

Eddy Vluggen15-Mar-09 2:09

Eddy Vluggen

15-Mar-09 2:09

Sounds like you want to store the password similar to "*****" into Oracle?

I are troll Smile | :)

Re: How to Store password character in Oracle Table

Saleem Tahiri15-Mar-09 2:12

Saleem Tahiri

15-Mar-09 2:12

Yes the password needs to be stored "*****" or any other format in Oracle

Re: How to Store password character in Oracle Table

Saleem Tahiri15-Mar-09 2:12

Saleem Tahiri

15-Mar-09 2:12

Yes the password needs to be stored "*****" or any other format in Oracle

Re: How to Store password character in Oracle Table

Eddy Vluggen15-Mar-09 2:21

Eddy Vluggen

15-Mar-09 2:21

Then how are you going to read the password once you need it? It would return ******, for each and every record in your database Frown | :(

What you are seeing on your screen isn't the same as what one would store in a database. You might want to consider encrypting[^] the string before you send it to a database. It would be preferable to store a hash-value based on the password; you'd calculate an unique number based on the string, and store that. Then, when the user logs in, you compare a new calculation with the number that you stored Smile | :)

I are troll Smile | :)

Access [modified]

udikantz14-Mar-09 19:52

udikantz

14-Mar-09 19:52

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

Datetime?

Karthick_gc13-Mar-09 0:03

Karthick_gc

13-Mar-09 0:03

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?

Re: Datetime?

Eddy Vluggen13-Mar-09 0:22

Eddy Vluggen

13-Mar-09 0:22

Something like this?

DECLARE @d1 DATETIME = '12/19/2007 13:43:23.45', @t1 TIME(2)
SELECT @t1 = @d1
SELECT TimeOnly = @t1

I are troll Smile | :)

Re: Datetime?

Ashfield13-Mar-09 2:15

Ashfield

13-Mar-09 2:15

Try this

select convert(varchar(8),getdate(),114)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.