Search found 5 matches

by raymondkwoods
Thu Sep 01, 2005 9:41 pm
Forum: Databases
Topic: SQL state 37000? More database problems.
Replies: 1
Views: 2939

SQL state 37000? More database problems.

This is what I'm getting now: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: Provider DLL failed to initialize correctly. , SQL state 37000 in SQLConnect in Too long to list...
by raymondkwoods
Wed Aug 24, 2005 11:12 pm
Forum: Databases
Topic: Fatal error: Call to undefined function mssql_connect()
Replies: 4
Views: 3252

Solved problem

Okay I figured out what i was doing wrong. Either one of the following now works: include "adodb\adodb.inc.php"; $db =& ADONewConnection('odbc_mssql'); $dsn = "Driver={SQL Server};Server=DEVSERV;Database=test;"; $db->Connect($dsn,'test','test'); $sql = "SELECT test FROM ...
by raymondkwoods
Tue Aug 23, 2005 10:38 pm
Forum: PHP - Code
Topic: Global variables & includes / functions
Replies: 3
Views: 135

I would use a class

Fairly new to php myself but I would use a class as follows: include.php -------------- <?php class myClass { var $a; function myClass($a) { $this->a = $a; } function getVar() { return $this->a; } function setVar($a) { $this->a = $a; } } ?> Then just instantiate an instance of the class for each var...
by raymondkwoods
Sun Aug 21, 2005 9:10 pm
Forum: Databases
Topic: Fatal error: Call to undefined function mssql_connect()
Replies: 4
Views: 3252

System DSN and odbc_connect doesn't work either

I did reboot both servers and still got the same error. I also tried setting up a system DSN on the server that MS SQL Server is installed on and tried the following code: $dsn="testDSN"; $username="Administrator"; $password="password"; $sqlconnect=odbc_connect($dsn,$us...
by raymondkwoods
Sun Aug 21, 2005 2:59 am
Forum: Databases
Topic: Fatal error: Call to undefined function mssql_connect()
Replies: 4
Views: 3252

Fatal error: Call to undefined function mssql_connect()

Hello, New to PHP and to the forum. I am developing a commercial website in PHP 5 and have set up a small test network. I have one server running Windows NT 4.0 and ISS 4.0 and another with Microsoft SQL Server 2000 Personal Edition installed. I am doing all my development on a Compaq presario deskt...