ODBC connection

From: deodev <deodev@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 11 May 2005 09:26:07 -0700

Hello,

I have linked several tables to a database called sondb on the SQL server
called orlapp. I have used a DSN called MYAPP with userid and password of
"monthly"

Once I open the database and run my query I have to sgn on using the user id
and password.

I would like to use code to connect to the server without having to sign on
manually.

Can someone please let me know what the code should be.

--
deodev
.

Follow-Ups:
- Re: ODBC connection
  - From: Dave Patrick

Prev by Date: Re: How to make a "self-added" field in form or query?
Next by Date: SQL Syntax Problem
Previous by thread: problem with query
Next by thread: Re: ODBC connection
Index(es):
- Date
- Thread

Relevant Pages

Re: Login Tracking Table
... If you are planning to upsize to SQL server, I assume this is going to be a ... > I am designing an Access database that will eventually be moved to a SQL ... > table and have created a login tracking table for this purpose. ... > The primary key for the users table is called userid. ...
(microsoft.public.access.tablesdbdesign)
Re: Login Tracking Table
... If you are planning to upsize to SQL server, I assume this is going to be a ... > I am designing an Access database that will eventually be moved to a SQL ... > table and have created a login tracking table for this purpose. ... > The primary key for the users table is called userid. ...
(microsoft.public.access.gettingstarted)
Re: Database Auditing and connection strings
... We have a need to be able to perform auditing on the database side ... As part of the requirement we must know the userid ... 1) Using a standard ID and password in SQL Server but providing ... This might at least give us an idea as to why connection pooling ...
(microsoft.public.dotnet.framework.adonet)
Hard Code Native Error code in program?
... On sql server 2000 ... When I try to establish a connection to the database ... if the UserID does not exist or if the UserID does exist ... NativeError - 18456 The UserID does not exist ...
(microsoft.public.sqlserver.connect)
Re: High Throughput Database
... I think 3 tables will provide the same performance as one set per user as long as UserID is the the high-order column of each index. ... I was considering even making a new database per user. ... Perhaps go a different route and learn about load balancing, and how the sql server pooling will work. ...
(microsoft.public.sqlserver.programming)