Hi again,
I don't think my last post was explained properly.
My problem is I'm connecting to a DB2 database via ODBC from VB.
I think what the problem might be, is that the database doesn't have a logical name and so my connection string contains the path to the database. The path however contains an asterix and sql server doesn't seem to like it. I've heard if I give my database a logical name and restart it, my problem will be solved. The database is live though so it's not an option.
Does anyone know any other way to get around * in a connection string?
Thanks,
Gillian [sig][/sig]
I don't think my last post was explained properly.
My problem is I'm connecting to a DB2 database via ODBC from VB.
I think what the problem might be, is that the database doesn't have a logical name and so my connection string contains the path to the database. The path however contains an asterix and sql server doesn't seem to like it. I've heard if I give my database a logical name and restart it, my problem will be solved. The database is live though so it's not an option.
Does anyone know any other way to get around * in a connection string?
Thanks,
Gillian [sig][/sig]
