Search results for query: *

Hello all, I connect to the terminal server using MSTSC, when I run MSTSC.exe, it brings up the login screen asking for user name and password. Can I bypass this screen and send in user name and password parameters when I run MSTSC.exe? Any information will help, thank you.

Hello everyone, I'm a beginner when dealing with SQL Server 2k. my PC is running only windows 2k, I can only install SQL server 2k Personal edition on it. Am I able to connect to this server from another machine? So far I cannot connect to it via ODBC or using VBA script. When I first ran...

sorry about all of the trouble, I appreciate all of your help, i'm gonna give our client a quote for SQL 2000. before, I only had the local station use MSDE, and not until recently did the issue of a remote user needing access to the database did this issue arise. but thank you very much for...

thansk dk87, one other thing i forgot to mention that might be significant, I do not have the actual SQL software running, I have MSDE running on the PC, is this a problem? does MSDE not allow remote access to the database?

thanks for all of your help dk87, it doesn't want to work, it seems like I am having issues with security. how do I make sure that the user on the remote machine has access to the database? the remote machine hasa local user logged in, I added a user in the server with the same user name and...

dk87, It doesn't seem to work whenever I try to connect, using this command: Dim cnDTB as ADODB.Connection strConnection = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=ServerPCName" Set cnDTB = New ADODB.Connection...

I found an SQL server 2000 Driver for JDBC, is this the correct driver?

thank you dk87 I'm not sure I have the SQL server configured correctly, do I need to create an ODBC connection to the SQL server on the remote machine before I can connect to it? I tried that code on the remote machine and a similar error occurred

Hello everyone, I hope I am asking the right people, I have an SQL server setup locally and I connect to it using this code: strConnection = "Driver={SQL Server};Server=PCNAME;Database=Master;Trusted_Connection=yes" Set cnDTB = New ADODB.Connection cnDTB.ConnectionString = strConnection...

Please if anyone can help me... I am using Advanced Filter code to display a set of unique values from a large column of data here is my code to advanced filter Sheets("Data").Columns("D:D").AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Range("B9")...

hello, could someone please help me. I'm trying to find the proper syntax to open an MS Access database via ODBC connection in vb6...thank you

thank you very much mwolf00 i appreciate it greatly

hello everyone, i'm a beginning programmer and i need help writing code to delete a row at a time... i have two tables and where there is a match in one of the columns, i want the row deleted in one of the tables. I use a "DELETE FROM [] WHERE Value1 = Value2" statement but it...