|
So I did some research and it turns out
Microsoft.Jet.OLEDB.3.51;DATA SOURCE
is the proper connection string for access 97 datbases and the one above is for Access 2000...???
My book says one thing and 3 sites I just visted says the other...???
Anyway...I tried this new connection string and still no luck, so i'm still baffled as to how to make this work.
I'm using and ASP script on PWS win 98 w/ access 97 installed...
Anyone have any ideas...?
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Yippy
I just figured it out!
I used the following:
DB.Open ("Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" + "C:\PCSpectra.mdb")
And it works I think...
DATA SOURCE isn't the same as Data Source....cuz thats all I changed
Also I originally tried:
DataSource and that caused a "Couln't find a valid ISAM"
Or something like that...
Anyways...hopefully everything works now.
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
It is old though. Upgrade your database components. I believe MDAC is what you need to upgrade. Go to Microsoft's site and search for MDAC download
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
How to debug a COM object called from ASP?
Server-side I mean
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
I don't think you can debug the actual COM object. When I need to debug my COM components I fake it - I created a VB project and copied the COM component's code to the form, then in form_load I called the function I need to debug.
|
|
|
|
|
Greetings,
I am having problems getting access to registry information from an ASP page.
I have a web server set up with an ATL com object that queries the registry for information. On this web server I have an ASP page that calls the registry com object from script.
My problem comes in when I have a computer on a the same local network make a call to the asp page to get information from the web server's registry. No information is returned from the registry(if I hard code values in for the registry values that I return they get returned via the ASP page). It seems like there is a security issue, but I am not sure. Any suggestions?
Thanks in advance.
|
|
|
|
|
I hate having a problem, and being stuck on it for awhile, making a post, and right after making the post for help I find the solution.
The solution is to adjust the properites of the ASP page in Web Services under "file security", and select a user that has administrator access rights to login as. Pretty simple to do, but it took awhile to find.
|
|
|
|
|
Nice, good to know, I will need it too soon
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Excellant, I am glad my post could help!
|
|
|
|
|
i have a parent window.from that i move to a child window(a popup).then i add records to database.the child window has two textfields to enter the data.After the data is entered,the user clicks the submit button and the page is taken to a page where database is updated and after updation the user is redirected to the child window.
what i want is as soon as updation takes place in the database,the parent window should be refreshed and changes shud be shown in parent window.i don't want to use <meta> tag.
please reply soon.
|
|
|
|
|
<script>
window.opener.location.reload();
</script>
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
I have the TreeView Menu in which there are branches and leaves and when i click on the branch the menu will be unfolded to leaves and in that i want some leaves to be DISABLED and the remaining to remain ENABLE How to DO IT ANY BODY PLEASE HELP ME OUT . the demo version is available at http://www.codeproject.com/useritems/dhtml_treeview.asp
B.Rama Kanth
balina@pun.cmc.net.in
|
|
|
|
|
Hi guys. This morning before work I fired up VS7 and threw a SqlConnection onto a webform and tried to open a connection to a database. I got a SqlClient error stating that "Login failed for user mydevmachinename\aspnet".
Where does this come from? And why am I able to do the exact same thing on a Windows Form without an error?
And yes, it is my first foray into the world of web and database programming
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
By default all ASP.NET web applications run under the username ASPNET. Also by default you attempt to connect to SQL Server using the current windows login, since you are running it from ASP.NET you are trying to login from the mydevmachinename\aspnet account.
On a Windows Form you don't have the problem because the application runs in the context of the current user (ie you).
James
Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971
|
|
|
|
|
Thanks James, so must I create a username called ASPNET with rights to the database?
Just another wannabe code junky
|
|
|
|
|
Yep
James
Simplicity Rules!
|
|
|
|
|
Gotcha, thanks again James. Oh and by the way, it would REALLY be nice if some day YOU actually ASKED a question as well you know!!
hehe
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
Senkwe Chanda wrote:
Oh and by the way, it would REALLY be nice if some day YOU actually ASKED a question as well you know!!
Does this one count?
You know, its odd that I don't ask questions; I'm certainly stumped enough that I should be :-P
James
Simplicity Rules!
|
|
|
|
|
you can also sign in with UsserName SA and the password blank like this
Myconn = New SqlConnection("server=your server\NetSDK;initial catalog=pubs;user id=SA;password=;") I ran into the same problem as you and this works great
Paul
|
|
|
|
|
Hi there,
What is difference between: CreateObject and Server.CreateObject ???
Both of them can make instance from COM object !
So, what is difference ?
My month article: Game programming by DirectX by Lan Mader.
Please visit in: www.geocities.com/hadi_rezaie/index.html
Hadi Rezaie
|
|
|
|
|
Server assumed and can be skipped. You can use with same effect Server.MapPath and MapPath or other Server methods
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
You may want to check this out:
http://www.4guysfromrolla.com/webtech/043099-1.shtml
Cheers!
|
|
|
|
|
I am using this statement to return some records. The statement using the ASP variable ActiveID to pull records according to categories.
This works fine, but I can't seem to add further variables (e.g. How would I add an ORDER BY statement to this?)
RS1.Open "SELECT * FROM Table WHERE Cat_ID =" & ActiveID, DB1, adopenstatic
What I really want to do is return records updated in the last seven days or so. I have the last modified value stored in a table in the format DD/MM/YY -- is it possible to do a SQL query that will only return records updated in the past seven days?
|
|
|
|
|
Garth wrote:
How would I add an ORDER BY statement to this?)
RS1.Open "SELECT * FROM Table WHERE Cat_ID =" & ActiveID & " ORDER BY Name", DB1, adopenstatic
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
this should get records updated only in the last seven days as well but I haven't checked this yet as I'm late for work
strSql = ""
strSql = strSql & "SELECT * FROM Table WHERE Cat_ID =" & ActiveID
strSql = strSql & " AND modifiedDate >= '"& DateAdd("d", now(), -7) &"' ORDER BY modifiedDate "
RS1.Open strSql, DB1, adopenstatic
HTH
|
|
|
|