polaatx
asked on
Urgent: My connection string keeps changing
I used the following mapPath connection string for several weeks with no problem:
Provider=Microsoft.Jet.OLE DB.4.0;Dat a Source=" & Server.MapPath("../../data base/aura. mdb")
Then I started getting errors and I would change to:
Provider=Microsoft.Jet.OLE DB.4.0;Dat a Source=" & Server.MapPath("../../../d atabase/au ra.mdb")
and it work for a while. Again a couple days later or a few hours later, I would get error messages, saying database path could not be found. I would change back to the first string and it work again until the next error.
Then I read in that mapPath doesn't work well at my host, Brinkster. So I changed to the following physical path:
"Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & "Data Source=\\premfs14\sites\pr emium14\aa sg\databas e\aura.mdb ;"
But now I get the following error message:
Microsoft JET Database Engine error '80004005'
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre mium14\aas g\database \aura.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/aura/research.asp, line 8
Could someone please tell me what I am doing wrong? I am absolutely sure the path is correct. Even used <%= Server.MapPath("\")%> to check it.
Why is it putting 'C:\WINDOWS\system32\ in the error?
Provider=Microsoft.Jet.OLE
Then I started getting errors and I would change to:
Provider=Microsoft.Jet.OLE
and it work for a while. Again a couple days later or a few hours later, I would get error messages, saying database path could not be found. I would change back to the first string and it work again until the next error.
Then I read in that mapPath doesn't work well at my host, Brinkster. So I changed to the following physical path:
"Provider=Microsoft.Jet.OL
But now I get the following error message:
Microsoft JET Database Engine error '80004005'
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre
/aura/research.asp, line 8
Could someone please tell me what I am doing wrong? I am absolutely sure the path is correct. Even used <%= Server.MapPath("\")%> to check it.
Why is it putting 'C:\WINDOWS\system32\ in the error?
Please Maintain your open questions:
1 07/17/2004 500 Horizontal list displays unwanted margin Open Cascading Style Sheets
2 08/11/2004 500 Long long wait for Loading Database Sche... Open Macromedia Dreamweaver
3 08/14/2004 500 Trying to retrieve autonumber after inse... Open Macromedia Dreamweaver
4 08/17/2004 500 How to style a page displayed inside an ... Open HTML
5 06/19/2004 500 Configuration Error: trying to install m... Open Active Server Pages (ASP)
6 08/22/2004 500 Trying to combine ASP and javascript to ... Open JavaScript
7 08/24/2004 500 How do I send an attached file using CDO... Open Active Server Pages (ASP)
8 08/24/2004 500 Updating Access database from Radio Butt... Open Active Server Pages (ASP)
9 08/25/2004 500 Urgent: My connection string keeps chang... Open Active Server Pages (ASP)
1 07/17/2004 500 Horizontal list displays unwanted margin Open Cascading Style Sheets
2 08/11/2004 500 Long long wait for Loading Database Sche... Open Macromedia Dreamweaver
3 08/14/2004 500 Trying to retrieve autonumber after inse... Open Macromedia Dreamweaver
4 08/17/2004 500 How to style a page displayed inside an ... Open HTML
5 06/19/2004 500 Configuration Error: trying to install m... Open Active Server Pages (ASP)
6 08/22/2004 500 Trying to combine ASP and javascript to ... Open JavaScript
7 08/24/2004 500 How do I send an attached file using CDO... Open Active Server Pages (ASP)
8 08/24/2004 500 Updating Access database from Radio Butt... Open Active Server Pages (ASP)
9 08/25/2004 500 Urgent: My connection string keeps chang... Open Active Server Pages (ASP)
if youre hosted by Brinkster, why not just contact them and ask them what they suggest to use as your connection string?
Also, I must say I thoroughly agree with Big Daddy about maintaining your open threads. By leaving them open, you clutter the TA, and also, Experts probably feel ignored and will most likely be less apt to help you in the future
Also, I must say I thoroughly agree with Big Daddy about maintaining your open threads. By leaving them open, you clutter the TA, and also, Experts probably feel ignored and will most likely be less apt to help you in the future
ASKER
I did contact Brinkster and they say the c:\... scheme won't work with their server. It has to be \\premfs14\ ... So darksincliar, your suggestion won't work. Not on Brinkster.
About open the questions: many I am keeping open hoping to get a better answer. I wil close some today. Thanks for reminding me.
About open the questions: many I am keeping open hoping to get a better answer. I wil close some today. Thanks for reminding me.
ok, have you tried with an extra '\' infront of the connect string then? YOu want to escape the \ so you will need to use this I think :
"Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & "Data Source=\\\premfs14\sites\p remium14\a asg\databa se\aura.md b;"
or perhaps it is with \\\\... as you can see from this line :
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre mium14\aas g\database \aura.mdb' is not a valid path.
Data Source=\prem ... You are missing a '\' in there.
Try it with three slashes and 4 and let me know how it turns out
CHeers
"Provider=Microsoft.Jet.OL
or perhaps it is with \\\\... as you can see from this line :
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre
Data Source=\prem ... You are missing a '\' in there.
Try it with three slashes and 4 and let me know how it turns out
CHeers
ASKER
"Data Source=\\\premfs14\sites\p remium14\a asg\databa se\aura.md b;"
and
"Data 'Source=\\\\premfs14\sites \premium14 \aasg\data base\aura. mdb;"
don't work. Strangely, the error is identical:
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre mium14\aas g\database \aura.mdb' is not a valid path.
and
"Data 'Source=\\\\premfs14\sites
don't work. Strangely, the error is identical:
'C:\WINDOWS\system32\Data Source=\premfs14\sites\pre
Have you read this?
http://www.vpasp.com/virtprog/info/FAQ_brinksterdatabasesetup.htm
Quote :
www.brinkster.com Database setup
Brinkster has a unique method of database connection.
Brinkster has disallowed the use of the ASP directive:
Server.Mappath to map to directories above your "Webroot" directory.
To connect to your vpasp database, navigate to www.yoursite.com/exFindYourPath.asp
The exFindYourPath.asp file is a file provided to you by brinkster.com
--> have you tried that exFindYourPath.asp file? What does it say?
http://www.vpasp.com/virtprog/info/FAQ_brinksterdatabasesetup.htm
Quote :
www.brinkster.com Database setup
Brinkster has a unique method of database connection.
Brinkster has disallowed the use of the ASP directive:
Server.Mappath to map to directories above your "Webroot" directory.
To connect to your vpasp database, navigate to www.yoursite.com/exFindYourPath.asp
The exFindYourPath.asp file is a file provided to you by brinkster.com
--> have you tried that exFindYourPath.asp file? What does it say?
Dim conn, strConn, myPath
myPath = server.MapPath(".\")
set conn = Server.CreateObject("adodb .connectio n")
strConn="Provider=Microsof t.Jet.OLED B.4.0;Data Source=" & myPath & "\database\aura.mdb"
conn.Open strConn
Does the above code work? I've never even heard of brinkster but it sounds like they havea hell of alot of problems. Their forums are jammed packed with people who arent' able to get connection,
You might want to try and post a question on their forum : http://www.brinkster.com/forums/
Cheers,
myPath = server.MapPath(".\")
set conn = Server.CreateObject("adodb
strConn="Provider=Microsof
conn.Open strConn
Does the above code work? I've never even heard of brinkster but it sounds like they havea hell of alot of problems. Their forums are jammed packed with people who arent' able to get connection,
You might want to try and post a question on their forum : http://www.brinkster.com/forums/
Cheers,
ASKER
darksinclair:
Figured it finally. I just have two mentions of "Data Source" in my string. I need new glasses:
Provider=Microsoft.Jet.OLE DB.4.0;Dat a Source=" & "Data Source=\\\premfs14\sites\p remium14\a asg\databa se\aura.md b;"
thanks for the help.
Figured it finally. I just have two mentions of "Data Source" in my string. I need new glasses:
Provider=Microsoft.Jet.OLE
thanks for the help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you kindly polaatx. Let me know if you need any more assistance.
Cheers!
Cheers!
Secondly, I don' tthink that it will accept \\premfs14\ as a source... I dont think it will do resolution ..You'll need to change that. Does this file reside on the server or a different server?
Try the following :
"Provider=Microsoft.Jet.OL
or change C:\ to whatever drive you have your files on.
Cheers,