Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...your web site's great! I've been using this system for almost a year now and find it really, really helpful. The people have been helpful in answering just about any question you post in the forums..."

Geography

Where in the world do Tek-Tips members come from?
hrm03 (Programmer)
17 Nov 03 9:54
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!
doomdumas (Programmer)
18 Nov 03 14:38
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
hrm03 (Programmer)
24 Nov 03 14:17
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!!!

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!

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