Re^3: Need DBI/ODBC advice.

Well... that's a little irritating. In the CB I asked you, and re-asked you, to try to do a brand new connection without cutting and pasting the connection info to see what happened. In the CB, and in this post, all you shared was "dbi:ODBC:Driver={SQL Server}." If you'd shown the whole string, I would have--and probably others too--said, "Try it without the Regional setting." :(

Comment on Re^3: Need DBI/ODBC advice. Download Code

Replies are listed 'Best First'.
Re^4: Need DBI/ODBC advice. by Brak (Novice) on Aug 12, 2010 at 11:28 UTC
Yes, I fully agree and understand where I went wrong. I'm quite embarrassed. I had -wrongly- thought that the Regional setting meant something else, something that made the connection work, since I tried it earlier and didn't have a negative effect. That attempt must have correlated with something else that made the connection work instead, coincidentally. Thinking it was necessary, but not relevant to the problem, I didn't include it, just like I did not include the name of my server. Honestly, when I did try your suggestion, I just retyped it exactly as it was, since I thought Regional was important. Lesson learned though. Always post more rather than less.	[reply]

Replies are listed 'Best First'.

Re^4: Need DBI/ODBC advice.
by Brak (Novice) on Aug 12, 2010 at 11:28 UTC

Yes, I fully agree and understand where I went wrong. I'm quite embarrassed. I had -wrongly- thought that the Regional setting meant something else, something that made the connection work, since I tried it earlier and didn't have a negative effect. That attempt must have correlated with something else that made the connection work instead, coincidentally. Thinking it was necessary, but not relevant to the problem, I didn't include it, just like I did not include the name of my server. Honestly, when I did try your suggestion, I just retyped it exactly as it was, since I thought Regional was important. Lesson learned though. Always post more rather than less.

[reply]