C# Discussion Boards - CodeProject

I get the following error when trying to run my ASPX page on my live server but it works FINE on my local test server. Where is the database connection settings for this as I can ONLY think that is the problem?
ERROR

System.Data.OleDb.OleDbException: Could not find installable ISAM.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.OleDb.OleDbException: Could not find installable ISAM.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.Data.OleDb.OleDbException: Could not find installable ISAM.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()

Other than this my files are as follows.
ASPX file:
--------------------------------------
<%@ Page Language="C#"%>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral"

%>
<mm:dataset
id="DataSet1"
runat="Server"
isstoredprocedure="false"
connectionstring="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_GKAUser"] %>"
databasetype="<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_GKAUser"] %>"
commandtext="<%# "SELECT * FROM tblWOL WHERE usern = ? ORDER BY usern ASC" %>"
failureurl="<%# "noaccess.htm" %>"
debug="true"
=""><parameters><parameter name="@usern" value="<%# (Request.Cookies["AuthenticateGKDUser"] != null) ? Request.Cookies["AuthenticateGKDUser"].Value :

"" %>" type="WChar">

<mm:pagebind runat="server" postbackbind="true">

<%@ Register TagPrefix="Portal" TagName="ImageCanvas" Src="ImageCanvas.ascx" %>
<%@ import Namespace="System.Drawing" %>

void Page_Load(Object sender, EventArgs e)
{

HttpCookie UserCookie = Request.Cookies["AuthenticateGKDUser"];
if (null == UserCookie){
Response.Write("No cookie");

//string UserCookieValue = "evlxtc";
}
else{
string UserCookieValue = UserCookie.Value.ToString();
//Response.Write(UserCookieValue);
};
//Response.Write(UserCookieValue);

int WOLScr1StrX, WOLScr1StrY, WOLScr2StrX, WOLScr2StrY, WOLScr3StrX, WOLScr3StrY, WOLScr4StrX, WOLScr4StrY, WOLScr5StrX,

WOLScr5StrY, WOLScr6StrX, WOLScr6StrY, WOLScr7StrX, WOLScr7StrY, WOLScr8StrX, WOLScr8StrY, WOLScr9StrX, WOLScr9StrY, WOLScr10StrX, WOLScr10StrY,

WOLScr11StrX, WOLScr11StrY, WOLScr12StrX, WOLScr12StrY, WOLScr13StrX, WOLScr13StrY;
int pWOLScr1StrX, pWOLScr1StrY, pWOLScr2StrX, pWOLScr2StrY, pWOLScr3StrX, pWOLScr3StrY, pWOLScr4StrX, pWOLScr4StrY,

pWOLScr5StrX, pWOLScr5StrY, pWOLScr6StrX, p.........etc
----------------------------------------------------------------

location of my DB is : C:\Domains\gkabayete.com\wwwroot\login\db\GKA.mdb (ON the live server)
-----------------------------------------------------------------

web.config is :
----------------
<configuration>
- <appSettings>
<add key="MM_CONNECTION_HANDLER_GKAUser" value="default_oledb.htm" />
<add key="MM_CONNECTION_STRING_GKAUser" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Domains\gkabayete.com\wwwroot\login\db\GKA.mdb;Persist Security Info=False" />
<add key="MM_CONNECTION_DATABASETYPE_GKAUser" value="OleDb" />
<add key="MM_CONNECTION_SCHEMA_GKAUser" value="" />
<add key="MM_CONNECTION_CATALOG_GKAUser" value="" />
</appSettings>
- <system.web>
<customErrors mode="Off" />
</system.web>
</configuration>
--------------------------

and my connection file is GKAUsers.asp:
--------------------
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_GKAUsers_STRING
MM_GKAUsers_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Domains\gkabayete.com\wwwroot\login\db\GKA.mdb;Persist Security Info=False"
%>

-----------------------------------------

WHERE else can there be a problem that I get this error? All my files is in wwwroot\login folder and connection file is in wwwroot\login\connection folder

----------

Should the location be in quotes or something since the one dir has a dot (.) in "gkabayete.com"???

this is me

This isn't necessarily a connection string problem. Check this[^] out for more info. If you google the error message you'll find lots of pages which talk about it.

Josh

You looked in your web.config?

This line:

ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_GKAUser"]

says it gets it from there.

Regards,
Rob Philpott.

can you answer me at http://www.codeproject.com/script/comments/forums.asp?forumid=1649&mode=all&userid=1711764&select=1473533&df=100&tid=1473533#xx1474127xx[^]

tnx

-- modified at 9:57 Friday 5th May, 2006

No.

Perhaps here: thread[^]

---
b { font-weight: normal; }

yes, can you help me?

i have problem with next code - " could not found StringSplitOptions"

string text = "This is my string";

string[] words = text .Split(new char[1] { ' ' }, StringSplitOptions.RemoveEmptyEntries);

TotalWords = words.Length;

is anybody knows how to deal wit hthe problem ?

eyalso

hi,

dont know how good is this method.i did like this last time

String tmp =Words;
do while(tmp.indexOf(" ")>0) // Do while you find two continuous spaces and remove those..
{
tmp = tmp.Replace(" "," ");
}
int TotalWords = tmp.Split(' ').Length;

Where there is a will,there is a way.

It's only in framework 2.0
Namespace: System
Assembly: mscorlib (in mscorlib.dll)

Best regards, Alexey.

how can i show scrollbars on picturebox, i dont want to show an image as streched. I like to show on normal mode. but sometimes image is bigger than picturebox sizes. so i cant see other pice of image .

Put PictureBox on Panel, set size of PictureBox equal to image size, and set Panel AutoScroll property to true.

Best regards, Alexey.

I have been researching ClickOnce deployment, and I am very curious to hear from a few folks who have actually used it and deployed with it and had remote users updated with it, and, hopefully, someone who has used some of the advanced technical capacities offered in it such as scripting.

thanks, Bill

"The greater the social and cultural distances between people, the more magical the light that can spring from their contact." Milan Kundera in Testaments Trahis

how do I convert a C# program into a windows installer? tips and advise would really really be of help.

or maybe there's a software i can use to change my C# program into an installer. Smile | :)

You should create a setup project for your application. Don't try to make your application install itself. Visual Studio has support for creating setup projects. There are many articles that show how to do it.

Josh

Hi all,
What is the best way to deal with the next problem:
I Have a ASP login page with codebehind C#
The user is allowed to login more then once on the same computer. But he is not allowed to login more than once on different computers.

should I keep record of it in a database with which ip address a user is logged in or are there other ways?

thanks in advance.

IP address will not work because the multiple computers could be behind a firewall that does Port Address Translation. The server cannot distinguish machines using IP address.

Even though I know that IP addresses won't work, I don't know what will.

Thomas

modified 29-Aug-18 21:01pm.

Curious though. Why do you have this strange requirement? Maybe, I can think of some solution if I understand the problem better.

modified 29-Aug-18 21:01pm.

It's for an intranet application. Everyone in our company has their own computer so normally they would only logon on one machine. Since every user has different roles it could be possible that someone stole a password to do things they're not allowed to. It's like msn messenger, it automaticly logs of on one computer when you login on another one. Except that we would like to make it impossible to login when the user is already logged in on another computer.

I hope this makes it a bit more clear.

You are making it clear. Since it is an intranet application, the use of IP address may not be a problem. But, the networking guys has to make sure that there are no devices on the network that makes network packets from multiple machines look as though they came from the same IP address.

======
Now, being interested in computer security, and having done some work in that domain (not a whole lot Smile | :)

)

But, IMO, as a security measure, the mechanism you are proposing will work only against casual attackers. A more determined attaqcker would use the other employee's machine during lunch break, or after work. There are many other ways to compromise the security, but you may want to consider the following.

Stealing a password should not be that easy. Why do you think that you need to protect against a stolen password? You have to make sure that employees have proper passwords, and that they are changed often --

a. They should be forced to change passwords every month
b. They are not allowed to use the previous N passwords, when changing passwords.
c. A password complexity check has to be implemented.
d. All communications should be done through SSL
e. Do not allow multiple logins at all. Timeout inactive logins after a reasonable time period -- whatever is reasonable for you application.
f. Username/passwords have been proven quite inadequate for many purposes, forcing some firms to use biometric devices like finger print detection or an eye retina scanner.

modified 29-Aug-18 21:01pm.

Thanks for your reply and I'll certainly take in mind some of the things you proposed. Although finger print detection or an eye retina scanner if a bit far fetched Smile | :)

Dimitris

hi

i want to count the number of words I have in string (is anybody has code example )

thanks

eyalso

Here is the sample:

<br />
string text = "This is my string";<br />
string[] words = text.Split(new char[1] { ' ' }, StringSplitOptions.RemoveEmptyEntries);<br />
int countWords = words.Length;<br />

Best regards, Alexey.

I have a problem with " StringSplitOptions" (cant find it)
i need to import a class or dll ?

eyalso

This enumeration added in framework 2.0.
If you're using framework 1.1 use this code:

<br />
string text = "This is my string";<br />
string[] words = text.Split(new char[1] { ' ' });<br />
int countWords = words.Length;<br />

Best regards, Alexey.

For example,you have picture(is painted with solid colors not gradiant) at mspaint,
I would like to change all X color to Y color.

How could i achive that?
Is there any method at Drawing class (i coulnd find any :'()