DSN-less connection to SQL server - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

DSN-less connection to SQL server

DSN-less connection to SQL server# Database - 数据库

b*u2002-03-22 08:03

1 楼

still old question:
I have a SQL server db and some Access front-end reports. I will have multiple
users that need to use the Access reports. I don't want to set system DSN for
everyone of them. because that would make it hard for me to modify my tables
since every time I would need to refresh the linked table for every computer.
So, I am trying to write a DSNless connection:
strCnct = "ODBC; DRIVER=SQL
server;SERVER=myServer;DATABASE=myDB;UID=myUser;PWD=myPWD"

DoCmd.TransferDatabase acLink,

k*d2002-03-22 08:03

2 楼

As what I know, ODBC is the only way for connection between SQL Server and
Access. Even you set up a connection string, Access still askes you for the
ODBC information including UID and PWD.
My suggestion is: set up a system DSN without login information, for all
users. When user uses access, it will ask user to input the login information.

multiple
for
computer.
still

【在 b******u 的大作中提到】

: still old question:
: I have a SQL server db and some Access front-end reports. I will have multiple
: users that need to use the Access reports. I don't want to set system DSN for
: everyone of them. because that would make it hard for me to modify my tables
: since every time I would need to refresh the linked table for every computer.
: So, I am trying to write a DSNless connection:
: strCnct = "ODBC; DRIVER=SQL
: server;SERVER=myServer;DATABASE=myDB;UID=myUser;PWD=myPWD"
:
: DoCmd.TransferDatabase acLink,

b*u2002-03-22 08:03

3 楼

Thanks a lot for your help.
I can do something like
strCnct = "ODBC; DRIVER={SQL
server};SERVER=ABC-SQL-01;DATABASE=ABC2;trusted_connection=yes"
As I understand it, the "trusted_connection=yes" is supposed to antomatically
use the UserName and Password that the person used to log into thier windows
boxes. This way I don't need a login screen...
sigh. but I still get same error...

information.
tables
"ODBC:

【在 k*******d 的大作中提到】

: As what I know, ODBC is the only way for connection between SQL Server and
: Access. Even you set up a connection string, Access still askes you for the
: ODBC information including UID and PWD.
: My suggestion is: set up a system DSN without login information, for all
: users. When user uses access, it will ask user to input the login information.
:
: multiple
: for
: computer.
: still

b*u2002-03-22 08:03

4 楼

This one I understand..What I am trying to get, is a DSN-less ODBC connection.
I assume it's not too hard to do. For example ADO/RDO are all doing this,
right?
information.
tables
"ODBC:

【在 k*******d 的大作中提到】

D*N2002-03-22 08:03

5 楼

Try distributing it with a file dsn.
[ODBC]
DRIVER=SQL Server
UID=myUser
PWD=myPWD
Trusted_Connection=NO
DATABASE=myDB
APP=MicrosoftAccess
SERVER=myServer
It'd still be an ODBC datasource but doesn't need setting up..

【在 b******u 的大作中提到】