Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BlasterOfMuppets
Starting Member
8 Posts |
 Posted - 2007-01-31 : 16:04:32
|
| I have a stored procedure that I can execute (exec) with '0001' as the first in parameter. Then there is a piece of code that calls the sp over an ODBC connection. The call sends 0001 without the '' as the first in parameter. This worked just fine until recently. Now 0001 is first converted to an integer and then converted back to a string. The string becomes 1 instead of 0001. Any ideas why? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-31 : 16:12:00
|
| Well something changed in your environment if it worked before and now isn't. In order for us to help though, we would need to see the code.Tara Kizer |
 |
|
|
BlasterOfMuppets
Starting Member
8 Posts |
Posted - 2007-01-31 : 16:52:09
|
| It's some old code and I don't have it here. But I bet it's some auto conversion added to either the odbc-driver or SQL-Server 2000 within the last 2-3 years. The code hasn't changed so it oughta be something in the environment. |
|
|
|
|
|
|
Automagic conversion when calling an sp