Database

How to connect with a MySQL database?

8-Aug-05 6:55

You might be able to use a UNC file path to the database (this works on a local lan, provided the user has access to the directory). It will be slow however, and is not likely to prove satisfactory (performance wise), if it works at all.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

rushing7-Aug-05 21:24

rushing

7-Aug-05 21:24

In vs.net 2005, I want to connect with MySQL database.
After trying some hours, I found there is many questions:
1 Add reference error.
Which dll should be add into project?
2 Connect String error.
Which provider in OLEDB could be used?
3 User name and password and datasource.
Thanks!

Re: How to connect with a MySQL database?

Frank Kerrigan7-Aug-05 22:57

Frank Kerrigan

7-Aug-05 22:57

OLE DB Provider for mySQL
oConn.Open "Provider=MySQLProv;" & _
"Data Source=mySQLDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"

Re: How to connect with a MySQL database?

rushing8-Aug-05 16:13

rushing

8-Aug-05 16:13

I use the provider "MySQLProv",but the .net 2005 beta2 said "the provider is not registered on the local machine.

Re: How to connect with a MySQL database?

toxcct8-Aug-05 0:57

toxcct

8-Aug-05 0:57

www.connectionstrings.com[^]

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Snap-In problem

Alex Cutovoi7-Aug-05 11:46

Alex Cutovoi

7-Aug-05 11:46

Hi fellows

I've a problem with SQL Server 2000. When I enter in the Enterprise manager, I receive the following message:
"Failure on snap-in initilization
Name: <unknown>
CLSID:{0001000100-1816-11D0-8EF5-00AA0062C58F}"

Some can help me?

Regards

read dbf file

_tasleem7-Aug-05 2:53

_tasleem

7-Aug-05 2:53

hi i m new to the ADO i want to know that is ADO had the ability to read and write athe dbase IV database using visualc++.

ddd

SQL Beginner: Listing tables in DB

PJ Arends6-Aug-05 16:25

6-Aug-05 16:25

Hey,

I am trying to teach myself SQL and have come up with a small problem. How does one use SQL to list the names of all the tables in a database? Up until now I have done it using Carlos Antollini's CADOXCatalog class[^] but I want to do it in SQL from Query Analyzer.

"You're obviously a superstar." - Christian Graus about me - 12 Feb '03

"Obviously ??? You're definitely a superstar!!!" - mYkel - 21 Jun '04

"There's not enough blatant self-congratulatory backslapping in the world today..." - HumblePie - 21 Jun '05

Within you lies the power for good - Use it!

Rob Graham6-Aug-05 17:25

6-Aug-05 17:25

try:

select Name, Type from sysobjects where Type = N'U' or Type = N'S'

Type 'U' is a user table , type 'S' is a system table

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

PJ Arends6-Aug-05 18:01

6-Aug-05 18:01

Thanks Rob, works like a charm Smile | :)

Scott Serl6-Aug-05 21:35

Scott Serl

6-Aug-05 21:35

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

PJ Arends7-Aug-05 12:32

7-Aug-05 12:32

Thanks, works great.

Not only does it work, but when I looked this method up in my SQL book it says that this is the prefered way to do this. Better to use a system view than to access system tables directly.

Now I know how to do this (and other things) with SQL Server, it would be nice to have a way that works with other Database systems (MySQL and Access in particular. None of the three methods listed here work with those two systems Frown | :(

Rob Graham7-Aug-05 15:06

7-Aug-05 15:06

To do this prgramatically (not query analyzer) Use the GetOledbSchemaTable[^] method of the OledbConnection object (or ADO connection.OpenSchema()[^]if not using .NET).

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Scott Serl8-Aug-05 15:37

Scott Serl

8-Aug-05 15:37

http://dev.mysql.com/doc/mysql/en/information-schema.html[^]

I don't use MySql, but found this page which seems to address using INFORMATION_SCHEMA with MySQL.

PJ Arends8-Aug-05 16:58

8-Aug-05 16:58

Thanks for the link Smile | :)

It seems INFORMATION_SCHEMA is new in version 5. I have version 4 here. Explains why I could not get it to work D'Oh! | :doh:

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

toxcct6-Aug-05 23:16

toxcct

6-Aug-05 23:16

it depends actually on which database you try to get the table names.

the answer you got seem to be for MS SQL Server, but it would have worked on Oracle DB.

you should type instead :

select table_name, table_type
    from user_tables
    order by table_type asc, table_name asc;

cheers,

TOXCCT >>> GEII power
[toxcct][VisualCalc]

how to insert data

Member 14246356-Aug-05 7:21

Member 1424635

6-Aug-05 7:21

how to insert data directly into ms sql server 2000 database by using asp.net with vb.net and how to update data.

Re: how to insert data

toxcct6-Aug-05 23:22

toxcct

6-Aug-05 23:22

search for ADO.NET for the access classes.

to insert, use the insert SQL command :

insert into table
    list_of_columns_to_insert
    values(list_of_values);

to update, use the update SQL command :

update table
    setcolumn1 = value1,
       column2 = value2
    where condition;

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Re: how to insert data

Frank Kerrigan8-Aug-05 2:19

Frank Kerrigan

8-Aug-05 2:19

This is C# which you can easily convert.

###########################################

string myType = "Type"; ' varchar on SQL Server
string myPropID = "12"; ' Int on SQL Server

string SQLstring = "UPDATE tblZtest SET PropertyType = '" + myType + "' " +
" WHERE zTest = " + myPropID

SqlConnection myConnection = new SqlConnection(ConnectionString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand( SQLstring, myConnection );
myCommand.ExecuteNonQuery();
myConnection.Close();

##############################################

Re: how to insert data

Colin Angus Mackay9-Aug-05 2:35

Colin Angus Mackay

9-Aug-05 2:35

Your code has a big security hole in it. It would be good not to teach the newbies bad habits. Your code is susceptable to a SQL Injection Attack.

please help...

mhmo5-Aug-05 6:46

mhmo

5-Aug-05 6:46

hi I have some questions that I need to know the answers. These r in the ORACLE database.

Pleaaaaaaaaaaaaaaaaaaaaaaaaase, I need the answers sooooooooon.

answers any Q u can. Pleaaaaaaaaaaaaase.

the Q's r:

1-Write down SQL statement that shows free tablespace of one or more tablespaces. (In ORACLE)

2-Write down SQL statement that shows a particular table exists on which tablespaces.(In ORACLE)

3-. For example, one of the control file is deleted. When you start your database instance, you will receive message that database instance cannot startup. Write down steps how to resolve this task. Your steps must be outcome of implementation.(IN ORACLE)

4-Suppose you want to import data in one of the user’s schema, some tables with same names already existing in a schema. Write down tested imp command to accomplish it. Also, show the output result of your command.(IN ORACLE)

Re: please help...

Rob Graham5-Aug-05 7:55

5-Aug-05 7:55

Sounds like you should have actually studied for this test.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Re: please help...

mhmo5-Aug-05 8:03

mhmo

5-Aug-05 8:03

I did not understand!!!

Re: please help...

Rob Graham5-Aug-05 8:09