|
Hi,
I am creating a windows service that will process exe file( Developed in VB and connects to database using DSN and sa/master login).
When service process exe I am getting Database (Sql Server 2005) error "login failed to user sa.."
Code I am using:
Process p;
string FilePath = @"C:\vb_file.exe "; // vb_file connects to DB Sql Server 2005
string arg = " /send";
p = Process.Start(FilePath, arg);
Error I am getting...
The VB Application identified by the event source logged this Application vb_file: Thread ID: 5748 ,Logged:
vb_file Rev. 30-Apr-03T /send /RESTART
vb_file Rev. 30-Apr-03T /send /RESTART
Error 40002 in SQL.InputConnect: 28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. [Aborted]
Please help...
Thanks
Taduri
|
|
|
|
|
hey can spread more light on ur proble,bcz i cant get it..r u write all code in Vb and from which language are u calling function
|
|
|
|
|
Don't use TxtSpeak. It makes your posts difficult to read. You've got a full 101+ keyboard in front of you, use it.
|
|
|
|
|
From the error message, it looks like your "vb_file.exe" used the wrong user name and password in its connection string to contact the database.
|
|
|
|
|
Thanks for reply...
Vb_file.exe is using correct username and password, it is using systemdsn to connect Database.
If I open start -> Run and type C:\vb_file.exe /send it is working fine and displaying GUI... and I checked in Event Viewer -> Application log it was not displaying any error.
same thing I am doing in Windows service written in C#..
My Intention is just display VB Application GUI through Windows Service...VB Application is connecting to DB using SystemDSN
Code I am written..
Process p;
string FilePath = @"C:\vb_file.exe ";
string arg = " /send";
p = Process.Start(FilePath, arg);
Service Interactiing with Desktop option is selected...
Once I started service and checked Event Viewer -> Application log ..it is showing below error...
Event Type: Error
Event Source: VBRuntime
Event Category: None
Event ID: 1
Date: 7/13/2007
Time: 9:33:41 AM
User: N/A
Computer: xxxx
Description:
The VB Application identified by the event source logged this Application vb_file: Thread ID: 2704 ,Logged:
vb_file Rev. 30-Apr-03T /send /RESTART
ODBC condition 18456, State=28000, RetCode=-1
28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
Please let me know if you need further info..
Thanks in advance
Taduri
|
|
|
|
|
Why, oh God, WHY does anyone insist on using a DSN?? It's competely useless in today's environment!
It's using the correct username and password to login to the database, huh? Then explain this message to me:
Login failed for user 'sa'.
It's most assuredly NOT using the correct username and password to connect to the database. Scrap the DSN, you do NOT need it, and use the correct connection string in your VB code. Since you'll be running this from a Windows Service, you can NOT use the "Trusted Connection" option in your connection string.
|
|
|
|
|
Hi Dave,
I was using old VB Exe in my windows service application, it was developed 7 years (I guess) back...
any ways Thanks for info that "you can NOT use the "Trusted Connection" option in your connection string"
Thanks
Shyam
|
|
|
|
|
Hi,
I want to develop project which need to reconigze finger image from nitgen fingerkey hamster
so please provide me source code for which has to extract finger print for enroll and verification
balakeishna
|
|
|
|
|
First of all, this is not a 'give me all the code' site. Google is the site you need to try to find existing articles to do what you want.
Second, if you have a finger print reader, it should provide the APIs to do that, you shouldn't need to have to write them yourself.
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 )
|
|
|
|
|
Christian Graus wrote: this is not a 'give me all the code' site
I wonder what gives people that impression?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
A "fingerkey hamster"? Pull the other one...
|
|
|
|
|
|
How to pass multiple values from one form to another via URL ?
|
|
|
|
|
you can use querystring with multiple parameters to pass multiple values to other page...like....
Response.Redirect(page.aspx?Orderid=" & Orderid "&ProductID=" & ProductID)
Tirtha
Do not go where the path may lead, go instead where there is no path and leave a trail.
Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
|
|
|
|
|
This is the windows forms board, how is it yuo want to pass stuff via a URL ?
If the data is stored in the DB already, you can just pass an Id to get it from the DB. You can also do cross page postback in .NET 2.0, or you can use the URL, as someone has already said.
There's also the session, but that would be my last port of call.
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 )
|
|
|
|
|
Hi,
I am working on a custom UserControl that needs to AutoSize itself to fit it's contents.
It doesn't use any of the traditional Text, Font, Other Controls, etc and all the content generation is done with GDI+
I am overriding GetPreferredSize to return the size that I want the control to be, and when I set the AutoSize property to true, the control sizes correctly.
I have some custom properties that when changed will make the control have to grow or shrink to accommodate the updated contents but for some reason I just can't figure out how to make the control update it's size in response to these custom properties.
Could anyone point me in the right direction to sort this out?
Regards,
Heffo
|
|
|
|
|
One idea that comes to mind is to create a custom event. This is not a trivial task but you could define your own EventArgs which could hold the hold the new Size value. You could then fire the custom event everytime you update a GDI+ graphic.
Cheers!
Richard
may your code be error free
|
|
|
|
|
I do this in visual studio 2003, to get value from datagrid.
String myValue;
myValue = dataGrid1[dataGrid1.CurrentRowIndex,0].ToString();
does any one know to get value from datagrid using visual studio 2005
Thanks for help
|
|
|
|
|
Datagridview.CurrentCell returns active cell and DatagridView.CurrentRow returns the row containing the current cell. DatagridviewCell has property called value. I think it is easy to guess what it returns 
|
|
|
|
|
Thanks it solved my issue.
|
|
|
|
|
Hi all,
I have a MDI names as MainForm and in that MainForm MDI i have a menu item names as File
to the File Menu item i have a form named as 'Employees',
Here in my 'Employees' form i have a button names 'AddEmployes'
Whenever user clicks on 'AddEmployes' Button a form named as 'Employee Details' will opens,
NOW MY PROBLEM IS --When the user selects one employee department of 'Employee Details' Form and selects Save Button of 'Employee Details' Form
data of THE 'Employee Details' Form is saving and the 'Employee Details' Form is CLOSING..
ALL I need is i need to make the Employee details form to be in to the same state allowing the user to select another option..
I've tried in several ways,(taken Dialog box at last) and left with no answer,
I don't want to use DialogBox option,,,
Please help me
Thanks in advance
Prashanth
|
|
|
|
|
Did you get the answer to your question?? Your question is not 100% clear. What I understand is when you click on the save button, after saving, your form closes down. Well, the only way it will close is when u ask that for to close. Just remove that code.
If my comments does not make any sense, send me the code snippet so that I can see whats going on.
Cheers.
|
|
|
|
|
can u send me Snipset of ur code..so get ur problem?
|
|
|
|
|
Hi,
I don't want my user to be able to type in a new item into my combobox, but I can't seem to find a property to set this. Seems logical that there should be one though, is there?
edit: I realize that a listbox would be an option, but I want to have a combo box styled control for this application.
edit 2: Problem solved, for future reference: set DropDownStyle to DropDownList (rather than just DropDown)
Thanks (anyway)
-- modified at 5:53 Thursday 5th July, 2007
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
