Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

add new REAL SQL database not working (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: Re: Getting maximum input speed from BinaryStream :-<
Next thread: does SaveInfo care about drive letters?


Win32 API Declares   -   Berg, Heath
  add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Will Leshner
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Will Leshner
   Re: add new REAL SQL database not working   -   Will Leshner
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Will Leshner
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Walter Purvis
   Re: add new REAL SQL database not working   -   Walter Purvis

add new REAL SQL database not working
Date: 18.08.05 18:46 (Thu, 18 Aug 2005 13:46:41 -0400)
From: Walter Purvis
Using RB2005r2, I go Project->Add->Database->New REAL SQL Database,
and name and save the file when prompted.

But when I double-click on the database icon in the project browser, I
get a "Could not connect to database" error message, and that's it.

Any ideas?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 18:59 (Thu, 18 Aug 2005 10:59:50 -0700)
From: Will Leshner

On Aug 18, 2005, at 10:46 AM, Walter Purvis wrote:

> But when I double-click on the database icon in the project browser, I
> get a "Could not connect to database" error message, and that's it.
>
> Any ideas?

Are you sure you are using the final version of 2005 r2? There was a
bug in a beta that had caused this, but it should be fixed in the
final version. Also, what platform are you running on?

Re: add new REAL SQL database not working
Date: 18.08.05 19:06 (Thu, 18 Aug 2005 14:06:11 -0400)
From: Walter Purvis
On 8/18/05, Will Leshner <<email address removed>> wrote:
> Are you sure you are using the final version of 2005 r2? There was a
> bug in a beta that had caused this, but it should be fixed in the
> final version. Also, what platform are you running on?

I'm using the version of 2005r2 that I downloaded from RS yesterday,
and I'm running Windows XP.

Thanks.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 19:08 (Thu, 18 Aug 2005 14:08:55 -0400)
From: Walter Purvis
On 8/18/05, Will Leshner <<email address removed>> wrote:
> Are you sure you are using the final version of 2005 r2? There was a
> bug in a beta that had caused this, but it should be fixed in the
> final version. Also, what platform are you running on?

Also, FWIW, I just tried with r3b1 and got the same thing.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 19:13 (Thu, 18 Aug 2005 11:13:20 -0700)
From: Will Leshner

On Aug 18, 2005, at 11:06 AM, Walter Purvis wrote:

> I'm using the version of 2005r2 that I downloaded from RS yesterday,
> and I'm running Windows XP.
>

I guess I'd need more information, then. Where are you trying to
create the database, for example?

Re: add new REAL SQL database not working
Date: 18.08.05 19:20 (Thu, 18 Aug 2005 11:20:04 -0700)
From: Will Leshner

On Aug 18, 2005, at 11:06 AM, Walter Purvis wrote:

> I'm using the version of 2005r2 that I downloaded from RS yesterday,
> and I'm running Windows XP.

Ok. I just tested it on Windows XP running 2005r2 and it worked fine
for me. So I'm not sure what is going on.

Re: add new REAL SQL database not working
Date: 18.08.05 19:22 (Thu, 18 Aug 2005 14:22:36 -0400)
From: Walter Purvis
On 8/18/05, Will Leshner <<email address removed>> wrote:
> I guess I'd need more information, then. Where are you trying to
> create the database, for example?

At first, I tried creating it in whatever directory the save-as
dialogue happened to be pointing at. Then, for no particular reason, I
tried creating the database at the root of the C: drive, thinking that
might make a difference. It didn't.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 19:51 (Thu, 18 Aug 2005 14:51:06 -0400)
From: Walter Purvis
On 8/18/05, Walter Purvis <<email address removed>> wrote:
> On 8/18/05, Will Leshner <<email address removed>> wrote:
> > I guess I'd need more information, then. Where are you trying to
> > create the database, for example?
>
> At first, I tried creating it in whatever directory the save-as
> dialogue happened to be pointing at. Then, for no particular reason, I
> tried creating the database at the root of the C: drive, thinking that
> might make a difference. It didn't.

Scratch that part about the "C: drive" -- I actually had tried to
create the database at the root of the K: drive (which is just another
partition on my main hard drive), and that appears to make a
difference.

After trying a variety of voodoo, this is what I have figured out so far:

Creating a database at C: drive works fine.
Creating a database on the desktop works fine.
Creating a database in My Documents works fine.
Creating a database ANYWHERE on the C: drive will probably work fine,
I'm guessing.

Creating a database at K: drive doesn't work.
Creating a database in a new folder on K: drive doesn't work.
Creating a database ANYWHERE on K: drive will probably not work, I'm
guessing, although there is apparently a way to make it work.

You have to first SAVE your project to make it work. I was trying to
create this database in a brand new project that I hadn't yet saved
for the first time. In this circumstance, the database file doesn't
even get created on disk, which is probably why RB "could not connect
to the database." Once I save the project, I was able to create a
database and connect to it for editing with no problem.

This requirement that you first save your project is either a bug or a
gotcha that should be noted in the documentation.

Also, I discovered that if you save your project on one disk, you
cannot connect to a database that you created (i.e., that you
*thought* you had created -- it appears the database doesn't actually
get created) on a different disk. E.g., I can't save a project on K:
and then create a database on C: (though I can create a database
anywhere on K:. apparently -- IOW, I'm not limited to just the folder
I saved the project in, as long as I stay somewhere on K:).

That too is either a bug or a gotcha that should be documented.

At any rate, with these bugs/gotchas in mind, I'm able to create and
work with REAL SQL databases now.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 19:59 (Thu, 18 Aug 2005 11:59:26 -0700)
From: Will Leshner

On Aug 18, 2005, at 11:51 AM, Walter Purvis wrote:

> This requirement that you first save your project is either a bug or a
> gotcha that should be noted in the documentation.

Yes, actually this is true of any external item. You have to save the
project first, before adding databases or other external items. The
reason being, the path to the external item is computed from the
project file itself.

But this is good data and it appears there are some problems with
creating/connecting to databases on different volumes than the
project. Thanks.

Re: add new REAL SQL database not working
Date: 18.08.05 20:02 (Thu, 18 Aug 2005 15:02:30 -0400)
From: Walter Purvis
In thinking about it more, the fact that you can create a database on
C: without first saving your project, but can't do this on K:, seems
like it's definitely a bug -- there shouldn't be that kind of
inconsistent behavior.

Also, FWIW, my r2 of 2005 is on my C: drive. My r3b1 is on my K:
drive, and with r3b1, I can't create a database (before saving the
project) on either C: or K: -- so perhaps that has something to do
with the more configuration that happens during the complete
installation process that the r2 installer goes through, as opposed to
the simple unzipping that you do with a beta version.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 20:07 (Thu, 18 Aug 2005 15:07:14 -0400)
From: Walter Purvis
On 8/18/05, Will Leshner <<email address removed>> wrote:
> Yes, actually this is true of any external item. You have to save the
> project first, before adding databases or other external items. The
> reason being, the path to the external item is computed from the
> project file itself.

Okay, good to know -- but note what I said in the later post, that you
CAN create a database on the C: drive without first saving the
project, but not on K:, if you're using a full install of r2... it
must have something to do with the configuration of the full install,
or something to do with the difference between the C: drive and other
drives... I really have no clue...
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 20:21 (Thu, 18 Aug 2005 15:21:01 -0400)
From: Walter Purvis
On 8/18/05, Walter Purvis <<email address removed>> wrote:
> At any rate, with these bugs/gotchas in mind, I'm able to create and
> work with REAL SQL databases now.

Okay, scratch that part about "work with" REAL SQL databases. I can
create them, but when I double-click to edit them, the window that
comes up doesn't have a toolbar -- there are no buttons for "Add
Table" and so on. All I see is the three lists that show my empty
schema.

What gives?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Re: add new REAL SQL database not working
Date: 18.08.05 20:28 (Thu, 18 Aug 2005 15:28:04 -0400)
From: Walter Purvis
On 8/18/05, Walter Purvis <<email address removed>> wrote:
> Okay, scratch that part about "work with" REAL SQL databases. I can
> create them, but when I double-click to edit them, the window that
> comes up doesn't have a toolbar -- there are no buttons for "Add
> Table" and so on. All I see is the three lists that show my empty
> schema.

I figured this out. Back in the main project window you have to make
sure that View->Editor Toolbar is set to show the toolbar. I'm not
sure why this was turned off -- I don't believe I did that, so if
that's the way the RB IDE is set as a default when you install it,
that's bad and should be changed.

More importantly, the database schema editor should pay no attention
to the Show/Hide setting of the Editor Toolbar in the IDE -- the
scheme editor is USELESS without a toolbar, so it should never be
hidden under any circumstances. It's a minor frustration, but minor
frustrations count...
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>