Database Open action to network server problems 1

[joeOctel]

I am trying to use the Database Open action in VMPro 4.2(19)to open an MDB file on a network server. The "Test Connection" button always returns "Test Connection succeeded.", but I always get a "Failure" result from the action and I get errors in the dbgview about

"Database open failed: 'Z:\Database7.mdb' is not a valid path." if I map the network drive or

"Database open failed: The Microsoft Jet database engine cannot open the file '\\intranet\msgs\Database7.mdb'. It is already opened exclusively by another user, or you need permission to view its data." if I put in the full path.

If I move Database7.mdb to the C: drive on the VMPro server everything works fine.

I have tried setting up Data sources in ODBC, but it still fails in the same way. I have tried "linking" tables in Access and the Database Open works, but then the Database Execute fails when I try to run an SQL query against the linked table.

Is there any trick to making it work?

thanks,

Joe

 

[mattKnight]

What user is the the VMPro service running as. LocalSystem at a guess, which has no network rights.

The drive mapping thing is probably because he use running VM pro doesn't have a mapping (despite what the logged on profile says)

The first thing I'd look at is permissions for the other one.



Take Care

Matt
I have always wished that my computer would be as easy to use as my telephone.
My wish has come true. I no longer know how to use my telephone.

 

[joeOctel]

I did add the Network Service user for the network folder I am using and gave it Full permissions. It still didn't work. I guess I will try running the VMPro service as a authenticated user instead of localsystem to see if that works.

I assume that you have this setup working in a similar fashion?

Thanks for your help.

Joe

 

[joeOctel]

Changing the service to use an authenticated user did work.

Thanks Matt,

Joe

 

[NoelOhashi]

@ mattKnight
I ve recently received one IVR trial license for our Avaya IPO IP500. The call flows correctly, opens, executes and gets the database, but it looks like it can only get the first or last information from the database and send it to out telphones. Our MS Access Database looks like this:


| Client Code | Name | Home Phone Number | Health Insurance Co
0 | | | |
1 | 1 | Maria Jose | 1140631700 | Dix Health
2 | 2 | Mario da S | 1140631759 | Dix Health
3 | 3 | Caio Henri | 1140631721 | Omint/Skill

I'm trying to relate our clients' phone number to the Health insurance company he belongs to and then, according to this result, relate that phone call to the right autoattendant. Just so our clients have less work when they call us.
Any help appreciated.

 

[mattKnight]

I am sorry, but you haven't really asked a clear question.

Are you saying that whenever a call hits your call flow, the whole recordset is returned.

I suggest that you post the SQL string you are using to extract the information.


Take Care

Matt
I have always wished that my computer would be as easy to use as my telephone.
My wish has come true. I no longer know how to use my telephone.

 

[NoelOhashi]

@mattKnight

Hi. I just figured out I had missed a clue that was right in front of me (Simple Strings instead of Double strings). You see, I hadnt realised that after editing one SQL you have already made, comes back as double strings. Thats why it wasnt working. But it is now and Im so thrilled. Right now Im foccusing on how to automate the schedule of medical appointments. The difficulty now resides on how to relate one result to the closest available date. For ex, the fields are Agenda Number | Date | Hour | Patient Scheduled. I hipe I can find a way to implement it.

 

[NoelOhashi]

What variable would I use on Execute action in order to limitate the DB research starting from the very date and hour the client is actually connected? For ex, the caller is connected at this very moment, 12:07AM May 25 th and he wants to find the nearest avaible date to schedule his appointment to one of our doctors. I know Id have to add something like this WHERE Date = '$CurrentSystemDate till the next available Dates'