Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110398
interpreted = N
texte = --Apple-Mail=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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 webdna@idfk.com.au On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: > 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 --Apple-Mail=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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

= --Apple-Mail=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2-- 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=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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 webdna@idfk.com.au On 24/05/2013, at 1:50 AM, Alex McCombie = wrote: > 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 --Apple-Mail=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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

= --Apple-Mail=_9554F2A9-3AA6-4CFD-98C9-112C4511BCE2-- 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:

(slightly off) using menu and [search] (1998) [WriteFile] problems (1997) Searching multiple Databases (1997) [WebDNA] divisible by 1 (2011) ShowNext Anomaly (1998) [WebDNA] Problem running Webdna with IIS7 (2008) Search in 2 or more catalogs (1997) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) WebMerch/Emailer Error (1998) Error.html (1997) searchable list archive (1997) webdelivery.html and webna (1997) [WebDNA] Can't write to a db when working on on a iMac (2019) Location of Webcat site in folder hierarchy (1997) [WebDNA] [OT] hello (2012) multiple product databases (1997) WebCat b13 CGI -shownext- (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Proper file locations (1997) Nested tags count question (1997)