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:

international time (1997) PCS Frames (1997) search form problem.. (1997) Reversed words (1997) [WebDNA] Help with work-around format date (2013) PDF Tools (2006) Three new problems, maybe a fourth (1997) Strange Search Results (2004) Special characters in field names (1998) Multiple Merchant Accounts? (1997) with Link i need to (1997) Grant, please help me ... (1997) Log-in Scheme (2003) Maybe minor bug report (1997) WebCat cannot handle compatible search parameters? (1997) WCS Newbie question (1997) [quantity] quantity[lineindex] (2000) Need WebDNA that crashes server for testing (2000) X Server (1999) question on [delete] (1998)