Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old July 30th, 2005, 04:22 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

they call me right now and told me to send them my backup from my database.can it be cause this problem???

Reply With Quote
  #22 (permalink)  
Old July 30th, 2005, 04:34 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Not sure what you mean? Why would sending them a back up cause a problem??

If they restore the back up on the server, they have to add the IUSR account again to your database. However, I assume it's something your host should know and understand.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #23 (permalink)  
Old July 30th, 2005, 07:24 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

thank you.the host told me they will upload my data base again.i think it will be solved tomorrow.i don't know what will they do with backup.

Reply With Quote
  #24 (permalink)  
Old July 30th, 2005, 11:19 PM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

i revice same error again:(i checked the users in the interprise manager it has just one user that is host064 and its my database name.shouldn't i make another user for internet users?and if i should do this what is its name?i don't know what to do:(

Reply With Quote
  #25 (permalink)  
Old July 31st, 2005, 02:33 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

my host told me that the problem is for my connection coddings.i searched and i found many connection strings in diffrenet types but it still gives me error
i wrote it like this:
<%
Set QCcon = Server.CreateObject("ADODB.Connection")
QCcon.open "DSN=sql.bekr.net;UID=myuser;PWD=mypass;DATABASE=h ost064"
%>
but it gives me this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/Connections/QCcon.asp, line 4
and line 4 is my QCcon open line


Reply With Quote
  #26 (permalink)  
Old July 31st, 2005, 04:35 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Did your host create a DSN for you? If so, what name did they give it?

It seems that you're using your server's full name in the DSN which doesn't work. In a DSN:

DSN=SomeThing

SomeThing is not the name of the server or database; it's the name of a DSN that must be present on the server.
If you don't have a DSN, you should try to use a DSN-les connection, as shown on the site I pointed you to earlier.

But this is really something you should work out with your host, as I can only guess what the right settings are. I take it that if they offer SQL Server and can upload databases for you, they sure know how to connect to it, or at least have some documentation /FAQs on their site explaining this? Did you check out their site?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #27 (permalink)  
Old July 31st, 2005, 05:09 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

If I were you, I wouldn't be posting security related information like server names, user names and password on a public forum like this. I think you should review your messages in this thread and remove sensitive information before Google picks it up....

Anyway, I told you before: I'd like to help, but I can't. This is something you and your host must work out. They know their system, they know their databases and username etc so they can correctly set it up for you and tell you how to connect to it.....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #28 (permalink)  
Old July 31st, 2005, 05:44 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

I can't believe i made such a big mistake:O i copied the code and i forgot to replace my user pass and database name.:O i think everything that could be happend has happend untill now it would be better to change my user,...

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP Upload vin_0x1 Classic ASP Databases 1 June 24th, 2006 05:35 PM
Upload a Text file from a Web Client to SQL Server petercyriljones Classic ASP Professional 0 May 20th, 2005 10:26 AM
Is it required to upload vti_cnf files...into web? ashokparchuri General .NET 1 May 20th, 2005 09:02 AM
how to upload a mysql db on web server umair_rathore MySQL 2 May 14th, 2005 05:46 AM
how to upload asp pages to web 222 Classic ASP Basics 1 June 10th, 2003 02:31 PM



All times are GMT -4. The time now is 05:29 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.