|
What's the size of your project? If you are going to have more than a handful of people access this then do not use Access over the web. It's slow! The DB can't grow past 2GB and Access can't handle more than 64K rows in a table.
Bart-Man wrote:
The file exists on the server, and I can actually download it via a browser, so
it appears that there is no apparent security problem.
Never, ever, allow anyone to download your database. Move it out of a public folder pronto. But, do make sure you have write permissions for the folder the MDB is in so it can create a lock file.
Try this for your connection string...
"Provider=MS Remote; Remote Server=http://somewhere.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\somewhere\my.mdb;"
If you require a login to the database you can also specify User Id and Password in the connection string.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Thanks for your reply, and your suggestions about access db and it's limitations!!!
For now I am stuck using it since only a few people use the db, and they are sticking
to access.
Here's what I did.
------------------
1.) I moved the database from the public folder like you suggested.
2.) Checked the folder to make sure it had write permissions.
2.) Tried the connection string you provided and it worked great!!!
I can now connect to the database!!
*3.) ++My Problem now++: I can't seem to get the recordset to do anything.
I just did a simple query of "Select * from Table1".
and I get the error "Internet Client Error: Invalid Server Response".
I checked, and "Table1" is a valid table within the database
Is this a security setting that I didn't set right?
At any rate thanks for helping me with the connection string.
|
|
|
|
|
Bart-Man wrote:
and I get the error "Internet Client Error: Invalid Server Response".
How exactly are you accessing this DB? Is it from a program or within an ASP page or what?
Bart-Man wrote:
At any rate thanks for helping me with the connection string.
No problem.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
A program...is that the problem should I use an asp page instead?
|
|
|
|
|
Bart-Man wrote:
A program...is that the problem should I use an asp page instead?
No, not at all.
Could you tell me what language you are using? RDS (what you are using) over ADO is idenpendent of language, but I'm gonna try and past a code sample for ya.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Jeremy Falcon wrote:
Could you tell me what language you are using?
I am using Visual c++ 6.0 to connect to the database.
Cool, thanks for your help!
|
|
|
|
|
|
It is weird I used microsoft's sample, changed the connection string, and it still does not work.
I noticed something odd about when I connect a "First-chance exception" ocurrs, but my exception code does not catch it. It appears that an access problem occurs on the server side.
I am trying to configure the rds, so that it will allow access..
After several attempts, it still does not work correctly. An msdn article suggested that I download msadc sdk and use that to test that the Rds is working correctly.
At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.
|
|
|
|
|
Bart-Man wrote:
At any rate I think the connection string is right, and my query code was right. But the rds is not setup right.
Ok, if you get the solution I'd love to hear about it. Inquiring minds wanna know.
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
I figured it out, it was a configuration problem in rds.
It took awhile to find it buried in msdn, and after many cans of mountain dew.
See the link below for the solution:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdhowconfigurerdsonwin2k.asp
|
|
|
|
|
Bart-Man wrote:
and after many cans of mountain dew.
You could be on one of their commericals for this! Mountain Dew helps solve crisis!
Thanks!
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Is it possible to define and use variables within a query in Access?
I've tried DECLARE, but it didn't work.
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
PARAMETERS test Text ( 255 );
SELECT Table1.ID1, Table1.name
FROM Table1
where name = [test]
|
|
|
|
|
Thanks.
I'm keen to do something similar to this:
DECLARE @EntTypeID int
SELECT @EntTypeID=0 --init
SELECT @EntTypeID = ( SELECT [ID] from tblEntityTypes WHERE [Descr]='BLAH')
--do something with the @EntTypeID var. Anyway to implement this in Access 2000, XP?
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
Well, you can have query with parameters and access them from Access Basic, however I do not know how to get functionality as you want within one query. When you will write code in Basic and use several queries then you can simulate your code.
|
|
|
|
|
Another question about SQL Server.WHat stored in transaction log file?
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
|
Again thank you.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
I have a question about CREATE DATABASE in SQL Server2000.It has a parameter named FILEGROWTH and COLLATE .Could someone explain them for me? Thanks.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Mazdak wrote:
FILEGROWTH
As you are adding data into the database, more and more space is needed. When used space will reach the size of the file, then SQL Server will extend that file by amount specified in the FILEGROWTH.
Mazdak wrote:
COLLATE
COLLATE specifies how you will order strings in the database, depending on selected language. There are different rules to order strings in the different languages.
|
|
|
|
|
Thank you.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
COLLATE specifies how fields are sorted, and FILEGROWTH specifies the increment in which the file size will increase when needed if the DB has its assocated files set to autogrow.
Here's a snippet from MSDN to give you a better idea about COLLATE...
COLLATE
Specifies a collation sequence for character fields in subsequent indexing and sorting operations.
...
Note When you specify the SPANISH option, "ch" is a single letter that sorts between "c" and "d", and "ll" sorts between "l" and "m".
Jeremy Falcon
Imputek
<nobr>"..." - Paul Watson 07-17
|
|
|
|
|
Thank you.
Mazy
"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down
|
|
|
|
|
Hello,
I am trying to figure out a way to get different characters from different fields to auto-produce a string to display to a user on a web page. For instance, if you enter your name as John Doe and your SSN is 000-00-1234, then I want to be able to go to the firstName, lastName and SSN fields and get only the FIRST letter of the firstName & lastName and the LAST three of the SSN and put them together and add them to the userID field in the table (i.e. JD234). Right now, the SSN fields are split as ssn1, ssn2, ssn3, and are combined and entered into the SSN field as xxx-xx-xxxx.
I would also like the capabilities of creating an ID based on two different things. For instance, if they supply an employee number INSTEAD of an SSN (we are currently changing our ID naming scheme, but not enforcing it at this time), then I would like to take the FIRST letter of the firstName and the last (6) of the employeeID and create the userID from that...do I use an If...Then...Else to see which they entered and produce the ID? Keep in mind that I want to do ONE of the OTHER, but the new scheme (using the employeeID field) takes precedence. Anybody out there done this before?? Thanks for your help!
|
|
|
|
|
MySQL Has the following core functions:
connect(), query(), store_result(), fetch_[row, feild]() num_rows(), num fields(),
escape_string(), and close()
There are others, but those are the most used.
Data returned is all characters, and and you get to the data by:
row=fetch_row(query_result);
and row[N] = field N, it's that simple!
Is there anything that simple for ADO or ODBC? I'm trying to port a MySQL app to SQL Server, and having a hard time finding anything that simple. My real concern is handling user-defined queries. In MySQL it was as easy as:
con=connect();
query(con, user_sql);
result=store_restult(con);
feilds=num_fields(result);
while (row=fetch_row(result)){
for (f=0; f
|
|
|
|