Replies Back to Article
Ultradev DB Connections using a Brinkster Free Acount
Omar,
After setting up the connection according to your guidelines, I am now trying the simple tutorial to see it work. When I attempt to define the filtered recordset for the results page, the data bindings panel cannot see the tables. I get the error message:
"Unable to retrieve tables from this connection. Click on the define button to test this connection."
Possible causes below?
According to your graphic above, I should have the settings: "UltraDev should connect: Using Driver on this machine" - not the remote option. Is this correct?
When I define this site, what should the remote server and application settings be for free users (with no ftp and the Brinkster file manager)?
Connection: None, Local/Network, ftp, WebDAV?
Your quick response or others on this thread are greatly appreciated. Thanks.
Jim
hi jim,
the catch is that you cannot connect to the brinkster account from your pc i.e. remotely.
You should create a site that parallels your site at brinkster on your own pc. But your connections file would have to be local if your site is local too. You would have to make changes locally and then upload files to brinkster from their own uploading application from their login.
But when you want to make a connections page for your files at Brinkster, the connections file created for your local site will not work at Brinkster of course since the path to the db would be different locally on your pc compared to where it would be at brinkster. So this tutorial shows you only how to make that connections file for a Brinkster account. You would then have to upload the connections folder into your brinkster account and go on from there.
This file could be created in Ultradev as in the tutorial, but it would not be used for your local site or a site on a remote server. It can only be uploaded and used at your Brinkster account.
Does that make sense?
Thank you Omar,
Your explanation makes perfect sense. The problem I'm trying to solve is this:
How can an UltraDev user build a site on a PC laptop to take advantage of remote database connectivity during design time using Brinkster? With my open DSL connection, I'd like to build, test and demo continually with my collaborators worldwide. The ideal solution is to use an ISP and have my team review the work on the Web for each iteration.
Because my bloody laptop is using Windows ME, the personal Web server settings are less than stable, so I can't set up the full system locally. Is that the only solution?
If I had ftp access and could define the remote site and app server with the same settings, would that do it? Does it require a DSN connection?
Thank you again. If you feel this topic should be covered on another thread, please let me know.
Jim
All I can suggest is to upgrade you account with brinkster and get full ftp access although there are pitfalls to doing this when using UD unless you set it up ok which as I found is a very difficult subject to find info on however I think I can help.
Once you have upgraded your account and got all your ftp info etc setup UD using all this info FTP etc.
Upload your database to the database folder in your account
Setup a Custom Connection String in UD as follows: -
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\premfs2\sites\premium9\mysite\database\mydb.mdb
Insert your full database path instead of the one above (sorry 4 stating the obvious)
Upload your connections folder and Check and test your connection
If everything is OK make a quick ASP page just showing a basic table with your database stuff in.
This I think is the important bit
In UD go to code view and at the top of the page is the include line reading
<!--#include file="../Connections/connYOURCONNECTION.asp" -->
CHANGE THIS TO
<!--#include virtual="/Connections/connYOURCONNECTION.asp" -->
If you dont you get loads of errors about starting with a .. or / or \
Upload your page and test
I know this might not be the best explanation but let me know if it does not work and I will try to help further.
Stephen
Hi Jim,
My Premium membership works fine with UD-4 and FTP connections.
I have a notebook and a desktop computer and, via FTP, I can update my site from anyone. I use the following DB string connection in my ASP programs:
Dim sMapPath
sMapPath = Server.MapPath("\")
sMapPath = Mid(sMapPath, 1, InStrRev(sMapPath,"\")-1) & "\database\"
Session("PathDB") = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sMapPath
Session("PathEnd") = ";Persist Security info="False;""
I have no dificulties to connect to Brinkster, either via UD-4 or FTP, but the above code works only for premium memberships.
Let me know if you have other questions.
Bye,
Maletta.
Hi, i just did everything as your guide, but it didn't worked, i even tried to change manualy the Connection String at the Connection Folder in my site, but neither worked out. I just got this message :
ADODB.Connection error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Can you or anybody explain to me why is this?
My connection string ¡s this :
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_castacom_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= " & Server.MapPath("\castacom\db\datafull.mdb")
%>
In my Pc with my DNSLess Connection it works fine but here it doesn't. Help m,e please.
The only thing I notice is that you left an extra space after the = sign after the DBQ, i.e.
MM_castacom_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= " & Server.MapPath("\castacom\db\datafull.mdb")
should be:
MM_castacom_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\castacom\db\datafull.mdb")
