I.T. Discussion Community!
Simon Dillworth, Simon Dillworth -Collapse +Expand
-Collapse +Expand
simd01
-Collapse +Expand Profile
Member Info
Member Narration

POSTS:
MB Posts (8)◄╣

Search simd01:

Advanced
   ► MB Lobby   Print This     

simd01 Message Board Activity

  


8 Message Board Posts:


Thread 8 of 8
Thread Starter or a Reply (but not last)  Group

simd01
Using MS SQL as back end
I need to set MS SQL up as the back end to a large multi-user paradox 10 app and am having trouble finding discussions of the issues involved. Can someone either point me to the relevant documents or briefly describe the various problems one is going to confront in achieving this? Many thanks.
Posted to MB Topic: QBE & SQL « Paradox Board
11 years ago

simd01
Robert, many thanks for that. I had been using the SQL link but that was the problem. Once I set up the ODBC DSN and then an alias as you suggested I was up and running. Thanks again - you've made my day. Simon
11 years ago
Nothing New Since Your Last Visit
3648
Hits

Corel Paradox / ObjectPAL Coding

Thread 7 of 8
Thread Starter or a Reply (but not last)  Group

simd01
odbc connection works!
Robert, many thanks for that. I had been using the SQL link but that was the problem. Once I set up the ODBC DSN and then an alias as you suggested I was up and running. Thanks again - you've made my day. Simon
Posted to MB Topic: QBE & SQL « Paradox Board
11 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 6 of 8
Thread Starter or a Reply (but not last)  Group

simd01
Cannot see fields in MS SQL tables in Paradox
I am attempting to convert a Paradox database into MS SQL back end using Paradox 10 as a front end. I can now connect to MS SQL 2008 Server Express and see tables in the Paradox data model but when I double click them I just get the SQL hourglass and that is it - none of the fields appear for selection (my dummy tables contain char(10) fields).  Has anyone else seen this?
Posted to MB Topic: MS SQL « DBA Board
11 years ago

Anonymous
I replied to your other post so I am curious. How are you connecting to the SQL server? Did you use the BDE native driver? Does that work? Did you use ODBC? --- Robert M.
11 years ago
Nothing New Since Your Last Visit
3972
Hits

DBA, Databases, & Data

Thread 5 of 8
Thread Starter or a Reply (but not last)  Group

simd01
Corel Web Server Limitations
Hi, I am a Paradox developer from way back (1985 in fact) and have never really touched on the Web Server OCX much. I am wondering if anyone is using this program to any great effect and what if any problems you see with it. Pardon my ignorance here but does the activex server cope with XML, CSS and XForms? I am particularly concerned about security of using the server -i.e. can it be locked down tightly enough for real-world apps?
Posted to MB Topic: Paradox Web Stuff « Paradox Board
12 years ago

Jonathanwri
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
5674
Hits

Corel Paradox / ObjectPAL Coding

Thread 4 of 8
Thread Starter or a Reply (but not last)  Group

simd01
SQL Server Access via BDE for Paradox
After establishing an alias of MS SQL type in the BDE I am able to connect to the database however when I try to select a table from it via the data model in form/report/query etc I cannot open it - a double click on the list of tables does not open any of them.  There is no error message, but I cannot see individual fields to select them as a result. Any ideas?
13 years ago

greens
yep, I guessed right.. you need p11, which comes with suite 11, 12, or x3.. in any case, you don't need to install everything, just install p11.. you can find cheap copies on ebay most of the time..
13 years ago
Nothing New Since Your Last Visit
4499
Hits

Corel Paradox / ObjectPAL Coding

Thread 3 of 8
Thread Starter or a Reply (but not last)  Group

simd01
RE: SQL Server Access via BDE for Paradox
Thanks Steve, I am using Px 10 and Vista. Same problem occurs with Px9 but not Px8, although with Px8 when I try to add any SQL table into the data model it lets me but then gives the error 'Invalid File Type'. Looks like I need to get a copy of Px11, but don't fancy buying the whole Corel Office suite, I don't suppose anyone knows of a means of getting Px11 seperately? Cheers, Simon
13 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 2 of 8
Thread Starter or a Reply (but not last)  Group

simd01
RE: Setting up an alias in BDE for SQL Server 2005
Thanks for that, Mike. I'm almost done, however now when I connect to the database it says 'Database is open. It cannot be modified' in the alias manager dialog box although I signed in with an OPEN MODE of 'READ/WRITE'.  I am signing in with the user name 'sa' and password so I believe this should give me full rights to the database. In form or report design if I try to add a field from an SQL table it will show me all tables in the SQL database but will not allow me to select any - when I try to the SQL hourglass comes up briefly but I can't open up the table to see its fields. Feeling tantalisingly close to getting this to work. Any suggestions?
13 years ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 1 of 8
Thread Starter or a Reply (but not last)  Group

simd01
Setting up an alias in BDE for SQL Server 2005
Does someone have an example showing how to set up an alias in the BDE that will give access to a SQL Server 2005 (Express Edition) database, e.g. the AdventureWorks sample that ships with it?  I have been having a go at this for days and remain stumped! BTW I am totally new to MS SQL and setting up BDE aliases other than Paradox ones - which would perhaps explain my predicament!
13 years ago

simd01
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
6859
Hits

Corel Paradox / ObjectPAL Coding

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech