ODBC connections between computers in a LAN networking (1 Viewer)

Allan.Day

Registered User.
Local time
Today, 21:44
Joined
May 18, 2013
Messages
25
Dear All,

Please Advice :

At XYZ Company there are three computers admin installed windows 7 and windows xp, so no windows server
1. Comp X with IP 192.168.1.12 installed sql server and installed Microsoft Access
2. Computer Y with IP 192.168.1.13 not installed sql server and not installed Microsoft Access, but mounted Access Driver
3. Computer Z with IP 192.168.1.14 not installed sql server and not installed Microsoft Access, but mounted Access Driver

Which is desired; The computer Y and Z can access SQL Server in computer X by using ODBC
The problem is: ODBC settings in the computer Y and Z are not successful, although it has been tried
1. Firewall on computer X is turned off (extreme)
2. Sharing files have been successfully
3. Ping IP Computer X of Y and Z successful computer

When using OLEDB if there are colleagues who have a tutorial?
I tried searching the internet there is a VBA script, but still confused, whether it be affixed on each form, or in modules, and called each time the form is opened or how

Thank you in advance

Allan.Day
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 01:44
Joined
Jan 20, 2009
Messages
12,849
Have you get user logins and their permissions set up on SQL Server? What kind of logins are you using?
 

Allan.Day

Registered User.
Local time
Today, 21:44
Joined
May 18, 2013
Messages
25
Have you get user logins and their permissions set up on SQL Server? What kind of logins are you using?

Hy Galaxiom,

Authentication with sql server login, that work fine on local computer, the problem are how to connect to sql server on another comp that not windows server, just connected with lan


thanks
 

Rx_

Nothing In Moderation
Local time
Today, 08:44
Joined
Oct 22, 2009
Messages
2,803
Would this mean SQL Express running on a PC?
Please tell us more.
Something has to be running the SQL Engine. Connecting to just a file would not be possible. Unless it is a text file, Excel, Access MDB, or XML kind of thing.

SQL Server has a security layer to protect the data files.
 

Allan.Day

Registered User.
Local time
Today, 21:44
Joined
May 18, 2013
Messages
25
Would this mean SQL Express running on a PC?
Please tell us more.
Something has to be running the SQL Engine. Connecting to just a file would not be possible. Unless it is a text file, Excel, Access MDB, or XML kind of thing.

SQL Server has a security layer to protect the data files.

Thanks for Reply Mr Rx

Yes, Sql Express running on a PC
It is possible to connect to sql express running on a windows 7 pc from another computer with xp installed?

what should i do to make a 3 computer connected by lan and can share sql server data with access accdb front end

thanks in advance
JD
 

Rx_

Nothing In Moderation
Local time
Today, 08:44
Joined
Oct 22, 2009
Messages
2,803
I have not used SQL Express in a long time. Seem to remember this:
1. Setup your SQL Server in the Client Network Utility corresponding to the correct IP address and port number.
2. If that doesn't work try to reference your servers by IP Address, Port Number instead of the NetBios name.

There is a youtube 6 mintue video on this subject: How to allow remote connections to SQL Server Express

The check list should be:
Make sure that remote connections are enabled.
Make sure firewall isn't blocking.
Make sure users attempting to login have permission.

(Are you using SQL Server network authication or UN/PW rights?)
Make sure you have the instance name correct in the ODBC connection.


The firewall can be tricky.
This guidance was reported to help most people : http://support.microsoft.com/kb/914277


 

Users who are viewing this thread

Top Bottom