Import using sqlsrv_connect and not mssql_connect

[Carbonize]

To clarify, php_sqlsrv.dll is working as an extension and can read the database, so only php code changes are required? or am i looking at this the wrong way?

In the interim, I tried using...

[Carbonize]

To cut a long story short, trying to import a forum from MSSQL to a new VB forum using Impex (again..)

Ive tried this on the actual web server but speed and various errors seem to upset and...

[Carbonize]

I wish to have a home page that relies on the User selected style.
eg - the home page shows no forum information, its just a welcome page.

What is the minimum 'container' code that...

[Carbonize]

I think we are now getting close. The file ntwdblib.dll in the php directory was an older version than the system32 file. With the latest file in the php directory, we generate an error thats easier to...

[Carbonize]

A working asp connection is :

dbUser = "**********"
dbPass = "**********"
dbName = "forum_pgd"
dbServer = ".\sqlexpress"
dbOwnerPrefix

...

[Carbonize]

Update - tried using php.sqlsrv_ts.dll and still no joy, also tested mssql.secure_connection=on

What other good methods are their to troubleshoot the connection? (Im an asp guy, not php...

[Carbonize]

Does phpinfo() provide any clues?
It seems to suggest some form of connection should be available?...

[Carbonize]

Would that be in the protocols?
Its setup for tcip / shared memory / named pipes if thats the case

mssql is using sql and windows authentication mode

[Carbonize]

Hi Jerry, not at this stage. The MySQL service was not running and was unused on this virtual server prior to playing with VB and mssql was only used with asp. So no apps have been used with php/mssql...

[Carbonize]

Hi guys, I m trying to import from ASPPGD in msSQL to mySQL

Impex : 1.88
VB : 3.6.8
MySQL : 5.0.27-community-nt
PHP : 5.2.0
Server : WINNT (virtual server)
Error...