INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Connecting to SQLBase

Connecting to SQLBase

(OP)
Hello. I am trying to connect to the Gupta SQLBase in VB using the following connection string:

cnConnection.Provider = "SQLBASEOLEDB"
cnConnection.ConnectionString = "User ID=*******;Password=******;Data Source=*servername*;Initial Catalog=" & sDatabase
cnConnection.ConnectionTimeout = 90
cnConnection.CommandTimeout = 90
cnConnection.Open

I keep getting the error message:

"Can't load any communication DLLs. Network may not be installed"

Any information on this would be appreciated. I can not seem to get around this error message. Thanks!

RE: Connecting to SQLBase

HI,
I'm not sure but I semms like you should look at your SQL.INI file that SQLBase uses.
Maybe something to do here.
I'm trying to do the same as you, I got another error :
Here's my cnnString :
"Provider=SQLBaseOLEDB;Data source=ISLAND;" & _
"Location=server1;User Id=SYSADM;Password=SYSADM"
I got the Error :
Cannot open SQL.INI configuration file for read or write
Hope we can help us togheter

RE: Connecting to SQLBase

(OP)
I was able to work my way through the first error by installing the software that actually uses the SQLBase, but now I have come across another hurdle.  It seems like the connection goes through but when I go to read the first line in the RecordSource, I get the error: "Operation is not allowed when object is closed" I have looked at the SQL.ini file, but see nothing there that really makes much sense. We have been able to make a  connection to multiple types of databases before using a variety of methods, but I am still not able to get into SQLBase. I am wondering if there is anything that I need to do on the server-side of things to make this connection go through. ANY ideas would be appreciated since I am at my end with this!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close