Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB Connection failing when connection string has password
OK, I'm really at a loss on this one. I have a small VB6 App that connects to a SQL 2005 Express database using a connection string that gets built in code. For some reason it is failing with a "login failed for user" error when running on Vista only and the user I'm trying to login as has a...- bsal81
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
-
Delete using Join
I'm having a little trouble getting this SQL Statement right. I'm fairly new to SQL so my apologies if I made an obvious mistake. I have two tables we'll call them Table1 and Table2. Both tables will have an ID and Type column that will be the key fields. I want to delete records from Table1...- bsal81
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
DTS Multi Step Error
Hey Everyone, I've got a problem with a SQL7 DTS Package that seems to be failing on about three machines out of 300. The DTS package itself is responsible for transferring data from SQL7 to an Access DB. I turned on error logging for both the DTS Package and each of the DataPump Tasks. I...- bsal81
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
