Click here to Skip to main content
14,838,718 members
Home / Discussions / Database
   

Database

 
AnswerRe: Managing Database Changes Pin
Mycroft Holmes8-Nov-17 14:10
professionalMycroft Holmes8-Nov-17 14:10 
AnswerRe: Managing Database Changes Pin
kmoorevs11-Nov-17 9:58
Memberkmoorevs11-Nov-17 9:58 
GeneralRe: Managing Database Changes Pin
Richard Deeming13-Nov-17 1:49
mveRichard Deeming13-Nov-17 1:49 
GeneralRe: Managing Database Changes Pin
kmoorevs13-Nov-17 8:29
Memberkmoorevs13-Nov-17 8:29 
QuestionGet specific records from DB Pin
_Flaviu28-Oct-17 23:08
Member_Flaviu28-Oct-17 23:08 
AnswerRe: Get specific records from DB Pin
A_Griffin28-Oct-17 23:48
MemberA_Griffin28-Oct-17 23:48 
AnswerRe: Get specific records from DB Pin
Mycroft Holmes28-Oct-17 23:54
professionalMycroft Holmes28-Oct-17 23:54 
QuestionA question about the behavior of Jet and Ace drivers Pin
indian14324-Oct-17 7:58
Memberindian14324-Oct-17 7:58 
Hi,

It shows both the Jet and Ace drivers on a Server machine, and user the Sql Agent Job is running with, doesn't have admin privileges. The Packages that are running with Jet drivers are working fine on that Server where as the Packages that are using Ace drivers are not running Properly. There are various questions and eye brows that are raising here
  1. There are Ace 14.0 drivers there on that machine, were the Ace 12.0 drivers overwritten by Ace 14.0 when we installed newer version of Ace or office pack
  2. Don't the Ace 14.0 drivers which are advanced than the Ace 12.0 have backward compatibility, why is it? When we try Ace 12.0 drivers with the Packages that are using csv or flat files are working fine where as only the Excel files both (xls and xlsx) are not working properly why?

    a. Are the Ace 14.0 drivers backward compatible with the csv and flat files or do the Ace 12.0 drivers can import from the csv and flat files without Admin
    privileges Many questions are raising with this odd behavior. Because the csv and flat files are getting imported without admin privileges too

    b. Are the Ace 12.0 drivers not available only 14.0 are running all this but because of the registry entry or some uncleaned stuff from the installation is
    showing the Ace 12.0 drivers in the drivers list? Many many questions are raising.
  3. As the Packages with the Jet drivers are working fine I am not understanding what is missing or messing up here, is it the unavailability of Ace drivers or do the Ace drivers need Admin privileges and Jet drivers don't? If unavailability is the case then why Ace 12.0 drivers are fine with csv and flat files?
The problem for us in continuing with the Jet drivers is, we have some packages with xls which is fine with Jet drivers but we have some Packages with the xlsx files which are not going to work with the Jet drivers.

Is there any buddy who can answer me these questions? Any help would be greatly appreciated my friends. I am also researching doing lot of studies about behavior of these drivers.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
PIEBALDconsult24-Oct-17 8:32
professionalPIEBALDconsult24-Oct-17 8:32 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
indian14325-Oct-17 7:15
Memberindian14325-Oct-17 7:15 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
jschell27-Oct-17 7:43
Memberjschell27-Oct-17 7:43 
QuestionMath expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 7:19
Memberindian14319-Oct-17 7:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Richard MacCutchan19-Oct-17 7:33
mveRichard MacCutchan19-Oct-17 7:33 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 8:10
Memberindian14319-Oct-17 8:10 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell20-Oct-17 9:27
Memberjschell20-Oct-17 9:27 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Eddy Vluggen20-Oct-17 10:47
professionalEddy Vluggen20-Oct-17 10:47 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14324-Oct-17 6:41
Memberindian14324-Oct-17 6:41 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell25-Oct-17 9:19
Memberjschell25-Oct-17 9:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14330-Oct-17 7:37
Memberindian14330-Oct-17 7:37 
QuestionGUID or long for MVC site Pin
#realJSOP17-Oct-17 6:37
mva#realJSOP17-Oct-17 6:37 
AnswerRe: GUID or long for MVC site Pin
Wendelius17-Oct-17 7:01
mveWendelius17-Oct-17 7:01 
AnswerRe: GUID or long for MVC site Pin
jschell17-Oct-17 7:43
Memberjschell17-Oct-17 7:43 
GeneralRe: GUID or long for MVC site Pin
k505418-Oct-17 5:30
mvek505418-Oct-17 5:30 
GeneralRe: GUID or long for MVC site Pin
jschell20-Oct-17 8:34
Memberjschell20-Oct-17 8:34 
AnswerRe: GUID or long for MVC site Pin
Eddy Vluggen17-Oct-17 23:38
professionalEddy Vluggen17-Oct-17 23:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.