Hello & Welcome to our community. Is this your first visit? Register

Results 1 to 1 of 1

Thread: SQL Server 2005

  1. #1
    Registered

    Rank
    Member
    Join Date
    Nov 2006
    Posts
    12

    SQL Server 2005

    I have SQL Server 2005 and IIS running on the hosting machine. So far it's been going well, but I've decided I want to move from using the access DB to using a SQL one.

    I cannot install mySQL on this machine.

    I've already imported the the access db into SQL Server and its called T4CDB, however. I'm lost at how to actually tell T4C to use that database instead of the access one. If I change the Data Source name from T4C Server in the T4C Server Setup to T4CDB, when I try log in, it says it can't find the authentication server. But it throws that error if I enter anything into that field, so I'm assuming it can't find the database.

    Any light you can shed on this will be greatly appreciated.

    EDIT: I figured it out. It was just simple lack of knowledge on how ODBC works, I just had to set up a ODBC Data Source in Administration Tools.
    Last edited by ClawedMonkey; 14-11-06 at 09:10 PM.

  2. # ADS
    HyperFilter
    RaGEZONE Sponsor

    Rank
      Sponsor  
    Join Date
    Sep 2013
    Posts
    9000


     

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 05:15 PM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.