Database Discussion Boards

Re: System.Data.SQlClient.SQlException

Vimalsoft(Pty) Ltd11-Jun-07 20:29

Vimalsoft(Pty) Ltd

11-Jun-07 20:29

Thank you man

Vuyiswa

Oracle DBF export

Vertyg011-Jun-07 2:40

Vertyg0

11-Jun-07 2:40

I have oracle DBF files and I would like to know if there is any way to export data from them?
I`m MSSQL user and I don`t know much about oracle .. I have just few DBF files and one ORA file and I don`t know how to export data from them.
Any help appreciated.

Thanks,
Ivan

Re: Oracle DBF export

andyharman11-Jun-07 6:24

andyharman

11-Jun-07 6:24

Hi Ivan

You would need to install Oracle (you may be able to get away with the Express edition), then attach the DBF files. Once you have an Oracle database up-and-running then you can use DTS or SSIS to transfer the data to your SQL-Server instance.

If you have access to an Oracle DBA then you will save yourself a bunch of time.

Otherwise you may find that one of the Oracle-specific forums will be able to provide more detailed advice on attaching Oracle databases - just don't tell them that you intend to rip the data in SQL-Server cos that will seriously hurt their feelings Wink | ;)

Regards
Andy

Re: Oracle DBF export

Vertyg011-Jun-07 7:21

Vertyg0

11-Jun-07 7:21

Andy thank you for instructions ! Smile | :)

I have had same thinking as you ... so I have started downloading oracle 10g express and SQL developer. Any forums you would recommend ?
Thanks allot!

Re: Oracle DBF export

andyharman11-Jun-07 23:06

andyharman

11-Jun-07 23:06

I've never used any Oracle forums - but if I did then Ask Tom[^] would be the first place I would look.

Good luck.

Re: Oracle DBF export

RussellT5-Jun-09 9:17

RussellT

5-Jun-09 9:17

This is old, but I couldn't resist.

Instead of getting his technical input from forums or even from Tom Kyte, he should be doing what Tom himself would say--RTFM!

Kind regards,
Russ

Any work arounds for getting rid of Process Blocking in SQL2000

Jayaraman B10-Jun-07 23:37

Jayaraman B

10-Jun-07 23:37

Dear Team,

We face the issue of Process Blocking in SQL2000 very often which leads to the show stopper of the application for which we will have to kill the Process manually , is there any was to find why the Process blocking in SQL coz of the application or is there any other work around to fix this issue.

Thanks & Regards,
Jayaraman B

Jayaraman B

Re: Any work arounds for getting rid of Process Blocking in SQL2000

andyharman10-Jun-07 23:55

andyharman

10-Jun-07 23:55

Do you mean that SQL sessions are blocking on other user's sessions because of locking?

This can be detected using the "sp_who2" stored procedure. The normal ways of reducing lock contention are:

Keep your transactions short.
Check your "isolation level". Some frameworks use the "serializable" isolation - which severely impacts concurrency.
For reports, consider using "read uncommitted" isolation.
If your transactions access multiple tables then try to update tables in the same sequence.

Hope that helps. This artical[^] may help.

Regards
Andy

[Message Deleted]

Brendan Vogt10-Jun-07 22:31

Brendan Vogt

10-Jun-07 22:31

[Message Deleted]

Re: SELECT Not Working

SimulationofSai10-Jun-07 22:49

SimulationofSai

10-Jun-07 22:49

ma se wrote:
AND tblProduct.Status = 1

should be changed to

WHERE tblProduct.Status = 1

Re: SELECT Not Working

Harini N K10-Jun-07 22:49

Harini N K

10-Jun-07 22:49

ma se wrote:
AND tblProduct.Status = 1

Remove it and add it in where clause.

Harini

Re: [Message Deleted]

Colin Angus Mackay11-Jun-07 0:30

Colin Angus Mackay

11-Jun-07 0:30

Don't delete the original question - It is rude and does not help people that may have a similar problem and are searching the forum.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

how to write table in sql server 2000

tauras8110-Jun-07 22:30

tauras81

10-Jun-07 22:30

hi ,

i want to make table hints for fastfirstrow what is the syntax for the same

Re: how to write table in sql server 2000

andyharman10-Jun-07 23:58

andyharman

10-Jun-07 23:58

select x, y from a
order by x
option (fastfirstrow)

Note that the "option(fast n)" is preferred under SQL2000 (where "n" is the number of rows).

Database Help [modified]

ASPnoob10-Jun-07 21:29

ASPnoob

10-Jun-07 21:29

Hi I am new to database design and I would like your opinions on my database. I am creating a database to hold website member info. In my register page I ask users who wish to become members to supply the following infos.

First Name, Last Name, Profession, Address, City, State, Zip, Phone Number, Email, User Name, Password

From the info above, I've created a database called Members, a table called Users, and another table called ContactInfo.

 Users          ContactInfo
_______________              ___________________
|UserID        |             |Email            |      
_______________              ___________________
|Email         |             |Phone            |      
_______________              ___________________
|FirstName     |             |Address          |        
_______________              ___________________
|LastName      |             |City             |    
_______________              ___________________
|UserName      |             |State            |
_______________              ___________________
|Password      |             |Zip              |
_______________              ___________________

Do you see any problem with the above database? Please point out any problems that you see. Thank you in advance for your help.

-- modified at 3:43 Monday 11th June, 2007

Re: Database Help

Giorgi Dalakishvili10-Jun-07 21:40

Giorgi Dalakishvili

10-Jun-07 21:40

The two tables aren't linked to each other. How will you retrieve user's contact info given his/her userID?

my articles

Re: Database Help

Harini N K10-Jun-07 22:29

Harini N K

10-Jun-07 22:29

Hi
1. Why two tables?

2. Are you storing more than 1 record in ContactInfo table for a particular user?

3. If you are storing more than 1 contact Info, link should be maintained between those two tables. Users table should have one more column i.e., UserID to maintain unique row. This column should be added to ContactInfo Table so that you can retrieve contact details based on UserID.

See definitions of Normalization for more information. There are three normal forms in database design.

For best example, have a look at Orders and Order Details tables of Northwind database and check the common column between these two table.

Harini

Re: Database Help

Sankar Komma 13-Jun-07 11:45

Sankar Komma

13-Jun-07 11:45

hi,
Database is correct use userid for relation more than email id.
it is preferable in database.

k.ravi sankar

Count related records

Soleil couchant10-Jun-07 20:24

Soleil couchant

10-Jun-07 20:24

Hi there,

I have a stock table and a barcode table. A stock can have many barcode records and a barcode belongs to only one stock.

How can I query the database, so as it returns me those stock which have more than one barcode?

Thanks for helping,

David

Re: Count related records

andyharman10-Jun-07 22:22

andyharman

10-Jun-07 22:22

select StockCode, count(*) BarcodeCount
from BarCode
group by StockCode
having count(*) > 1

user mysql [modified]

WhiteGirl2310-Jun-07 19:22

WhiteGirl23

10-Jun-07 19:22

Hi,
I use mysql on my project and I can connect to mysql with my IP,this is a good thing.
But the problem is that I can't create a user.
My sintax is:

cmd1.CommandText = "GRANT ALL PRIVILEGES ON test .* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;"<br />
cmd1.ExecuteNonQuery()<br />
<br />
cmd1.CommandText = "flush privileges;"<br />
cmd1.ExecuteNonQuery()<br />

The problem is that when I connect to mysql with localhost this command works and when I connect with my IP it doesn't work.

Thank .

Re: user mysql

ScottM110-Jun-07 21:23

ScottM1

10-Jun-07 21:23

The error doesn't appear to be anything to do with the above command as it works with localhost.

WhiteGirl23 wrote:
I use mysql on my project and I can connect to mysql with my IP,this is a good thing.

Can you execute any command at all when using your IP? e.g A simple select statement.

WhiteGirl23 wrote:
it doesn't work.

What does it do when it doesn't work? Does it throw any exception?

There are 10 types of people in the world, those who understand binary and those who dont.

Re: user mysql

Paddy Boyd11-Jun-07 2:48

Paddy Boyd

11-Jun-07 2:48

What user are you connecting to the DB with?

Re: user mysql

WhiteGirl2311-Jun-07 20:56

WhiteGirl23

11-Jun-07 20:56

Now it works.
I found a sql command for creating user which works with IP and localhost.

Thanks

I want help on Sql query

Parameswar Mal10-Jun-07 2:07

Parameswar Mal

10-Jun-07 2:07

Hi Friends I have a problems
I have a table Employee
two fields Name, Age
Name Datatype is varchar()
Age Datatype is Int()
the table look likes this
Name.........Age
Ram.............23
Steve............22
when i swap this two fields using this query"update Employee set Age = Ename,Ename=Age;'
then the error occured
error is "Syntax error converting the varchar value 'Ram' to a column of data type int."

If i changed the datatype of Age is "Int" to "Varchar" then the query runs.
My question is if i don't changed the datatype then how i swap the two fields
Plz help me....

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