|
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
|
