AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: ODBC AcuCOBOL :: (4)

Aug 11 2006, 7:00 AM

ODBC AcuCOBOL

rogambini

since: Aug 11, 2006
from: New York I have been successful in evaluating the asp report wizard with MYSQL.

I am now trying to connect to my production database which is an acucobol vision file via their odbc driver.

I have a dsn setup and working with both msaccess and php but when i try to access a table (im using usetables) i get the error message

ODBC driver does not support the requested properties.

I am using the latest version of their odbc driver.

Does anyone have any suggestions?
Has anyone been successful in connecting to a vision file?

Aug 11 2006, 4:06 PM

Re: ODBC AcuCOBOL

Post a Reply

ghost

from: Washington, DC Try setting your database type property before you initialize as follows:

objWiz.DatabaseType = "ACCESS"

Let me know if it helps.

-------------------------
Ghost

Aug 17 2006, 2:00 PM

Re: ODBC AcuCOBOL

Post a Reply

rogambini

since: Aug 11, 2006
from: New York Tried "ACCESS" that did not make a difference.

I originally had objWiz.DatabaseType = "ODBC"

any other suggestions

Aug 22 2006, 7:07 AM

Re: ODBC AcuCOBOL

Post a Reply

ghost

from: Washington, DC I'm not sure what version of ODBC drivers you have installed. Please try using the Access database path:

Dim strConn strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "DATA SOURCE=C:\Databases\NorthWind.mdb;" objWiz.Init(strConn)

for more information, please check our connection string samples
http://www.aspwebsolution.com/products/report_wizard/t_conn.htm

-------------------------
Ghost

Pages: (1) [1]