Adobe Designer and Quickbooks ODBC DataConnection failed |
Author |
Message |
|
Posted : 2006-04-12 10:20:33 |
We are using Adobe LiveCycle Designer to create forms. We can connect to Quickbooks enterprise using the ODBC provided when designing the form in ALCD. When we save the form and open the form in adobe acrobat we get the error message "Connection for Source DataConnection failed because the environment is not trusted" A review of adobe's website says the following:
In Acrobat, security concerns dictate that you cannot specify an ODBC connection string by using the Driver=; syntax. Therefore, the client computer using the form needs to have a DSN pre-configured for ODBC connections.
What do we need to do to set this up.
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-12 11:32:23 |
Acrobat is saying you need to use a Simple DSN Connection like this:
sConnectString = "DSN=Quickbooks Data;OLE DB Services=-2;"
and not a DSNless connection string like this:
sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:\Program Files\QODBC Driver for QuickBooks\sample04.qbw;OpenMode=M;OLE DB Services=-2;" |
|
|
|
|
Posted : 2006-04-13 10:35:57 |
My connection string is as follows, and I still get the same error message.
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=QuickBooks Data;DFQ=C:\Documents and Settings\FilterItOutsBigCrazyBusinessIdeas.QBW;SERVER=QODBC;OptimizerDBFolder=C:\Program Files\Intuit\QuickBooks Enterprise Solutions 6.0\Components\QODBC\Optimizer"
How would I rewrite the string?
Thanks,
Filteritout |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-13 11:24:17 |
The connection string looks fine. Does the client have QODBC and QuickBooks? |
|
|
|
|
Posted : 2006-04-14 06:38:47 |
They are on the same machine, and I have been able to get it to work now.
But, in my programing I have "$sourceSet.DataConnection.open()" in order to open the QODBC I get the error open operation faile. [QODBC] Invalid operand for operator: =
What would be the correct operand for QODBC |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-15 18:45:26 |
Sorry, this isn't enough to go by, you would need to [ Review QODBC Messages ] in the QODBC Setup for the actual error, but here's how I would do it:
SQLrep = "Select * from Customer where IsActive = 1 order by FullName" Set objRSrep = Dataconnection.Execute(SQLrep)
Set Dataconnection = Server.Createobject ("ADODB.Connection") Dataconnection.ConnectionTimeout = 300
Dataconnection.open "DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DFQ=C:\Documents and Settings\FilterItOutsBigCrazyBusinessIdeas.QBW;OpenMode=M;OLE DB Services=-2;"
Dataconnection.CommandTimeout = 300
Set objRSrep = Server.CreateObject("ADODB.Recordset") objRSrep.Open SQLrep, Dataconnection, , AdLockOptimistic |
|
|
|