MySQL .NET Connector registry info

MySQL .NET Connector registry info

am 20.06.2005 16:17:35 von Greg Quinn

------=_NextPart_000_0032_01C575B3.9195B330
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'd like to bundle the MySQL .NET Connector in my installshield package =
so the user doesn't have to install the .net connector seperately.

Can someone give me the registry entries and what .dll's I need to place =
where for this?

Thanks

------=_NextPart_000_0032_01C575B3.9195B330--

Re: MySQL .NET Connector registry info

am 21.06.2005 17:49:24 von Reggie Burnett

No registry entries required. You can choose to register the assembly
in the GAC or simply install the binary into the bin folder of your app.

Is your app GPL or will you be needing a commercial license?

>I'd like to bundle the MySQL .NET Connector in my installshield package so the user doesn't have to install the .net connector seperately.
>
>Can someone give me the registry entries and what .dll's I need to place where for this?
>
>Thanks
>
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Getting column counter as part of query

am 21.06.2005 19:31:47 von Greg Quinn

How does one do this in mySQL?

Basically I am binding directly to a control, in the control I need a column
stating the record #.
i.e

# Name
1 Bob
2 John
3 Mary

How do I get the actual record counter as part of a query?


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Getting column counter as part of query

am 22.06.2005 12:03:55 von Greg Quinn

Thanks,

I have tried this in my program, but when I try to insert into T it says the
table does not exist.

If I run this query directly in MySQLCC it works, but in my app, If I run
the query on 2 different database connections it does not work. Is this
query supposed to run on one connection?

I have tried running both queries at once but I am told there uis a problem
with my syntax after the first queries semi colon (;)

What am I doing wrong?
Thanks

----- Original Message -----
From: "Ignatius Reilly"
To: "Greg Quinn"
Sent: Tuesday, June 21, 2005 8:32 PM
Subject: Re: Getting column counter as part of query


> you can create a temporary table with an autoincrement field,
> and select your data to extract into this table
>
> CREATE TEMPORARY TABLE T(
> id int auto_increment,
> first_name varchar(40),
> ...,
> PRIMARY KEY ( id )
> ) ;
>
> INSERT INTO T
> SELECT 0,
> first_name,
> ...
> FROM mytable
>
> Now you can use T to extract your data
>
> Ignatius
>
> Greg Quinn wrote:
>> How does one do this in mySQL?
>>
>> Basically I am binding directly to a control, in the control I need a
>> column stating the record #.
>> i.e
>>
>> # Name
>> 1 Bob
>> 2 John
>> 3 Mary
>>
>> How do I get the actual record counter as part of a query?
>>
>>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Getting column counter as part of query

am 22.06.2005 14:13:14 von emmanuel.kartmann

The MyODBC driver cannot handle more than one SQL request at a time - =
thus
the "syntax error" after ";".
The temporary table is only available for the CURRENT connection - thus =
the
"table does not exist" error.

Depending on how you access the MyODBC driver, you could SPLIT your =
requests
in 2 strings (CREATE than INSERT/SELECT), open a connection, execute =
both
requests and than close the connection. However, if you use a control =
and
can't customize the ODBC access... I guess you're stuck...

E.

-----Message d'origine-----
De : Greg Quinn [mailto:greg@officium.co.za]=20
Envoy=E9 : mercredi 22 juin 2005 12:04
=C0 : win32@lists.mysql.com
Objet : Re: Getting column counter as part of query

Thanks,

I have tried this in my program, but when I try to insert into T it says =
the
table does not exist.

If I run this query directly in MySQLCC it works, but in my app, If I =
run
the query on 2 different database connections it does not work. Is this
query supposed to run on one connection?

I have tried running both queries at once but I am told there uis a =
problem
with my syntax after the first queries semi colon (;)

What am I doing wrong?
Thanks

----- Original Message -----
From: "Ignatius Reilly"
To: "Greg Quinn"
Sent: Tuesday, June 21, 2005 8:32 PM
Subject: Re: Getting column counter as part of query


> you can create a temporary table with an autoincrement field,
> and select your data to extract into this table
>
> CREATE TEMPORARY TABLE T(
> id int auto_increment,
> first_name varchar(40),
> ...,
> PRIMARY KEY ( id )
> ) ;
>
> INSERT INTO T
> SELECT 0,
> first_name,
> ...
> FROM mytable
>
> Now you can use T to extract your data
>
> Ignatius
>
> Greg Quinn wrote:
>> How does one do this in mySQL?
>>
>> Basically I am binding directly to a control, in the control I need a =

>> column stating the record #.
>> i.e
>>
>> # Name
>> 1 Bob
>> 2 John
>> 3 Mary
>>
>> How do I get the actual record counter as part of a query?
>>
>>
>=20






--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Getting column counter as part of query

am 22.06.2005 15:19:50 von Markus Grossrieder

> Depending on how you access the MyODBC driver, you could SPLIT your
> requests
That works for me in Access/ODBC

However, maybe a more simple solution would be to omit the "temporary"
keyword in your create table query; instead add a 3rd query who deletes the
table afterwards.

HTH, Markus

----- Original Message -----
From:
To: "'Greg Quinn'" ;
Sent: Wednesday, June 22, 2005 2:13 PM
Subject: RE: Getting column counter as part of query



The MyODBC driver cannot handle more than one SQL request at a time - thus
the "syntax error" after ";".
The temporary table is only available for the CURRENT connection - thus the
"table does not exist" error.

Depending on how you access the MyODBC driver, you could SPLIT your requests
in 2 strings (CREATE than INSERT/SELECT), open a connection, execute both
requests and than close the connection. However, if you use a control and
can't customize the ODBC access... I guess you're stuck...

E.

-----Message d'origine-----
De : Greg Quinn [mailto:greg@officium.co.za]
Envoyé : mercredi 22 juin 2005 12:04
À : win32@lists.mysql.com
Objet : Re: Getting column counter as part of query

Thanks,

I have tried this in my program, but when I try to insert into T it says the
table does not exist.

If I run this query directly in MySQLCC it works, but in my app, If I run
the query on 2 different database connections it does not work. Is this
query supposed to run on one connection?

I have tried running both queries at once but I am told there uis a problem
with my syntax after the first queries semi colon (;)

What am I doing wrong?
Thanks

----- Original Message -----
From: "Ignatius Reilly"
To: "Greg Quinn"
Sent: Tuesday, June 21, 2005 8:32 PM
Subject: Re: Getting column counter as part of query


> you can create a temporary table with an autoincrement field,
> and select your data to extract into this table
>
> CREATE TEMPORARY TABLE T(
> id int auto_increment,
> first_name varchar(40),
> ...,
> PRIMARY KEY ( id )
> ) ;
>
> INSERT INTO T
> SELECT 0,
> first_name,
> ...
> FROM mytable
>
> Now you can use T to extract your data
>
> Ignatius
>
> Greg Quinn wrote:
>> How does one do this in mySQL?
>>
>> Basically I am binding directly to a control, in the control I need a
>> column stating the record #.
>> i.e
>>
>> # Name
>> 1 Bob
>> 2 John
>> 3 Mary
>>
>> How do I get the actual record counter as part of a query?
>>
>>
>






--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=markus.grossrieder@alba-s ystems.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Getting column counter as part of query

am 22.06.2005 15:30:38 von Ignatius Reilly

Many drawbacks:

1. risks of conflict if two users want to do the same concurrently
(table scope is global)
2. obliges you to grant the CREATE / DROP TABLE rights to the mysql
account - not recommended

Ignatius

Markus Grossrieder wrote:
>>Depending on how you access the MyODBC driver, you could SPLIT your
>>requests
>
> That works for me in Access/ODBC
>
> However, maybe a more simple solution would be to omit the "temporary"
> keyword in your create table query; instead add a 3rd query who deletes the
> table afterwards.
>
> HTH, Markus
>
> ----- Original Message -----
> From:
> To: "'Greg Quinn'" ;
> Sent: Wednesday, June 22, 2005 2:13 PM
> Subject: RE: Getting column counter as part of query
>
>
>
> The MyODBC driver cannot handle more than one SQL request at a time - thus
> the "syntax error" after ";".
> The temporary table is only available for the CURRENT connection - thus the
> "table does not exist" error.
>
> Depending on how you access the MyODBC driver, you could SPLIT your requests
> in 2 strings (CREATE than INSERT/SELECT), open a connection, execute both
> requests and than close the connection. However, if you use a control and
> can't customize the ODBC access... I guess you're stuck...
>
> E.
>
> -----Message d'origine-----
> De : Greg Quinn [mailto:greg@officium.co.za]
> Envoyé : mercredi 22 juin 2005 12:04
> À : win32@lists.mysql.com
> Objet : Re: Getting column counter as part of query
>
> Thanks,
>
> I have tried this in my program, but when I try to insert into T it says the
> table does not exist.
>
> If I run this query directly in MySQLCC it works, but in my app, If I run
> the query on 2 different database connections it does not work. Is this
> query supposed to run on one connection?
>
> I have tried running both queries at once but I am told there uis a problem
> with my syntax after the first queries semi colon (;)
>
> What am I doing wrong?
> Thanks
>
> ----- Original Message -----
> From: "Ignatius Reilly"
> To: "Greg Quinn"
> Sent: Tuesday, June 21, 2005 8:32 PM
> Subject: Re: Getting column counter as part of query
>
>
>
>>you can create a temporary table with an autoincrement field,
>>and select your data to extract into this table
>>
>>CREATE TEMPORARY TABLE T(
>>id int auto_increment,
>>first_name varchar(40),
>>...,
>>PRIMARY KEY ( id )
>>) ;
>>
>>INSERT INTO T
>>SELECT 0,
>>first_name,
>>...
>>FROM mytable
>>
>>Now you can use T to extract your data
>>
>>Ignatius
>>
>>Greg Quinn wrote:
>>
>>>How does one do this in mySQL?
>>>
>>>Basically I am binding directly to a control, in the control I need a
>>>column stating the record #.
>>>i.e
>>>
>>># Name
>>>1 Bob
>>>2 John
>>>3 Mary
>>>
>>>How do I get the actual record counter as part of a query?
>>>
>>>
>>
>
>
>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Getting column counter as part of query

am 22.06.2005 15:40:07 von Greg Quinn

I already tried this, and had the problem where my control was trying to
display the data before MySQL could process it. Thus giving me a control
with no records sometimes.

Anyway, I have sorted this problem out by manually creating a column in my
..NET dataset and adding the row counter as a column.

----- Original Message -----
From: "Markus Grossrieder"
To:
Cc:
Sent: Wednesday, June 22, 2005 3:19 PM
Subject: Re: Getting column counter as part of query


>> Depending on how you access the MyODBC driver, you could SPLIT your
>> requests
> That works for me in Access/ODBC
>
> However, maybe a more simple solution would be to omit the "temporary"
> keyword in your create table query; instead add a 3rd query who deletes
> the table afterwards.
>
> HTH, Markus
>
> ----- Original Message -----
> From:
> To: "'Greg Quinn'" ;
> Sent: Wednesday, June 22, 2005 2:13 PM
> Subject: RE: Getting column counter as part of query
>
>
>
> The MyODBC driver cannot handle more than one SQL request at a time - thus
> the "syntax error" after ";".
> The temporary table is only available for the CURRENT connection - thus
> the
> "table does not exist" error.
>
> Depending on how you access the MyODBC driver, you could SPLIT your
> requests
> in 2 strings (CREATE than INSERT/SELECT), open a connection, execute both
> requests and than close the connection. However, if you use a control and
> can't customize the ODBC access... I guess you're stuck...
>
> E.
>
> -----Message d'origine-----
> De : Greg Quinn [mailto:greg@officium.co.za]
> Envoyé : mercredi 22 juin 2005 12:04
> À : win32@lists.mysql.com
> Objet : Re: Getting column counter as part of query
>
> Thanks,
>
> I have tried this in my program, but when I try to insert into T it says
> the
> table does not exist.
>
> If I run this query directly in MySQLCC it works, but in my app, If I run
> the query on 2 different database connections it does not work. Is this
> query supposed to run on one connection?
>
> I have tried running both queries at once but I am told there uis a
> problem
> with my syntax after the first queries semi colon (;)
>
> What am I doing wrong?
> Thanks
>
> ----- Original Message -----
> From: "Ignatius Reilly"
> To: "Greg Quinn"
> Sent: Tuesday, June 21, 2005 8:32 PM
> Subject: Re: Getting column counter as part of query
>
>
>> you can create a temporary table with an autoincrement field,
>> and select your data to extract into this table
>>
>> CREATE TEMPORARY TABLE T(
>> id int auto_increment,
>> first_name varchar(40),
>> ...,
>> PRIMARY KEY ( id )
>> ) ;
>>
>> INSERT INTO T
>> SELECT 0,
>> first_name,
>> ...
>> FROM mytable
>>
>> Now you can use T to extract your data
>>
>> Ignatius
>>
>> Greg Quinn wrote:
>>> How does one do this in mySQL?
>>>
>>> Basically I am binding directly to a control, in the control I need a
>>> column stating the record #.
>>> i.e
>>>
>>> # Name
>>> 1 Bob
>>> 2 John
>>> 3 Mary
>>>
>>> How do I get the actual record counter as part of a query?
>>>
>>>
>>
>
>
>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=markus.grossrieder@alba-s ystems.com
>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Getting column counter as part of query

am 23.06.2005 00:51:29 von jbonnett

Temporary tables are "per connection" so if you want to see the
temporary table, you need to be using the same connection.

-----Original Message-----
From: Greg Quinn [mailto:greg@officium.co.za]=20
Sent: Wednesday, 22 June 2005 7:34 PM
To: win32@lists.mysql.com
Subject: Re: Getting column counter as part of query

Thanks,

I have tried this in my program, but when I try to insert into T it says
the=20
table does not exist.

If I run this query directly in MySQLCC it works, but in my app, If I
run=20
the query on 2 different database connections it does not work. Is this=20
query supposed to run on one connection?

I have tried running both queries at once but I am told there uis a
problem=20
with my syntax after the first queries semi colon (;)

What am I doing wrong?
Thanks

----- Original Message -----=20
From: "Ignatius Reilly"
To: "Greg Quinn"
Sent: Tuesday, June 21, 2005 8:32 PM
Subject: Re: Getting column counter as part of query


> you can create a temporary table with an autoincrement field,
> and select your data to extract into this table
>
> CREATE TEMPORARY TABLE T(
> id int auto_increment,
> first_name varchar(40),
> ...,
> PRIMARY KEY ( id )
> ) ;
>
> INSERT INTO T
> SELECT 0,
> first_name,
> ...
> FROM mytable
>
> Now you can use T to extract your data
>
> Ignatius
>
> Greg Quinn wrote:
>> How does one do this in mySQL?
>>
>> Basically I am binding directly to a control, in the control I need a

>> column stating the record #.
>> i.e
>>
>> # Name
>> 1 Bob
>> 2 John
>> 3 Mary
>>
>> How do I get the actual record counter as part of a query?
>>
>>
>=20



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org