ProvideX ODBC Sql Problem

[myasin78]

Hello All,

I wrote a vb app that connects to provideX database through ODBC Conn. I pointed the odbc to the right database path.
eg: \\myserver\share\companyA\po.soa
I assume *.soa is the database files for ProvideX. I tested my application with Access/ODBC and worked fine. but after I installed at the server that has provideX database i been getting this error message.
Run time error '-2147467259(80004005)'

I assumed if vb app worked on ODBC/access should work on any ODBC/Database. I guess not!

I really appreciate any comments or suggestions.

thanks,

 

[fredericofonseca]

Have you asked the provider of ProvideX ? or have you searched their website?


You can try the following.
If ProvideX has a ODBC driver then add the connection through Control Panel.

Use the file DSN and the system DSN and follow the instructions for each situation.

Then have a look at the DSN file created and at the registry entry created and see which keywords were used to locate the Database.

It may not be this simple.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[myasin78]

Thanks for reply!

I did search MAS90(best software) website and i downloaded the ODBC driver to connect. I got a connection to the database, but even though i provided a username and passwd throught DSN str,i get prompt for MAS 90 database Signon

I found someone with the same problem but he is using .net

http://www.codeproject.com/csharp/InteropSignon.asp

that should explain more.

Is ProvideX database has extension of .pvx or .soa
if .pvx what is .soa because that is the file i am trying to select table from

thanks,

 

[fredericofonseca]

Speak with Best Software and ask them if this is possible to do with ODBC/OLEDB. It is possible it is a particular connection variable tha you have not set yet.

If not then you will need to do something similar to what is mentioned on the link you posted.

If using ADO you can also try the following on VB

dim DBConn As ADODB.connection
dim dbconnstring As String
Set DBConn = New ADODB.connection
DBConn.CursorLocation = adUseClient
dbconnstring = your connection string
DBConn.Open dbconnstring
Dim i As Long
For i = 0 To DBConn.Properties.Count - 1
Debug.Print DBConn.Properties(i).Name & "=" & DBConn.Properties(i).Value & "="
Next i

This will give a list of all properties of that connection.

It is possible that you have the one you need on the list.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[myasin78]

I will try it tomorrow.
thanks,