If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Pervasive sql queries on Lytec 2005???

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-17-06, 22:31
dghundt dghundt is offline
Registered User
 
Join Date: Oct 2003
Posts: 18
Pervasive sql queries on Lytec 2005???

I would like to run sql queries on Lytec 2005 which uses a Pervasive V8.x database. When I go into the control center, I can access some demo databases fine, but my medical practice files are password protected. I assume these were locked by Lytec during initial install as I can't find the password/userid's.

An old knowledge base article on Lytec shows how to find the password/userid, but the depicted option is not available on my 2005 version.

Is it possible to use MySQL or Microsoft SQL to access this? (sorry if this question is stupid!)

I'd appreciate any thoughts/exerpience on this!

thanks,
david

Last edited by dghundt; 04-17-06 at 22:36.
Reply With Quote
  #2 (permalink)  
Old 04-17-06, 23:46
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
You won't be able to access the data using any engine other than the Pervasive engine.
You'll need to talk to Lytec to get the user/password in order to use ODBC.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 04-18-06, 16:25
dghundt dghundt is offline
Registered User
 
Join Date: Oct 2003
Posts: 18
I've changed mine, but the case sensitive defaults are:

Userid: Admin
psswd: Password


Thanks for your help!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On