Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110415
interpreted = N
texte = --Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Alex Would you please send me an example.=20 I have a connection working using [SHELL] but would like to try with the = WebDNA method, i keep getting "Error: SQL not supported". I believe this to be true with the latest Linux build. Thanks. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 25/05/2013, at 12:52 PM, Alex McCombie = wrote: > Yep.. I had it running at one point on a Mac version as well. > The only trick is your OS needs to be able to setup an ODBC connection = to MSSQL. > Webdna [sql] tag is just sending the SQL string to the ODBC and then = on to MS. >=20 > Its pretty much the only way we do things now so the Data is also = simultaneously available to FMPRO, ACCESS, EXCEL, etc. >=20 > Alex >=20 >=20 > On May 23, 2013, at 7:13 PM, Stuart Tremain = wrote: >=20 >> Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list. >>=20 >> I have a few issues with the Windows build and am moving everything = to Ubuntu and need to find a way to make the MSSQL connection. There are = a few tools around which I will check out over the next week but = wondered if someone was already doing it. >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: >>=20 >>> Don't know about the linux issue, but nearly all my code is Wedna = 6.0 connecting to MSSQL Server 2000. 2005, 2008. >>>=20 >>> We are running the windows version though and using the standard = System DSN for the ODBC connectivity. >>>=20 >>> With only minor issues, we do this flawlessly. >>>=20 >>> HTH >>> Alex >>>=20 >>>=20 >>> On May 22, 2013, at 12:21 PM, Jeffrey Jones = wrote: >>>=20 >>>> [SQLconnect = dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn= _var=3Dconn1] >>>> Connected successfully >>>>=20 >>>> [/SQLconnect] >>>>=20 >>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1] >>>> select firstName,lastName from employees; >>>> [/SQLexecute] >>>>=20 >>>> [SQLresult result_ref=3Drs1] >>>> [numfound] records found
>>>> >>>> [founditems] >>>> >>>> [/founditems] >>>>
First NameLast Name
[firstName][lastName]
>>>> [/SQLresult] >>>>=20 >>>> On May 22, 2013, at 4:40 AM, Stuart Tremain = wrote: >>>>=20 >>>>> Is it possible to connect to MS SQL with WebDNA 6.2 on Linux ? >>>>>=20 >>>>> Regards >>>>>=20 >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> Bug Reporting: support@webdna.us >>>>>=20 >>>>=20 >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Alex

Would you please send me an = example. 

I have a connection working = using [SHELL] but would like to try with the WebDNA method, i keep = getting "Error: SQL not supported".

I believe = this to be true with the latest Linux = build.

Thanks.


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 25/05/2013, at 12:52 PM, Alex McCombie <info@adventureskies.com> = wrote:

Yep.. = I had it running at one point on a Mac version as well.
The only = trick is your OS needs to be able to setup an ODBC connection to = MSSQL.
Webdna [sql] tag is just sending the SQL string to the = ODBC and then on to MS.

Its pretty much the = only way we do things now so the Data is also simultaneously available = to FMPRO, ACCESS, EXCEL, = etc.

Alex


= On May 23, 2013, at 7:13 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list.

I have a few issues with = the Windows build and am moving everything to Ubuntu and need to find a = way to make the MSSQL connection. There are a few tools around which I = will check out over the next week but wondered if someone was already = doing it.


=
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 24/05/2013, at 1:50 AM, Alex McCombie <info@adventureskies.com> = wrote:

Don't = know about the linux issue, but nearly all my code is Wedna 6.0 = connecting to MSSQL Server 2000. 2005, 2008.

We are = running the windows version though and using the standard System DSN for = the ODBC connectivity.

With only minor issues, = we do this = flawlessly.

HTH
Alex


On May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> = wrote:

[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&=;pwd=3Dpass&conn_var=3Dconn1]
Connected =successfully

[/SQLconnect]

[SQLexecute =conn_ref=3Dconn1&result_var=3Drs1]
select firstName,lastName from =employees;
[/SQLexecute]

[SQLresult =result_ref=3Drs1]
[numfound] records found<br>
<table =border=3D1><tr><th>First Name</th><th>Last =Name</th></tr>
[founditems]
<tr><td>[firstName]</td><td>=[lastName]</td></tr>
[/founditems]
</table>
[/S=QLresult]

On May 22, 2013, at 4:40 AM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

Is it possible to connect to MS SQL with WebDNA 6.2 on = Linux ?

Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au



<= br>---------------------------------------------------------
This = message is sent to you because you are subscribed to
the mailing list = <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  2. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  3. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  4. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  5. Re: [WebDNA] Connect to MS SQL (Donovan Brooke 2013)
  6. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  7. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  8. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  9. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  10. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  11. Re: [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
  12. Re: [WebDNA] Connect to MS SQL (Alex McCombie 2013)
  13. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  14. Re: [WebDNA] Connect to MS SQL (Jeffrey Jones 2013)
  15. [WebDNA] Connect to MS SQL (Stuart Tremain 2013)
--Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Alex Would you please send me an example.=20 I have a connection working using [shell] but would like to try with the = WebDNA method, i keep getting "Error: SQL not supported". I believe this to be true with the latest Linux build. Thanks. Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 25/05/2013, at 12:52 PM, Alex McCombie = wrote: > Yep.. I had it running at one point on a Mac version as well. > The only trick is your OS needs to be able to setup an ODBC connection = to MSSQL. > Webdna [SQL] tag is just sending the SQL string to the ODBC and then = on to MS. >=20 > Its pretty much the only way we do things now so the Data is also = simultaneously available to FMPRO, ACCESS, EXCEL, etc. >=20 > Alex >=20 >=20 > On May 23, 2013, at 7:13 PM, Stuart Tremain = wrote: >=20 >> Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list. >>=20 >> I have a few issues with the Windows build and am moving everything = to Ubuntu and need to find a way to make the MSSQL connection. There are = a few tools around which I will check out over the next week but = wondered if someone was already doing it. >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: >>=20 >>> Don't know about the linux issue, but nearly all my code is Wedna = 6.0 connecting to MSSQL Server 2000. 2005, 2008. >>>=20 >>> We are running the windows version though and using the standard = System DSN for the ODBC connectivity. >>>=20 >>> With only minor issues, we do this flawlessly. >>>=20 >>> HTH >>> Alex >>>=20 >>>=20 >>> On May 22, 2013, at 12:21 PM, Jeffrey Jones = wrote: >>>=20 >>>> [SQLconnect = dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&pwd=3Dpass&conn= _var=3Dconn1] >>>> Connected successfully >>>>=20 >>>> [/SQLconnect] >>>>=20 >>>> [SQLexecute conn_ref=3Dconn1&result_var=3Drs1] >>>> select firstName,lastName from employees; >>>> [/SQLexecute] >>>>=20 >>>> [SQLresult result_ref=3Drs1] >>>> [numfound] records found
>>>> >>>> [founditems] >>>> >>>> [/founditems] >>>>
First NameLast Name
[firstName][lastName]
>>>> [/SQLresult] >>>>=20 >>>> On May 22, 2013, at 4:40 AM, Stuart Tremain = wrote: >>>>=20 >>>>> Is it possible to connect to MS SQL with WebDNA 6.2 on Linux ? >>>>>=20 >>>>> Regards >>>>>=20 >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> Bug Reporting: support@webdna.us >>>>>=20 >>>>=20 >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Alex

Would you please send me an = example. 

I have a connection working = using [shell] but would like to try with the WebDNA method, i keep = getting "Error: SQL not supported".

I believe = this to be true with the latest Linux = build.

Thanks.


Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 25/05/2013, at 12:52 PM, Alex McCombie <info@adventureskies.com> = wrote:

Yep.. = I had it running at one point on a Mac version as well.
The only = trick is your OS needs to be able to setup an ODBC connection to = MSSQL.
Webdna [SQL] tag is just sending the SQL string to the = ODBC and then on to MS.

Its pretty much the = only way we do things now so the Data is also simultaneously available = to FMPRO, ACCESS, EXCEL, = etc.

Alex


= On May 23, 2013, at 7:13 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks Alex, I knew that someone was connecting as I recalled some = mention of it on the list.

I have a few issues with = the Windows build and am moving everything to Ubuntu and need to find a = way to make the MSSQL connection. There are a few tools around which I = will check out over the next week but wondered if someone was already = doing it.


=
Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA




On 24/05/2013, at 1:50 AM, Alex McCombie <info@adventureskies.com> = wrote:

Don't = know about the linux issue, but nearly all my code is Wedna 6.0 = connecting to MSSQL Server 2000. 2005, 2008.

We are = running the windows version though and using the standard System DSN for = the ODBC connectivity.

With only minor issues, = we do this = flawlessly.

HTH
Alex


On May 22, 2013, at 12:21 PM, Jeffrey Jones <jjones@synergos.com> = wrote:

[SQLconnect =dbType=3DMySQL&host=3D192.168.1.1&database=3Dbase&uid=3Dsa&=;pwd=3Dpass&conn_var=3Dconn1]
Connected =successfully

[/SQLconnect]

[SQLexecute =conn_ref=3Dconn1&result_var=3Drs1]
select firstName,lastName from =employees;
[/SQLexecute]

[SQLresult =result_ref=3Drs1]
[numfound] records found<br>
<table =border=3D1><tr><th>First Name</th><th>Last =Name</th></tr>
[founditems]
<tr><td>[firstName]</td><td>=[lastName]</td></tr>
[/founditems]
</table>
[/S=QLresult]

On May 22, 2013, at 4:40 AM, = Stuart Tremain <webdna@idfk.com.au> = wrote:

Is it possible to connect to MS SQL with WebDNA 6.2 on = Linux ?

Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au



<= br>---------------------------------------------------------
This = message is sent to you because you are subscribed to
the mailing list = <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_0F955331-9D54-475A-A41D-CB228EA46C99-- Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Not really WebCat (1997) Suffix Mapping????? (1998) frames & carts (1997) Database Posting (2000) bug in [SendMail] (1997) default value from Lookup (was Grant, please help me) (1997) Hummm .... (2002) Design Help Needed (1998) [BoldWords] WebCat.acgib15Mac (1997) C is for cookie - that's good enough for me... (2001) Number searching/formats (1998) 2.0 Info (1997) problems with 2 tags (1997) Emailer update for Mac? (1998) Hiding Email Addresses (2003) WebCat 2.1beta etc (1997) multiple search of same field (1999) Duplicate Messages (1998) Press Release hit the NewsWire!!! (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997)