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 |
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
 Posted - 2005-09-13 : 11:52:23
|
| So there is this app I developed a few year back. Part of it is a classic ASP page that uses ASPSmartUpload to grab a text file off of the local machine and then it calls a COM object that runs a DTS package to load the text file into SQL Server. Origianlly the DB and IIS were on the same machine. They just seperated the DBs and IIS on different machines. Fine. I recreated and renamed my DTS packages on the db server. My COM object accepts any server name and DTS package name. I changed the sql server account everything was using and updated the ASP pages to call the new server and DTS packages.I made sure the user name and password were correct in my connection string file and my COM object, and on the new sql server. I recompiled and unregistered and registered my COM object.The error that keeps being returned isLogin failed for user 'MyUserName'The thing is this username is not being called from anywhere in the APP anymore. Not in the DTS packages, not the central connection string, not the COM object, no where. The username does not even exist on the new db server. I have been messing with this thing for 3 hours and I am going a little crazy. More than usual.Any ideas?====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-09-13 : 11:58:12
|
Just out of curiousity... save the DTS as a visual basic script, and then search for 'MyUserName'...Unforntunately, your error message seems to point that you are incorrect in at least one case. It has to show up in one of the elements  Good Luck  Corey Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now." |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-13 : 12:24:25
|
| Everytime I get stuck it is something glaringly stupid, but this is not it. The only SQL Server connectio is a trusted one. But the error is coming from the Microsoft OLE DB Provider for SQL Server. I might jst rewrite using bcp. I hate hate hate DTS. I am glad they trashed in 2K5.EDIT: The source of the error is in the COM calling the DTS package because the error handler in the COM object is returning the OLE DB Error.Set oConnection = goPackage.Connections.New("SQLOLEDB") oConnection.ConnectionProperties("Integrated Security") = "SSPI" oConnection.ConnectionProperties("Persist Security Info") = True oConnection.ConnectionProperties("Initial Catalog") = "MyDatabase" oConnection.ConnectionProperties("Data Source") = "(local)" oConnection.ConnectionProperties("Application Name") = "DTS Import/Export Wizard" oConnection.Name = "Connection 2" oConnection.ID = 2 oConnection.Reusable = True oConnection.ConnectImmediate = False oConnection.DataSource = "(local)" oConnection.ConnectionTimeout = 60 oConnection.Catalog = "MyDatabase" oConnection.UseTrustedConnection = True oConnection.UseDSL = False 'If you have a password for this connection, please uncomment and add your password below. 'oConnection.Password = "<put the password here>"goPackage.Connections.Add oConnectionSet oConnection = Nothing====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-14 : 08:23:15
|
| and the answer was... an IIS restart. Somedays I feel so stupid.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-09-14 : 10:46:26
|
| I share this with you so you know you're not alone. Once upon a time as i was writing an ASP page with some javascript, I was absolutely dying trying to get the OnClick() even to work for my button. I spent about an hour trying to figure out what was wrong. Finally I did the walk of shame over to a coworkers desk to get a second set of eyes because i just couldn't take it anymore. (it pains me to do this). He looked over my shoulder and started laughing. Mike, he said, you're trying to call the On Lick event, I don't think javascript has one of those. It was a humbling day.Hope you feel better now.Mike"oh, that monkey is going to pay" |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-14 : 11:56:18
|
| oh yeah,third week of my first dba position I changed 500,000 people records to have the country field of Germany on the production box. I almost went to the bathroom at my desk and nearly had a heart attack.I put humpty dumpty back together again and I have'nt lost a patient since. Stayed there 3 years and got 2 employee of the year awards. My boss often started speaking German when we were at meetings together for the rest of my tenure there. Ever since I am sooooo careful with everything.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
|
|
|
|
|
SQL Server \ COM \ Classic ASP \ DTS mystery