[RESOLVED] Connection using oledb and ADODB coding: Error...

[George-LSA]

Hey

using the connection below i can connect to a database located on our SQL Server.

when i change this connection to connect to a database on a SQLBase server it generates a runtime error. which states "multi-step oledb operating generated error. check each oledb status value. No work was done"

the code for the sqlbase server is located below the sql server connection

'SQL SERVER CONNECTION
Private Sub Form_Load()
    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset    'Create References and
    Set ex = New Class1     'open database file
 
    cn.ConnectionString = "Provider=sqloledb;" & _
                            "data source=vms2;" & _
                            "Initial Catalog=ss638;" & _
                            "uid=***;" & _
                            "pwd=***"
    cn.Open
    ex.OpenRecordset rs, "PART", cn
 
    Set ex.ADORecordset = rs
    
    FileName
End Sub

'SQLBASE CONNECTION
Private Sub Form_Load()
    Set cn = New ADODB.Connection
    Set rs = New ADODB.Recordset    'Create References and
    Set ex = New Class1     'open database file
 
    cn.ConnectionString = "Provider=sqlbaseoledb;" & _
                            "data source=servergs;" & _
                            "Initial Catalog=vmfg638;" & _
                            "uid=***;" & _
                            "pwd=***"
    cn.Open
    ex.OpenRecordset rs, "PART", cn
 
    Set ex.ADORecordset = rs
    
    FileName
End Sub

can someone please tell me wat i am doing wrong...

cheers

[dee-u]

Here's an example of connectionstring for SQL Server....

'Standard security:
Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;
 
'Trusted Connection:
Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;

On what line does the error occurs? Is it in the Ex.Openrecordset line?

[George-LSA]

hey dee-u

my sqlserver connection works....but the second connection string i provided didnt...that was for sqlbase....

the error occured on

cn.Open

do u have any ideas???

[dee-u]

Try visiting this link.

I know nothing about SQLBase so I couldnt provide you a good advice.... Sorry.....