|
A trusted connection only works if you have a domain account, so that it's the same account on both computers. Otherwise you have to use an SQL Server login.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
|
Hi
I solved this problem by enabling the TCP/IP protocols in SQL Server Configuration Manager...
hope this helps!
Anoop
|
|
|
|
|
This can be done only if we have SQL express edition instaled. But if i am using mdf in the project like in VS 2005 then i need to connect to another mdf file on network
|
|
|
|
|
Hii
I want to change the back color of selected dated in month calender.
Like i have appointments on following dates 1-10-2008,5-10-2008,10-10-2008,15-10-2008
so i want to show these date back color is green.
How can i do this.
Please suggest.
Thanx
Mitesh Khatri
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
Hi Mitesh,
You can only show a range between to dates wiith different backcolor in the month calender control but you can not show for that different different dates(not in range).In range all the dates witll have same color.
Thnx
|
|
|
|
|
hi,
my problem is that.....
Recently i get a complex xml.Which have huge no of data.When i read xml by dataset i get 6 realated tables.Each have 10 to 20 no of coloumn.so i want to directly move this data to sqlserver database.
please help me
modified on Wednesday, October 1, 2008 5:12 AM
|
|
|
|
|
Hello,
So you basically wants to move the XML data into the SQL server. If you are trying to do
this through code, then you can have a look at the given web link which should give you
some fair idea on how to achieve this.
http://www.dbazine.com/sql/sql-articles/cook2[^]
Hope this will help.
Regards,
Allen Smith
ComponentOne LLC
www.componentone.com
|
|
|
|
|
hi Allen,
Thanks for your suggestion.I think it will work if i create related table first. But i do not want to create table by myself.i want something dynamically to store it from dataset to database.
Hope you help me again.
|
|
|
|
|
You just need to issue a create table statement first, surely...
|
|
|
|
|
|
Hi, is that a way using VB6 to check printer status whether it connected or not connect to the printer device before print any job?
Please comment.
Thanks in advance.
Regards,
Jy
|
|
|
|
|
Hi all,
I have a server application awaiting incoming connections through a series of sockets set in "listen" mode. I have a number of client applications in remote locations that communicate via tcp/ip, opening the corresponding socket connection to the server and transmitting data.
The problem I have is that the client-to-server socket connections seem to die out after a while, specially in locations where internet is intermittent. When this happens, the connection does not terminate, rather it stays in "connected" state, but data transfer is lost in the web. Even though the winsock.state = sckConnected, the data is not received.
In order to solve this, I implemented a refresh timer, that closes and reopens all sockets in the server once every n seconds. It works, but it's terribly unelegant. I have found no other way of doing this, keeping the connections alive.
Anybody could please give me a suggestion on how this can be done properly? How can I determine if a connection is alive or dead, regardless of what .state says?
Thanks,
Regards.
|
|
|
|
|
are you using win sock . I had the similar problem before using win sock where i lost data even the client was connected with the server.
But later i used dart sock and it helped me you can get the trial version of these from www.dart.com and try it out, hope this would help you.
|
|
|
|
|
Yes, I use winsock. Thanks for the tip!!, but I think I might have solved temporally in a rather clumsy way.
I set up each client to "ping" the server every second. The server "pongs" to each "ping". I there is no "pong", the connection is down and a reconnect is issued. This check is performed at both sides.
Unelegant, but it works, and it´s free...
Has anybody implemented a different type of "keep alive" mecanism?
Regards,
|
|
|
|
|
I am getting ORA-01036 (Illegal Variable Name/Number) when I call the oracledataadaptor.update method.
I am able to fill the dataset & bind to the datagridview. When I try to update Oracle with the dataadaptor,
I get the Illegal Variable name exception.
Any ideas?
Thanks in advance!
' '' ''' '''' Call the update method
Try
daCustomers.Update(ds.Tables("Customers"))
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
' '' ''' '''' Set up Oracle Update Command
Private Sub SetCommands()
Dim uCMD As New OracleCommand
uCMD.Connection = cnOra
uCMD.CommandType = CommandType.Text
uCMD.Parameters.Add("@inFNAME", OracleType.Char, 30, "FNAME")
uCMD.Parameters.Add("@inID", OracleType.Int32, 12, "ID")
uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"
daCustomers.UpdateCommand = uCMD
End Sub
|
|
|
|
|
The syntax of bind variables depends on the connection type you use. Try using : instead of @ . For example:
kermit888 wrote: uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"
uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = :inFNAME WHERE ID = :inID"
The need to optimize rises from a bad design
|
|
|
|
|
I tried switching the "@" with ":" but got the same result.
|
|
|
|
|
Did you also replace it in parameters. You could also try without semicolon and perhaps with less info to the constructor. Meaning, try both variations:
uCMD.Parameters.Add(":inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add(":inID", OracleType.Int32) and
uCMD.Parameters.Add("inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add("inID", OracleType.Int32)
The need to optimize rises from a bad design
|
|
|
|
|
I'm having problems using the Web Browser control in Vista. When I go to a page with any type of Flash Content it won't load. I went to the Flash plugin page and it said 64bit web browsers are not supported. This only happens on the Web Browser Control that I am programming with. If I just open the Microsoft Internet Explorer 7 it works just fine and has no problem loading Flash content. If I can't display Flash content it's a big problem so if anybody can point me in the right direction it would surely make my day.
Thanks In Advance
PS I have tried both the com version and the one that comes with VB.Net
both will not display Flash Content
I am using Vb.Net 2008 Express
Operating System Vista Home Premium Service Pack 1
Ken
|
|
|
|
|
Hi Guys...
i am using vs2005 to develeop my apps.
i need to install a simple application that uses crystal reporting on a windows server 2008 environment.
the error i am getting is that when i call up my report it reports back an error stating that i dont have the right CRRedist*.msm installed......
i have included in my mergemodules the Crystal Redistributable 2005_x86.msm.....
does anyone have an idea where i can get the 64 bit msm file from as i searched google and business objects but cant find it....
thanks in advance
Anoop Brijmohun
|
|
|
|
|
Hi
Am a newbie on VB.NET...Please i would like to know how would i authenticate users on the web application using their domain name and username (eg. FVCJBN01\F2999999) and also get their roles here is how my User table looks
USER_EMPL_NO F2999999
USER_LOGIN FVCJBN01\F2999999
USER_NAME Lisa Lopes
USER_CO_CODE 80
USER_BRN_CDE 189
USER_EMAIL lopes@test.co.za
USER_TYPE AdminOnly
HEAD_OFFICE_FLAG 0
USER_ACTIVE_FLAG 1
the application should pick up the user from their machines where they have logged on with their user authentication and check it against the database
|
|
|
|
|
Hi,
I am writing a programe for project report. i need code in vb.net 2005 for send SMS or dial phone no th Atteched mobile Mobile on PC.
How it will Possible.
PLZ Help me.
Thanks & Regards
Form :-
Vikash Yadav
|
|
|
|
|
What have you tried so far? Searched on Google?
|
|
|
|
|
first detect the communication port which u r connected mobile to the pc.
open the communication port.
and send commands.
to send SMS:- at+cmgs="+919000234140"<vbcrlf>
>hi <ctrl+z>
to dial number :- atdt+91900234140;<vbcrlf>
** note : the above commands are not suitable for all mobile manufactures.
there may be a change in the command, so search the AT commands list in internet(recommended GOOGLE).
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|