SQL backend 
Author Message
 SQL backend

can anybody help me with the procedures i have to do with the ODBC
setup in order to connect to the SQL ?
thanks a lot
stephen


Thu, 20 Nov 2003 01:39:27 GMT  
 SQL backend
Hi Stephen,

First, you had better install MDAC 2.5 or 2.6 on your computer. You can
download them from www.microsoft.com/data

Then, run "Data Source (ODBC)" in control panel, In User DSN or System Dsn,
click Add, and select SQL server driver,  fill in the Name of the DSN and
the name of your SQL server.  Also, you need to specify the authentication
and network protocol.

In a VB program, you can add the ActiveX data object library to the
project, and use follwoing code to open a ADO connection:

Dim conn as new ADODB.connection

conn.Open "DSN=YourDSNName"



Thu, 20 Nov 2003 18:58:28 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. login into access and to sql backend

2. login into access forntend and to sql backend

3. Add/Delete records, access vs. SQL backend

4. Connect to SQL Backend which requires UserName/Password

5. creating unique logins for a sql-backend website

6. unique logins question for SQL backend website

7. Switching between Access and SQL Server backend databases

8. Using SQL Engine as Backend in a Commercial Application

9. Advice needed: multi-user app using SQL Server backend

10. Conversion of backend from Access to Sql Server??

11. Conversion of backend from Access to Sql Server??

12. Accessing reports in Access 2000 with SQL 2000 as Backend

 

 
Powered by phpBB® Forum Software