To locate the 32-bit Office System drivers, use the appropriate version of the ODBC Administrator tool. In 64-bit versions of Windows, there is a separate ODBC Administrator used to manage 32-bit drivers and DSNs. This occurs when the 32-bit version of Office or the 32-bit Office System Drivers is installed on a 64-bit version of Windows. They are not visible in the standard ODBC Administrator dialog that is launched from the Administrative Tools dialog in the Control Panel. If this does not work speak to your DBA (database administrator) about the user credentials you should use to connect to the database.When attempting to create ODBC connections that utilize the Microsoft Office System Driver, such as connections to Access or Excel, on a 64-bit Operating system like Windows 7, the drivers are not visible. Using integrated security is the usual way to connect to a Microsoft SQL Server database. Speak to your database administrator (DBA) or network administrator. SQL Server defaults to port 1433, but a different port can be used. Please contact us at if you need to know the latest supported version of the ODBC drivers. Iguana may not always support the very latest version of the ODBC drivers:.Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc. Finally test the connection to see that the changes worked.Choose your default database from the drop list and click Next:.Select the Change the default database option:.Choose SQL Server Authentication, enter User and Password and click Next:.Choose the ODBC source and click Configure and click Next:.Modify the ODBC source to change Database and User:.User Login: Change to user billsmith with password something-secret.These are the two most common things to change:.If you need to modify the ODBC source follow these steps: If it does not work speak to your DBA about how to login to the database (user authentication).Database: You can specify the database that you want to use by default.Use Integrated Security: Sometimes you might want to use a SQL Server user and password. Speak to your DBA (database administrator) about changing these if necessary. There are two settings that you may need to change: Use Integrated Security and Database. The ODBC source will use all the standard defaults which will work in most cases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |