| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| MS SQL issue http://teleflow.org/phpbb/viewtopic.php?f=10&t=276 |
Page 1 of 1 |
| Author: | weblink [ Fri Oct 07, 2005 9:42 am ] |
| Post subject: | |
I'm trying to connect to a MS SQL database to set a variable to make sure the user is entering the correct numbers. I got the connection to work but when I do my select statement, it is not populating the variable for me. <br>I've attached the log, any ideas/hints? <br> <br>2005/10/07 12:36:54.578: [1] START <br>2005/10/07 12:36:54.578: [19] Set Global Variable <br>2005/10/07 12:36:54.578: Setting global variable '@ACCOUNT' to '2' <br>2005/10/07 12:36:54.593: [21] Set Global Variable <br>2005/10/07 12:36:54.593: Setting global variable '@ALERT' to '4' <br>2005/10/07 12:36:54.593: [5] DB Connect <br>2005/10/07 12:36:54.593: ConnectString: DSN=Webfarm3; SRVR=xx.xxx.xxx.xxx; Database=xxxxxxxxx; UID=sa;PWD=xxxxxxxxxxxx; <br> <br> <br>2005/10/07 12:36:54.859: SQL Error State: 01S00 <br> Native Error Code: 0 <br> ODBC Error: [Microsoft][ODBC Driver Manager] Invalid connection string attribute <br>2005/10/07 12:36:54.875: SQL Error State: 01000 <br> Native Error Code: 1645 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'xxxxxxxxx'. <br>2005/10/07 12:36:54.875: SQL Error State: 01000 <br> Native Error Code: 1647 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. <br>2005/10/07 12:36:54.875: SQL Error State: 01S00 <br> Native Error Code: 0 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute <br>2005/10/07 12:36:54.875: SQL Error State: HY092 <br> Native Error Code: 0 <br> ODBC Error: [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier <br>2005/10/07 12:36:54.890: [7] SQL Statement <br>2005/10/07 12:36:54.890: Warning time threshold not specified, using default of 2000 ms <br>2005/10/07 12:36:54.890: <----- BEGIN -----> <br> SELECT <br> INT_AGENCYID INT_AGENCYID <br> FROM <br> tblalerts <br> WHERE <br> int_alertid = 4 <br> <----- END -----> <br>2005/10/07 12:36:54.953: Elapsed Time: 0.063 <br>2005/10/07 12:36:54.953: [9] Case <br>2005/10/07 12:36:54.953: ERROR: '@INT_AGENCYID' undefined <br>2005/10/07 12:36:54.953: ERROR: '@INT_AGENCYID' undefined <br>2005/10/07 12:36:54.953: ERROR: Case argument '@INT_AGENCYID' undefined <br>2005/10/07 12:36:54.953: FATAL |
|
| Author: | weblink [ Fri Oct 07, 2005 9:58 am ] |
| Post subject: | |
Ahh. Got it myself. Wasn't running a fetch after my select, just needed to read a little more. |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|