SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

Problem Ms SQL and c_Auth.php

 
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
magv



Joined: 15 Oct 2009
Posts: 8
Location: México

PostPosted: Fri Oct 16, 2009 12:14 am    
Post subject: Problem Ms SQL and c_Auth.php

Hello greetings from Mexico ! Smile

I have the following problem

In Categories\Authentication Server

I', change dsn file to:
"C:\Archivos de programa\FirstSpot\datasource\SQL.dsn"

File contents:

[ODBC]
DRIVER=SQL Server
UID=sa
Address=PE-MARIO,1433
Network=DBMSSOCN
WSID=PE-MARIO
APP=Microsoft Data Access Components
SERVER=PE-MARIO
Description=BD Ms SQL


At the time i save the change marks the following error

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\Archivos de programa\FirstSpot\cfgmgr\c_Auth.php on line 579


I'm using Windows XP SP3, Microsoft SQL Server 2008 and FirstSpot v 6.0.4. trial.

Any suggestions
Back to top
alan
Forum facilitator


Joined: 26 Sep 2003
Posts: 4435

PostPosted: Fri Oct 16, 2009 4:52 am    
Post subject:

For some reasons, the password field is not generated by the ODBC Data Source Administrator.

Please add the following line in your dsn file:

PWD=your_database_user_password
_________________
~ Patronsoft Limited ~
Back to top
magv



Joined: 15 Oct 2009
Posts: 8
Location: México

PostPosted: Sun Oct 18, 2009 1:04 am    
Post subject:

Thanks !
_________________
El que nada hace nada teme !
Back to top
Display posts from previous:   
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group