Database Discussion Boards

Re: How to delete data from database

Jörgen Andersson12-Dec-09 10:38

Jörgen Andersson

12-Dec-09 10:38

Mycroft Holmes wrote:
When he comes back with "I can't truncate the table", you can try explaining foreign keys

Or Cascade. Poke tongue | ;-P

remote mysql server connection problem?

hande5410-Dec-09 8:05

hande54

10-Dec-09 8:05

Hi!
I need to connect remote mysql server and get the data. But I could not succeed it. I use reel IP address as serverIpAddress
MySqlConnection CN = new MySqlConnection("server=serverIPaddress;Port=3306; user=root; password=test; database=dbtest;");

Also I update my nat table to forward connections. But I get this error

A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll

Could you help me on this issue?

Re: remote mysql server connection problem?

Blue_Boy10-Dec-09 9:08

Blue_Boy

10-Dec-09 9:08

Have you search on google for that error?[^]

http://www.connectionstrings.com/[^]

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.

www.aktualiteti.com

Re: remote mysql server connection problem?

hande5410-Dec-09 9:18

hande54

10-Dec-09 9:18

Yes. I have searched but I could not overcome this problem. It is not related with the string that I use. It is totaly about configuration settings on mysql.

Re: remote mysql server connection problem?

Eddy Vluggen10-Dec-09 10:30

Eddy Vluggen

10-Dec-09 10:30

Is that a database on your LAN, or is it located somewhere else? (e.g., a database from a webhosting company?)

I are Troll Suspicious | :suss:

Re: remote mysql server connection problem?

hande5411-Dec-09 0:10

hande54

11-Dec-09 0:10

Database is on another machine that is not in my LAN.

Re: remote mysql server connection problem?

Eddy Vluggen11-Dec-09 2:07

Eddy Vluggen

11-Dec-09 2:07

Then chances are that there's a firewall. Second thing to check would be if MySQL accepts remote connections - those are disabled by default[^], for security reasons.

I are Troll Suspicious | :suss:

How to update records of a table automatically based on date

Krishhhhhhhhhhhhhh10-Dec-09 7:05

Krishhhhhhhhhhhhhh

10-Dec-09 7:05

Am using MS sql server 2005 database.

Table has 3 columns:
1)Id
2)Status
3)ExpireDate

If Expire Date is today then status has to become false otherwise true.
It has to done automatically. How to do it?

Please help me

Re: How to update records of a table automatically based on date

Bassam Saoud10-Dec-09 8:37

Bassam Saoud

10-Dec-09 8:37

Create a sql job[^]

How to send an auto mail

Krishhhhhhhhhhhhhh10-Dec-09 7:00

Krishhhhhhhhhhhhhh

10-Dec-09 7:00

I am working with asp.net and MS sql server 2005. I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".

Please help me

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:22

Richard MacCutchan

10-Dec-09 7:22

This was already answered in the ASP.NET forum. Please do not spam.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:28

Krishhhhhhhhhhhhhh

10-Dec-09 7:28

Not Fully answered. OK

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:34

Richard MacCutchan

10-Dec-09 7:34

Krishhhhhhhhhhhhhh wrote:
Not Fully answered. OK

So wait until it is, please do not crosspost.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:43

Krishhhhhhhhhhhhhh

10-Dec-09 7:43

Stop this bloody replies and do ur job perfectly. otherwise close ur forums

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 7:53

Richard MacCutchan

10-Dec-09 7:53

Krishhhhhhhhhhhhhh wrote:
Stop this bloody replies and do ur job perfectly. otherwise close ur forums

This sort of language is not acceptable here, if you cannot behave like an adult you should find an alternative playground.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 7:59

Krishhhhhhhhhhhhhh

10-Dec-09 7:59

sure. y not? tell me......

Re: How to send an auto mail - [ REPOST ]

Richard MacCutchan10-Dec-09 8:06

Richard MacCutchan

10-Dec-09 8:06

This thread is at an end.

Re: How to send an auto mail - [ REPOST ]

Krishhhhhhhhhhhhhh10-Dec-09 8:09

Krishhhhhhhhhhhhhh

10-Dec-09 8:09

go to hell

Re: How to send an auto mail - [ REPOST ]

Eddy Vluggen10-Dec-09 11:08

Eddy Vluggen

10-Dec-09 11:08

Krishhhhhhhhhhhhhh wrote:
I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".

There are multiple ways that you can solve this. May I suggest writing a console-application that makes a SqlConnection to verify the status? It would be quite trivial to send an email from C#, and you can launch the application using Windows' task-scheduler.

Krishhhhhhhhhhhhhh wrote:
Stop this bloody replies and do ur job perfectly. otherwise close ur forums

We're not being paid to answer you, and these forums are not a "company" that exists to serve others. This is a meeting-space where all kinds of people can trade idea's. Consider it a public market Smile | :)

I are Troll Suspicious | :suss:

Sqlite Database

savitri10-Dec-09 1:04

savitri

10-Dec-09 1:04

Hi All,

I am savitri here.New to this part of forum. I am doing one application for Psion Teklogix Device in VC# 2003.It is Windows CE 4.2. For that i am using Visual Studio 2003. I want to create database in device. I am not getting how to use sqlite operation in device programming. I am not getting any Dll's for that SQLite.
So please tell me how to create and connect in device level programming. Give me some hints or solution.I am searching alot but not got any result.Getting struck here only. please do needful for me.

Regards,
Savitri Frown | :(

Re: Sqlite Database

Eddy Vluggen10-Dec-09 11:20

Eddy Vluggen

10-Dec-09 11:20

savitri wrote:
I am doing one application for Psion Teklogix Device in VC# 2003.

That's probably not an i386-based device. Have you checked whether it is compiled against the correct architecture?

savitri wrote:
I am not getting any Dll's for that SQLite.

Here's a sweet alternative; you can download http://code.google.com/p/csharp-sqlite/[^] code, and include them directly in your project Smile | :)

I are Troll Suspicious | :suss:

database

farokhian9-Dec-09 22:28

farokhian

9-Dec-09 22:28

Hi I have a program that needs Microsoft Sql Server for my database .
Now i want to create an installer for my program with Installshield Software and i want to know what should i add to my installer for using sql database?

Re: database [crosspost]

Eddy Vluggen10-Dec-09 0:36

Eddy Vluggen

10-Dec-09 0:36

Please don't crosspost. Answered in the C# forum.

I are Troll Suspicious | :suss:

Re: database

Niladri_Biswas10-Dec-09 0:39

Niladri_Biswas

10-Dec-09 0:39

First of all this is a wrong forum to ask.

Second is that , you did not specify the front end tool ythat u are using.

However, if it is dotnet application, this link will help you

Creating a .NET Windows Installer [^]

If java, this may help

MAKE AN INSTALLER FOR YOUR JAVA APPLICATIONS[^]

Niladri Biswas

problem while import TXT file

koolprasad20039-Dec-09 19:48

koolprasad2003

9-Dec-09 19:48

Hi all

i have sql 2005 installed on my m/c.

i want to import txt file which just exported from SQL 2000.

i am using Import/Export wizard but problem is while importing it will automatically change column size and it's datatype.

means it varchar to nVarchar
size 20 to 2000

then i have to go in advanced import option and correct datatype and size for all columns

why this happens ??? where i am wrong ???

is there any setting ???

thanks in advance
koolprasad2003

Rating always..... WELCOME

Be a good listener...Because Opprtunity knoughts softly...N-Joy

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