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
> | First Name | Last Name |
|---|
> [founditems] > | [firstName] | [lastName] |
> [/founditems] >
> [/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
[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>
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: