Search found 14044 matches

by jvierra
Tue May 20, 2008 3:24 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

What protocols are listed as enabled on the client? We know that you can use sqlcmd with TCP/IP but that goes direct to the net layer. ASP.NET may not work if the protocols are not enabled. Check SQLServer Configuration Manager on the client and check "Client Protocols" Be sure that TCP/IP is enable...
by jvierra
Tue May 20, 2008 2:05 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

You will get that error whenever the NET SQL client cannot connect to the target machine. I cn run your exact code with no changes except changing the machine names to match hosts I have on my network. If I use a bad name or turn of the protocols I get the same error you are getting. To avoid issues...
by jvierra
Mon May 19, 2008 5:44 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

Looks good to me. SQS 2005 so you have teh latest SQS 2005 client installed on teh local machine? Do you have SP1 for SQS2005 installed on teh local machine? What are you network security settings set to for teh SQS2005 client? Is SQLServer installed on teh local machine? What network protocols are ...
by jvierra
Mon May 19, 2008 5:22 am
Forum: VBScript
Topic: vb script: for reading windows dll files
Replies: 5
Views: 2969

vb script: for reading windows dll files

One note that may be a show stopper - You can't assign "file properties" to files. This is proprietary and can only be done for files designed for this such as MS Word and Excel files. Text files do not have "properties" other than those assigned and managed by the system. It appears that you may be...
by jvierra
Mon May 19, 2008 5:08 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

The server name you are using in the conenct string must be of the form server/instance for non-default instances or for the default instance of SQLExpress. What is you exact SQLCMD connection line? I suspect their is an issue of instance naming. The connection for a local SQL instance is as follows...
by jvierra
Mon May 19, 2008 4:36 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

If the server doesn't exist or if it is the wrong type you will get that error. It's generic for an "open" failure with the NET SQLClient. Try using iSQL or oSQL to connect to the server with you credentials.

The SQL Client must be installed on the local machine for any connections to work.
by jvierra
Mon May 19, 2008 4:21 am
Forum: Windows PowerShell
Topic: Trouble connecting to SQL database
Replies: 15
Views: 10641

Trouble connecting to SQL database

Remove teh "clear" statement and report the "first" error.

What yo are seeing is caused by the screen being cleared and by the error causing termination of the pipline "foreach" on teh first error. We need to isolate that exact first error.
by jvierra
Sun May 18, 2008 5:35 am
Forum: VBScript
Topic: Script Administrator from cvs,txt or xls File
Replies: 1
Views: 1313

Script Administrator from cvs,txt or xls File

We are sorry that you have not received a quicker response. I believe this may be because none of us can quite understand your request in either english or spanish. Sometimes by trying to be too clear the message gets lost. Try stating your problem in simple terms such as: " I need to rename an acco...
by jvierra
Sat May 17, 2008 6:24 am
Forum: Other Scripting Languages
Topic: To install a msi package remotly form a VB script.
Replies: 2
Views: 2276

To install a msi package remotly form a VB script.

THere are a number of ways to deploy MSI packages. You should start by looking into Group Policy as a mechanism as it is most flexible and automatic. To directly distribute software vuia script is a bit of a problem. You might want to look into using PsExec and wrapping it in a script. http://techne...
by jvierra
Fri May 16, 2008 10:11 am
Forum: VBScript
Topic: Wildcards in AD search
Replies: 3
Views: 1604

Wildcards in AD search

Yes - you are correct.

It is possible that this doesn't work or that it may only work on "indexed" items. Try it with "CN". If it works but not with "Name" then that is probably the reason as I don't think "Name" is indexed.