Search results for query: *

Alright, I did that. Created the DSN and at the end I tested the connection using the same UID and password that I was using in the connection string and it says tests completed successfully. Don't know where this puts me. I guess there would have to be something wrong with the connection...

Thanks for the help. I'm afraid I'm not farmiliar with how to create an File ODBC Connection though. Can you provide some instruction on how to do this? I don't have any sort of SQL Express management studio installed on this machine.

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

Looks like that worked. I knew I was making a stupid mistake. Thanks!!!

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

Thanks for your reply, I'm executing these DTS packages from within my VB6 application and the access db is on the local machine in a fixed location. I just figured out what was causing the problem, though. The three problem machines were running windows 2000 sp4 and apparently did not have...

Nobody has any ideas on this?

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