Re: [WebDNA] Connect to MS SQL

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110397
interpreted = N
texte = --Apple-Mail=_00DBBECE-FE7C-4560-9634-774E39BB49D8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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 wrote: > [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 --Apple-Mail=_00DBBECE-FE7C-4560-9634-774E39BB49D8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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

= --Apple-Mail=_00DBBECE-FE7C-4560-9634-774E39BB49D8-- 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=_00DBBECE-FE7C-4560-9634-774E39BB49D8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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 wrote: > [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 --Apple-Mail=_00DBBECE-FE7C-4560-9634-774E39BB49D8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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

= --Apple-Mail=_00DBBECE-FE7C-4560-9634-774E39BB49D8-- Alex McCombie

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:

Nested tags count question (1997) Dummy Credit Card Number for debug? (1997) autocommit problem (1998) WebTen? (1997) Database Posting (2000) and vs or vs not (1998) For those of you not on the WebCatalog Beta... (1997) unable to launch acgi in WebCat (1997) This list needs a digest: rant, rave... (1997) Order not created error (1997) Return records from another (1997) Highlighting words found in a keyword search (2003) [WebDNA] webdna7 sendmail error (2012) Still having problems with Authen (1997) Using .htaccess and ModRewrite - (was [OT] CSS and SSI (2004) What am I missing (1997) Trouble with formula.db (1997) More than one db with the same namn (was: WC2f3) (1997) [ot] html question (2000) What is the syntax for MIME type on Apache server? (2000)