Re: Office Automation - Visual Basic Discussion Boards

raaman28-Aug-07 1:05

28-Aug-07 1:05

I m trying to connect to the SQL Server 2000 installed in a network machine n have tried to connect with the following connection string:

conn.Open "Provider=SQLOLEDB" & _
";Data Source=192.168.0.5,1433" & _
";Network Library=DBMSSOCN" & _
";Initial Catalog=" & "master"

But i have an error as below;

Runtime-error '-2147467259 (80004005)'
Invalid authorization specification

Pls help me wats goin wrong.

raamay

Re: Remote connection to SQL Server

originSH28-Aug-07 1:33

originSH

28-Aug-07 1:33

Check your connection string against: ConnectionStrings.com - Sql Server[^]

Re: Remote connection to SQL Server

Burnsys228-Aug-07 2:06

Burnsys2

28-Aug-07 2:06

You are not specifying the security options.

For NT Authentication:
"provider=sqloledb;Data Source=SERVER;Initial Catalog=DATABASE;Integrated Security=SSPI;"

For Sql Authentication:
"provider=sqloledb;Data Source=SERVER;Initial Catalog=DATABASE;UID=SA;PWD=Pass"

Re: Remote connection to SQL Server

raaman28-Aug-07 17:15

raaman

28-Aug-07 17:15

Yes i added the security options and now i get the error 'SQL Server doesnot exist or access denied' . I m sure the connection string is okey but i doubt we need to configure SQL Server and its remote access properties which i dont find plus dont have any idea what to do & wat to change. So, u got da idea i wud b immensely grateful.

raamay

Re: Remote connection to SQL Server [modified]

Burnsys229-Aug-07 4:09

Burnsys2

29-Aug-07 4:09

That looks like a conection problem,
First try to ping the server from Dos by it's name, it should at least resolve it's ip address
Then from the client machine try this:

Start
Run
CliConfg

And then set the "Default network library" to "TCP/IP"

If it still not working try
Telnet Server 1433

If it says that could not connect, then you have a network problem!

-- modified at 12:00 Wednesday 29th August, 2007

Re: Remote connection to SQL Server

raaman29-Aug-07 17:25

raaman

29-Aug-07 17:25

thanx n i tried every thing as u suggested. i tried pinging n it works plus moved to the second step whereby the Default network library is already set to "TCP/IP". And the 3rd one, there is no msg at all. it starts by saying connecting to the server and then disappears.

infact i wanted 2 say tht my network is a very small network n i m 100% confident it doesnt 've a problem. Probably i think i must use Sql Server authentication because during installation, i made the all authentication based on windows. Plus, i get the error "Login failed for user 'server\Guest'" now. i tried the sa login but failed to connect.

Any way thanks 4 ur support, pls lemme know further if u get any ideas.

raamay

Office Automation

Salman Sheikh28-Aug-07 0:13

Salman Sheikh

28-Aug-07 0:13

Hi

I am generating a word document in visual basic.Net. I need to know how can i add header and footers in document programatically. Also there is a picture in it i want to set its layout programatically

Salman Sheikh

Re: Office Automation

Johan Hakkesteegt29-Aug-07 23:47

Johan Hakkesteegt

29-Aug-07 23:47

There are probably more elegant ways of doing it, but one way that has worked for me is to create an example document in Word, save it as an xml file, and open the xml file with .net studio.

After that you can simply manipulate the xml file any which way you like, with your code, and finally save it programmatically as a Word doc.

My advice is free, and you may get what you paid for.

Help in VB.NET

Oguash27-Aug-07 23:30

Oguash

27-Aug-07 23:30

Hi,
I need some help in transmitting video data. I am using Visual Basic.NET
All the codes i have been seeing are in C, C++, or C#. Can somebody help me with thesame code in VB.NET
Thanks.

Re: Help in VB.NET

Christian Graus28-Aug-07 1:53

Christian Graus

28-Aug-07 1:53

All the code you see will use DirectX. The C# code in particular is trivial to use from your app in a dll, and should not be hard to convert, either manually ( thus teaching you how it's done in VB ), or with an online or downloadable converter.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Delete single line in VB 2005

Mekong River27-Aug-07 22:12

Mekong River

27-Aug-07 22:12

Hi, in vb6 if i want to delete a single line of code where the cursor is located, I need to press Ctrl+Y. So I have a question how could I do that in VB2005. Thank in advance.

Re: Delete single line in VB 2005

The ANZAC28-Aug-07 0:21

The ANZAC

28-Aug-07 0:21

if u move your mose to the left towards the line numbers, the pointer will change direction just before reaching the line numbers, clicking when the pointer is like this will select a whole line and can be used to select multiple, then you simply press delete. However, there may be a vb.net equivalent for what you are saying and perhaps google ca help you there.

Please check out my articles:
The ANZAC's articles

importing csv file in microsoft office spreadsheet 11 control using vb.net [modified]

babusat27-Aug-07 21:13

babusat

27-Aug-07 21:13

i want importing csv file in microsoft office spreadsheet 11 control using vb.net at runtime please help me

sathish

-- modified at 5:45 Tuesday 28th August, 2007

Delete Row on DataGridView

ryan11727-Aug-07 20:50

ryan117

27-Aug-07 20:50

I'm using VB.NET 2005. And I'm creating DataGridView of items one row each, you can create, edit or delete them, but I can only delete the item under the circumstance that no one has this item. What I want on the code is that the row can't be deleted if the code finds out someone has the item. The problem is that I can't stop the deletion of the row. How do I code to allow deleting a row or not?

Please offer any advice. Thank You Very Much

Re: Delete Row on DataGridView

Dave Kreskowiak28-Aug-07 14:43

Dave Kreskowiak

28-Aug-07 14:43

alurora wrote:
the circumstance that no one has this item

You how is your code supposed to know this?? What qualifies as "someone has this item"?? What item?? How is the status of who owns this item maintained?? Without knowing the answers to these questions, it's impossible to tell you anything useful.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Delete Row on DataGridView

Johan Hakkesteegt1-Sep-07 7:44

Johan Hakkesteegt

1-Sep-07 7:44

You probably shouldn't try to stop the user from deleting the row, but simply fake it, by checking that "no one else has the item", when the user deletes the row and then call YourDataSet.RejectChanges(), if someone does. In your code it will happen so fast that to the user it looks like he didn't delete the row.

Good luck,

Johan

My advice is free, and you may get what you paid for.

Make a button defualt on a dialogbox

jamilkhan00727-Aug-07 20:16

jamilkhan007

27-Aug-07 20:16

How to make a button default-button on a dialogbox????

(Jameel)

Re: Make a button defualt on a dialogbox

Christian Graus27-Aug-07 22:04

Christian Graus

27-Aug-07 22:04

Set the DialogResult property to OK and set the property of the form ( I think it's OKButton or AcceptButton ) to be that button. One causes the dialog result to be set when the button is clicked, the other causes the button to be clicked when you press enter.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Alternate and speedy code for it?

jamilkhan00727-Aug-07 20:12

jamilkhan007

27-Aug-07 20:12

I have created my custom button control and then used it in an animated keyboard, i.e. Not exactly a virtual keyboard that sends keys to current active programe, instead it just animates keyup/down on user keypup/down events. Now my code is somehow like this:

public sub keyboard.pushdow(key as keys) ''called on keyup or down events

for each button as myButton in myKeyboard.controls
if button.name.equals(key.tostring())
button.pushdown
'it can be button.pushup in case of keyup event
exit for
Next
end sub

now c that a button from within the keyboard with the same name which key is passed to block is animated.
e.g if user passes "A" then a button with name "A" is animated from with in the keyboard.
Now this whole subroutine is executed twice for each key press i.e Keyup/down events.
and keyboard respons is slow if u type fast bcoz it searches for a key twice for each key press. Frown | :-(

i tried this:

dim button as myButton= mykeyboard.controls(key.tostring)

bt it doesnt animate the corresponding key on keyboard. Confused | :confused:

Why? and any other soltion instead of looping through all keys Confused | :confused:

(Jameel)

Re: Alternate and speedy code for it?

Dave Kreskowiak28-Aug-07 14:46

Dave Kreskowiak

28-Aug-07 14:46

jamilkhan007 wrote:
for each button as myButton in myKeyboard.controls
if button.name.equals(key.tostring())
button.pushdown
'it can be button.pushup in case of keyup event
exit for

Yeah, that's about the slowest way to do it. A better method would be to add each button to a hashtable, or some other key/value pair collection and use the Key you get as the key to get at the button (value) in the collection. No for/next loop required.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Alternate and speedy code for it?

jamilkhan00728-Aug-07 20:32

jamilkhan007

28-Aug-07 20:32

Isnt it a collection
"dim button as myButton= mykeyboard.controls(key.tostring)"
actually "myKeyboard" is a user control and is made of user control "myButton"... cant i directly point a button with in the keyboard????
plzz explain what collection i can use and how. i m Confused | :confused:

(Jameel)

Re: Alternate and speedy code for it?

Dave Kreskowiak29-Aug-07 12:37

Dave Kreskowiak

29-Aug-07 12:37

I already did!! A HashTable!

Dim buttonsCollection As New HashTable()
buttonsCollection.Add(Keys.A, MyAKeyButton)

When you want to get at that button when the suer presses the A key:

Dim b As Button = buttonsCollection(Keys.A)

or something like that. It's written off the top of my head, so it could be a little wrong...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

determine check state of selected item of checklistbox

Rupesh Kumar Swami27-Aug-07 19:35

Rupesh Kumar Swami

27-Aug-07 19:35

hi all,
i want to determine whether or not the selected item of checklistbox is checked or unchecked. I know this is very simple question but i did not found method for this task.

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

Re: determine check state of selected item of checklistbox

The ANZAC27-Aug-07 20:43

The ANZAC

27-Aug-07 20:43

if me.checkedlistbox1.checkedindicies.contains(me.checkedlistbox1.selectedindex) then<br />
'do stuff<br />
end if

Please check out my articles:
The ANZAC's articles

Re: determine check state of selected item of checklistbox

Rupesh Kumar Swami28-Aug-07 20:01

Rupesh Kumar Swami

28-Aug-07 20:01

Thanks Anzac,
its work

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.