• Registered: December 30, 2008
  • Posts: 16

Topic: Trouble with Testing Server Connection

I am trying to learn how to make database driven web sites. I am starting off right in the beginning and have reached everything up to creating a Recordset(Query)

When I go to define the connection, I type in tjdesigndb for the Connection Name and type the following for the connection string

"Provider=Microsoft.Jet.OLEDB.4.0;data source=(ftp location to server which I have setup)"

When I run a test it comes back saying that the URL is wrong although I have tried atleast 10 different variations of the URL,  and the information under Testing Server corresponds to what I put in above. Still can't connect and was looking for some brainstorming.

I need to get passed this step in order to continue on with the tutorial I am trying to use.

-Travis

Vote up Vote down

  • Gender: Male
  • From: Chico/Sacramento, CA
  • Registered: December 19, 2008
  • Posts: 2,795
  • Reputation: 11

Re: Trouble with Testing Server Connection

Which tutorial are you using?

Are you sure that the connection name and the details are correct? Perhaps that is something that you should check with your host?

Benjamin Falk | Falken Creative : Twitter
Skills: Photoshop, Illustrator, HTML, CSS, jQuery, PHP and CodeIgniter

Vote up Vote down

  • Registered: December 30, 2008
  • Posts: 16

Re: Trouble with Testing Server Connection

I have Dreamweaver CS3 but am following the tutorial for Dreamweaver 8 because I have the book. But I dont think the version would have any effect in this area

My sites I deal with, including my own, are hosted at bravenet.com there FTP information is

ftp40.bravehost.com/web/(sitename)/

and thats it, so I include that into the connection string but it still fails.

Vote up Vote down

  • Gender: Male
  • From: Chico/Sacramento, CA
  • Registered: December 19, 2008
  • Posts: 2,795
  • Reputation: 11

Re: Trouble with Testing Server Connection

are you sure you have access to a database with your bravenet hosting? More specifically, to the same kind of database that you are calling in your connection string? If you have free hosting with them, you don't have any access to a database. If you have paid access, it looks like you have access to a MySQL database.

I don't know a huge amount about Microsoft Jet. It seems like it is a database engine that allows access to a database... I'm not sure if it requires Windows hosting or not (it appears that Bravenet does not offer Windows hosting) Someone else may know more than I do. However, it is does seem to be old technology -- one disadvantage of using an old book.

http://www.bravenet.com/global/hosting_matrix.php

As I said above, I don't think this is something we can help with. You will need to contact Bravenet and see what the settings are, and/or if the support Microsoft Jet.

Benjamin Falk | Falken Creative : Twitter
Skills: Photoshop, Illustrator, HTML, CSS, jQuery, PHP and CodeIgniter

Vote up Vote down

  • Registered: December 30, 2008
  • Posts: 16

Re: Trouble with Testing Server Connection

That may be the issue. Bravent supports MySQL (I have a paid 5 year membership) but the database I am calling is an Access Database that I made myself.

Although I did not include the database name in the connection string because I didnt think I needed to. I will try that when I get home, as well as look for an updated version of that tutorial.

Thanks.

Vote up Vote down

  • Registered: December 30, 2008
  • Posts: 16

Re: Trouble with Testing Server Connection

Well that didn't work. Still having the same issue connecting to the DB. I guess I can attempt to use MySQL instead, but it would be much easier to use Access to create my databases.

Vote up Vote down

  • Registered: December 30, 2008
  • Posts: 16

Re: Trouble with Testing Server Connection

Still got nothing.... Anyone else have any ideas?

Vote up Vote down

  • Gender: Male
  • From: Chico/Sacramento, CA
  • Registered: December 19, 2008
  • Posts: 2,795
  • Reputation: 11

Re: Trouble with Testing Server Connection

TJDesign wrote:

Still got nothing.... Anyone else have any ideas?

Have you talked to your host about this? That would be the first step.

Benjamin Falk | Falken Creative : Twitter
Skills: Photoshop, Illustrator, HTML, CSS, jQuery, PHP and CodeIgniter

Vote up Vote down