|
Sir,
I make connection with the statement-
dim con as new sqlconnection("Servername with database and uid ,pwd")
I am using sqlexpress edition.also
when i execute my project after coyping complete project to any local machine from server it gives my form without error and if i try to execute same project on the server location it gives permission error.
i also copy bin folder to server from local machine to server location and try to execute it from there,i means to say i try to run exe from server its shows permission error.As this having compiled code.
tell me solution what i have to do for it.
ajeet
|
|
|
|
|
Right, did you read my reply to your original post?
If it's giving you a permissions error its to do with the permissions ... it's pretty easy to work out.
|
|
|
|
|
Ok! So whats your connection string like? By default, SQL 2005 Exp. Ed. only has SM enabled. If you want to use TCP/IP or named pipes, you need to turn it on using the SQL Server Configuration Manager.
My guess is that this all will go over your head. But let me put it this way.
1) You cannot remotely connect to SQL Server Express by default. You need to configure it to accept rmote connections.
2) If your connection string resembles something like this
Data Source=.\SQLEXPRESS;AttachDbFileName=e:\data\aaa.mdf;Integrated Security=True;User Instance=True
Then you're using shared memory to access it.
3) If the above is true, you need to copy the DB file to the "other" machine as well, and I guess it also should have Express Edition installed.
(Or)
If you want to enable remote connections, change your server configuration using the server manager and change your connection string. And that would seem pretty complicated if you do not know what you're doing.
So for a start, start reading the Express Edition documentation.
SG
|
|
|
|
|
And on top of what Simulation said, if you copied the code to a file share and are running the code from that share, you need to take into consideration Code Access Security. Managed code running from ANY non-local source (i.e.: network) runs in a restricted sandbox. If I understand your explaination correctly, this is probably where your "Security Exception" is comming from.
Bascially, the users machine doesn't trust your code. You have to tell it to trust the code. Read[^].
|
|
|
|
|
I'm trying to make windows local users with VB. This is no problem. I'm stuck trying to set the environment settings for that local user. For starting after sign on with RDP. Is this possible anyway? Maybe somebody can put on the right direction.
|
|
|
|
|
When I migrated my app, which has worked fine on many machines, to a new one, it didn't run. I would see the hourglass for a second, then nothing.
So I installed VS on that machine and compiled the program.
The debugger does the same thing... just stops. However, sometimes, when it is trying to display a simple message box it gives me:
System.AccessViolationException was unhandled
Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
I have no idea how to deal with this error.
thank you.
|
|
|
|
|
There seems to be as many different causes as there are reports of this kind of problem. About the only thing you can do is start going down the list[^] and checking out possibilities.
|
|
|
|
|
Are you doing anything with Office in your application? I received the same error message on my development machine after I installed Outlook 2003 and and leaving Office 2002 installed. It turns out this error was caused by different versions of the Office Assistant being installed on the machine. In which case I disabled the office assistant for Office 2002. Don't know if this helps, but just trying to share my experience.
Mike Lasseter
|
|
|
|
|
Hi! All,
Can anybody tell me how to check the availability of a database connection in VB?
Thanks and Regards,
virendra
|
|
|
|
|
hi virendra,
if you have created the recordset then check for
recordset.state property
if
recordset.state = 1 then connection is open
and if it is '0' then connection is close
best regards,
koolprasd2003
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
Hi,
I think you mean <connection object="">.State property.
For eg:-
dim adocn as new ADODB.Connection
Then we can check whether connection is open or not by adocn.State
|
|
|
|
|
What do you mean?
I'm purely guessing at what you want, but about the only way to know is to actually TRY the connection and see if it fails.
|
|
|
|
|
Is it possible to set the margins of the windows taskbar like media player 11 does when it is in minimze mode. What i mean is, can we have a form sit over the taskbar and not have the handles for the open or minimized windows flow under it? Is this possible.
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
I have no idea what you're talking about. When you minimize WMP11, you get the option of turning on a ToolBar that a mini-WMP player occupies.
I have no idea what you're talking about when you say:
The ANZAC wrote: can we have a form sit over the taskbar and not have the handles for the open or minimized windows flow under it
This is going to require further explaination.
|
|
|
|
|
your right. Sorry that was a bit vague. I've since done some research and found that the thing i need is a deskband application. When WMP11 minimizes to its mini toolbar it is using deskband correct? I tried to find vb.net source code for a deskband but there is virtually none, i think i'm gonna have to take that leap and start the move to C#.
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
The ANZAC wrote: I've since done some research and found that the thing i need is a deskband application.
That's what it is.
The ANZAC wrote: I tried to find vb.net source code for a deskband but there is virtually none,
True. Most examples are going to be in C++, others in C#. it's very much possible to do it in VB.NET though. All it would take is translating the C# code.
|
|
|
|
|
Hi All!
If anybody could plz show me a simple example of BackGroundWorker class, Just do understand its working.
Regards
|
|
|
|
|
|
Thanks A Lot!!!!!!
Do u have any other link
Its not making clear which method of my code will run in background
Regards
|
|
|
|
|
|
The method you specify, runs in another thread. The events it fires for progress and for the thread ending, occur in your main thread. This is good, you can use these to handle any UI updates.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 there..
Can I get the count of errors which have occured during the running of my project? If Yes, how??
The name is Sandeep
|
|
|
|
|
you can compile .net code on the fly.
There is an article by Jim Rogers here.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi, Thnx for your interest. But frankly speaking.. i didnt get what you said. My question is corresponding to VB..
The name is Sandeep
|
|
|
|
|
Did you go through the Link which i have provided there?
Regards,
Satips.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
