×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

Remote ODBC connection to MAS 90 using .NET

Remote ODBC connection to MAS 90 using .NET

Remote ODBC connection to MAS 90 using .NET

(OP)
Hi,

I want to connect to MAS90 data source, which is not local but on a different computer.
The driver on the remote machine is ProvideX ODBC Driver version 4.21.1000.
We are using visual studio 2008 and c#.
I tried many different connection strings, for example:

conn.ConnectionString = @"Driver={MAS90 32-Bit ODBC Driver};DSN=SOTAMAS90;User=xxx;Password=xxxx;Company=xxx;Server=xxx.xxx.x.xxx";

conn.ConnectionString = "DSN=SOTAMAS90_KEN2;UID=xxx;PWD=xxxx;Company=xxx;Server=xxx.xxx.x.xxx";

I tried various versions, but I always get "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Has anyone connected MAS90 data source remotely using .NET?
I really appreciate your information even if your language is not c#, using different version of Visual Studio, or different version of driver.

Thanks in advance.
 

RE: Remote ODBC connection to MAS 90 using .NET

The second one is close, but should be SOTAMAS90 unless you set up your own.  Then the Server should be a drive letter or UNC path not an IP address.  Plus you're missing all the other stuff after it.  If you go into the data source, on the debug tab it will give you the connection string you can use to copy and paste.

Dawn

Visit Sage's Online Community
http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

RE: Remote ODBC connection to MAS 90 using .NET

(OP)
Dfeller,
Thank you for your reply.
I checked the connection string, and I tried with "Directory", "Prefix", "ViewDLL" etc. too.
I created the DSN with the name "SOTAMAS90_KEN2", so, that part is correct.

conn.ConnectionString = @"DSN=SOTAMAS90_KEN2;UID=xxx;PWD=xxxx;Directory=\\xxx\Sage V4\MAS90;Prefix=\\xxx\Sage V4\MAS90\SY\, \\xxx\Sage V4\MAS90\==\;ViewDLL=\\xxx\Sage V4\MAS90\HOME;Company=xxx;RemotePVKIOHost=xxx.xxx.x.xxx;SERVER=NotTheServer";

>"Then the Server should be a drive letter or UNC path not an IP address."
We are logging on to the remote machine using VPN client and remote desktop when we manually log on to data source.
So, I set the RemotePVKIOHost to the IP address of the machine, and set SERVER=NotTheServer, and tried without "SERVER=..." too, but they didn't work.
I guess I cannot use the UNC path because the machine is not on our network. (Actually, I tried with SERVER=\\xxx.xxx.x.xxx, but it did not work.)

I installed ODBC driver with MDAC (Local/Client Component) on my machine, not File Server driver. This is the correct one, right?

Thank you

RE: Remote ODBC connection to MAS 90 using .NET

(OP)
I'd like to add that I installed an evaluation version of ProvideX ODBC Driver version 4.21.1000 with MDAC (Local/Client Component).

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! Already a Member? Login

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