I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox to/from Other Data Sources Topic   Print This     

PDOX11 over MSSQL (ODBC) - Schema in Table Names

PDOX11 over MSSQL (ODBC) - Schema in Table Names in Paradox to/from Other Data Sources topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: PDOX11 over   PDOX11 over MSSQL   (ODBC) Schema   Table Names  
PS_291
-- --
Rank: Cadet 2nd Year

Might anyone here know a way to configure ODBC/SQLEXPRESS under the BDE to return table names without a schema prefix (i.e., tablename rather than dbo.tablename)? Should I be looking at a different SQL DB? 

Ideally, I’d like to point the alias that currently references the main paradox database to one referencing tables ported to sql and look at what needs fixing from there. 

Thanks to a tool created and shared on codeproject by one of the forum members (thanks Igor!), database conversion to SQLEXPRESS went surprisingly easily, with only a few minor field type changes needed across hundreds of tables. I’m connecting to the SQL db fine from paradox via odbc. That said, I’ll consider a different back end (Firebird? PostgreSQL?) if it means the Paradox app will require fewer changes; I’m dealing with many forms and lots of code and porting the back end is a step toward a full conversion away from Paradox.

Thanks!

John

 Posted 27 days ago (Thread Starter)
Comment Quote
About PS_291 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17393, 6 replies
Thread Started 1/22/2019 5:37:28 AM
View Counter=55
Location=-- -- 
Joined=18 months ago   MB Posts=11  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

sorry, no clue

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 27 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17394 (Level 2) and Parent is 17393
Reply Posted 1/22/2019 8:27:34 AM
Location=Myrtle Beach, SC USA 
Joined=29 months ago   MB Posts=243  
PS_291
-- --
Rank: Cadet 2nd Year

Thank you for the feedback, Steven. If you haven't found a way around this sort of thing with as many conversions as I suspect you have under your belt, I'm guessing there's a good fighting chance there's no way around the table naming issue with MS SQL. I'll try to get tests going with a few other back ends and will update.

Cheers,

John

 Posted 27 days ago (Thread Starter)
Comment Quote
About PS_291 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17395 (Level 1.1)  Reply to 17394 and Parent is 17393
Thread Started 1/22/2019 9:40:56 AM
Location=-- -- 
Joined=18 months ago   MB Posts=11  
rum
Frankfort, KY USA
Rank: Ensign

John,  is this the table name you see in a query,  or when you try to connect with ODBC?

 Posted 27 days ago
Comment Quote
About rum -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17396 (Level 3) and Parent is 17393
Reply Posted 1/22/2019 9:50:21 AM
Location=Frankfort, KY USA 
Joined=20 months ago   MB Posts=72  
PS_291
-- --
Rank: Cadet 2nd Year

Hi Jeff,

This is when connecting via ODBC. I believe that in queries MS SQL will look up the applicable schema (with a small performance penalty) if it's not prepended to the table name.

Best,

John

 Posted 27 days ago (Thread Starter)
Comment Quote
About PS_291 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17397 (Level 1.1)  Reply to 17396 and Parent is 17393
Thread Started 1/22/2019 9:54:19 AM
Location=-- -- 
Joined=18 months ago   MB Posts=11  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

no, John.. it just means I don't know anything about configuring SqlExpress.. I'm not the guy who converts the old paradox apps, I'm the guy who maintains the old paradox apps that haven't been converted :-)

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 27 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17398 (Level 4) and Parent is 17393
Reply Posted 1/22/2019 10:18:48 AM
Location=Myrtle Beach, SC USA 
Joined=29 months ago   MB Posts=243  
Most Recent Post
PS_291
-- --
Rank: Cadet 2nd Year

Ah- okay! Thank you for the clarification, Steven- that’s good to know. I’ll likely be maintaining Paradox deployments for years yet moving forward (particularly with the v11 migration close to complete)- it’s been great to find that there’s still a community around.

 I’ll be sure to post an update if I get the table name issue worked out.

Best,

John

 Posted 27 days ago (Thread Starter)
Comment Quote
About PS_291 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17399 (Level 1.1)  Reply to 17398 and Parent is 17393
Thread Started 1/22/2019 11:40:05 AM
Location=-- -- 
Joined=18 months ago   MB Posts=11  
Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1182A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17393 Counter
55
Since 1/22/2019
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,676 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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